FOCUS-Analyst
Coming Soon
Expected availability announced soon
This course is in active development. Preview the scope below and create a free account to be notified the moment it goes live.
FOCUS Analyst (FOCUS-Analyst)
The FinOps Certified FOCUS Analyst program teaches data analysts, billing specialists, and FinOps practitioners how to apply FOCUS specifications, column library, and pipeline techniques to analyze cost and usage data, driving informed financial decisions.
60
Minutes
40
Questions
75
Passing Score
$400
Exam Cost
Who Should Take This
It is designed for mid‑level data analysts, billing operations staff, and FinOps engineers who already handle cost‑tracking datasets and seek to formalize their analytical workflow. Learners aim to certify their ability to build, optimize, and scale FOCUS‑based pipelines, enhancing organizational cost‑visibility and strategic budgeting.
What's Covered
1
Domain 1: FOCUS Specification Fundamentals
2
Domain 2: FOCUS Column Library
3
Domain 3: Practical FOCUS Data Analysis
4
Domain 4: FOCUS Data Pipeline and Adoption
5
Domain 5: Advanced FOCUS Analysis Techniques
What's Included in AccelaStudy® AI
Adaptive Knowledge Graph
Practice Questions
Lesson Modules
Console Simulator Labs
Exam Tips & Strategy
20 Activity Formats
Course Outline
61 learning goals
1
Domain 1: FOCUS Specification Fundamentals
2 topics
FOCUS Purpose and Design
- Explain the purpose of the FinOps Open Cost and Usage Specification as an open standard that normalizes billing data across cloud providers and technology vendors into a consistent format.
- Describe the FOCUS versioning history from 1.0 through 1.3 and explain how each version expanded the specification with new columns, datasets, and provider support.
- Explain how FOCUS enables FinOps practitioners to write a single set of analysis instructions that work across multiple providers instead of maintaining provider-specific query logic.
- Analyze the challenges of cross-provider billing data analysis without FOCUS and evaluate how the specification addresses inconsistencies in terminology, granularity, and cost calculation methods.
FOCUS Data Model Structure
- Differentiate between FOCUS dimension columns and metric columns and explain how dimensions categorize charges while metrics quantify costs, quantities, and prices.
- Explain the two FOCUS dataset types: Cost and Usage (the primary billing dataset) and Contract Commitment (the supplemental commitment terms dataset) and describe their relationship.
- Describe the FOCUS column requirement levels (required, recommended, optional) and explain how data generators comply with the specification at different conformance levels.
2
Domain 2: FOCUS Column Library
5 topics
Cost and Pricing Columns
- Differentiate between ListCost, ContractedCost, EffectiveCost, and BilledCost columns by explaining how each represents a different stage of pricing from public retail through invoiced amount.
- Explain the relationship between ListUnitPrice, ContractedUnitPrice, and PricingQuantity columns and demonstrate how to calculate line-item costs from unit prices and quantities.
- Apply ConsumedQuantity and ConsumedUnit columns to measure actual resource consumption independently from pricing dimensions to identify utilization patterns and waste.
- Analyze the difference between BilledCost and EffectiveCost for commitment-discounted resources and explain how amortization spreads upfront payments across the commitment term.
Resource and Service Columns
- Apply ResourceId, ResourceName, and ResourceType columns to identify and categorize individual cloud resources for granular cost attribution and waste detection analysis.
- Apply ServiceName, ServiceCategory, and ServiceSubcategory columns to group costs by service type and create service-level cost breakdowns that are consistent across cloud providers.
- Explain RegionId and RegionName columns and use them to analyze geographic cost distribution patterns and identify opportunities for region-based cost optimization.
- Apply Tags column to filter and aggregate costs by business dimensions and evaluate tag coverage completeness across the FOCUS dataset for allocation accuracy assessment.
Account and Charge Columns
- Apply BillingAccountId, SubAccountId, and their associated name and type columns to map charges to organizational hierarchy levels for multi-account cost attribution.
- Differentiate between ChargeCategory values (usage, purchase, tax, credit, adjustment) and ChargeClass (correction) to correctly categorize and filter billing line items for analysis.
- Apply ChargeFrequency and ChargePeriodStart and ChargePeriodEnd columns to correctly aggregate costs across billing periods and handle one-time versus recurring charges.
Commitment Discount and Contract Columns
- Apply CommitmentDiscountId, CommitmentDiscountName, and CommitmentDiscountType columns to identify and categorize commitment-based discounts in FOCUS billing data.
- Analyze CommitmentDiscountStatus to track unused commitments and evaluate utilization rates of Reserved Instances, Savings Plans, and Committed Use Discounts across the portfolio.
- Apply Contract Commitment dataset columns including ContractId, ContractCommitmentCost, and ContractPeriod dates to analyze active commitment terms and remaining obligations.
Allocation and Provider Columns
- Apply AllocatedMethodId, AllocatedResourceId, and AllocatedTags columns to understand how data generators split shared costs across workloads and evaluate allocation methodology transparency.
- Differentiate between ProviderName, ServiceProviderName, HostProviderName, and PublisherName columns to distinguish billing relationships in marketplace, reseller, and multi-cloud scenarios.
- Apply SkuId, SkuPriceId, and SkuMeter columns to perform granular rate analysis and identify pricing variations including tiering, discount application, and promotional rates.
3
Domain 3: Practical FOCUS Data Analysis
5 topics
Cost Allocation and Chargeback Analysis
- Construct FOCUS queries that allocate costs to business units using SubAccountId, Tags, and AllocatedTags to produce accurate showback and chargeback reports.
- Analyze unallocated and shared costs in a FOCUS dataset by identifying charges without tag attribution and designing rules to distribute shared infrastructure costs proportionally.
- Design a comprehensive chargeback model using FOCUS data that handles direct resource costs, shared platform costs, and commitment discount amortization across consuming teams.
Budgeting and Forecasting with FOCUS Data
- Construct FOCUS queries to track budget adherence by comparing BilledCost aggregated by ChargePeriod against established budget targets for each organizational unit.
- Analyze FOCUS historical cost data to identify spending trends, seasonal patterns, and growth rates that inform accurate cloud spend forecasts for upcoming budget periods.
- Design a FOCUS-based forecasting methodology that combines historical trend analysis with commitment coverage projections and planned workload changes to predict future costs.
Anomaly Detection and Cost Investigation
- Construct FOCUS queries that detect cost anomalies by comparing current period BilledCost against historical baselines at the ServiceName, ResourceId, and SubAccountId dimensions.
- Analyze a FOCUS dataset cost spike by drilling down through ServiceName, ResourceType, RegionName, and ConsumedQuantity to isolate the root cause of an unexpected cost increase.
Cross-Provider Comparison
- Construct FOCUS queries that compare equivalent service costs across AWS, Azure, and GCP using standardized ServiceCategory and ServiceSubcategory dimensions.
- Analyze multi-provider FOCUS data to identify cost efficiency differences across providers and recommend workload placement strategies based on comparative unit costs.
- Design a unified multi-cloud cost reporting framework using FOCUS that provides consistent visibility across all providers with standardized metrics and dimensions.
Unit Economics and Optimization Analysis
- Construct FOCUS queries that calculate unit economics metrics by combining EffectiveCost with business telemetry data to derive cost per transaction, customer, or API call.
- Analyze commitment discount coverage and utilization using FOCUS data to identify underutilized reservations and recommend commitment portfolio adjustments.
- Design a FOCUS-based optimization dashboard that highlights idle resources, commitment gaps, and rate optimization opportunities using ConsumedQuantity, EffectiveCost, and CommitmentDiscountStatus.
4
Domain 4: FOCUS Data Pipeline and Adoption
3 topics
Data Pipeline Construction
- Configure cloud provider billing exports (AWS CUR, Azure Cost Management, GCP Billing Export) and map their native columns to FOCUS-conformed format for centralized analysis.
- Implement data quality validation checks on FOCUS-conformed datasets including completeness verification, column conformance testing, and cross-referencing against provider invoices.
- Analyze data freshness and completeness gaps in a FOCUS data pipeline and recommend remediation strategies to ensure timely and accurate billing data availability for stakeholders.
- Design an end-to-end FOCUS data pipeline that ingests billing exports from multiple providers, normalizes to FOCUS format, validates data quality, and stores in a query-optimized data store.
Provider-Specific FOCUS Adoption
- Map AWS Cost and Usage Report columns to their FOCUS equivalents including lineItem/BlendedCost to BilledCost and lineItem/ResourceId to ResourceId for AWS-specific FOCUS adoption.
- Map Azure Cost Management export columns to their FOCUS equivalents including CostInBillingCurrency to BilledCost and ResourceId to ResourceId for Azure-specific FOCUS adoption.
- Map GCP billing export columns to their FOCUS equivalents including cost to BilledCost and resource.name to ResourceId for GCP-specific FOCUS adoption.
- Analyze discrepancies between provider-native billing data and FOCUS-conformed output to identify mapping limitations, data loss risks, and provider-specific columns that lack FOCUS equivalents.
FOCUS Adoption Strategy
- Evaluate vendor FOCUS conformance by assessing which providers and tools natively support FOCUS-formatted exports and which require custom transformation logic.
- Design an organizational FOCUS adoption roadmap that prioritizes high-value use cases, identifies required data pipeline changes, and establishes success metrics for FOCUS migration.
- Analyze the organizational impact of FOCUS adoption including reduced query maintenance burden, improved cross-team data literacy, and simplified onboarding for new cloud providers.
5
Domain 5: Advanced FOCUS Analysis Techniques
4 topics
Time Series and Trend Analysis
- Construct FOCUS queries that aggregate costs across BillingPeriodStart and ChargePeriodStart dimensions to produce daily, weekly, and monthly cost trend visualizations.
- Analyze month-over-month and quarter-over-quarter cost growth rates using FOCUS time dimensions to identify accelerating spend areas and forecast budget pressure points.
- Design a FOCUS-based cost trending framework that combines historical analysis with moving averages and variance detection to provide early warning of cost trajectory changes.
Rate and Pricing Analysis
- Construct FOCUS queries using SkuPriceId and PricingCategory columns to identify the effective discount percentage achieved across different resource types and service categories.
- Analyze the gap between ListCost and EffectiveCost at the service and resource level to quantify savings achieved through negotiated contracts and commitment discounts.
- Design a rate optimization tracking dashboard using FOCUS data that monitors discount coverage, utilization, and savings trends to inform commitment purchase decisions.
Data Governance and Reporting Standards
- Implement data governance policies for FOCUS datasets including access controls, data retention periods, and audit trails that ensure billing data integrity and compliance.
- Analyze FOCUS data quality metrics including column completeness rates, tag coverage percentages, and allocation accuracy to assess overall data reliability for financial reporting.
- Design standardized FOCUS reporting templates for executive, finance, and engineering audiences that present cost data at appropriate levels of detail and business context.
SaaS and Non-Cloud Data in FOCUS
- Apply FOCUS to SaaS and marketplace billing data by mapping vendor-specific invoice fields to FOCUS columns and handling subscription-based pricing models within the specification.
- Analyze the challenges of conforming non-standard billing sources (SaaS platforms, data centers, on-premises software) to FOCUS format and evaluate completeness tradeoffs.
- Design a total technology cost view using FOCUS that integrates cloud, SaaS, and on-premises billing data into a unified dataset for holistic organizational cost analysis.
Scope
Included Topics
- All topics in the FinOps Certified FOCUS Analyst curriculum: FOCUS specification fundamentals, FOCUS data model and column library, cost and usage data normalization, cross-provider billing analysis, and practical query construction on FOCUS-conformed datasets.
- The FinOps Open Cost and Usage Specification (FOCUS) versions 1.0 through 1.3 including the 77 columns across account dimensions, allocation dimensions, billing metrics, charge dimensions, commitment discount columns, contract dimensions, location columns, pricing columns, resource columns, service columns, SKU columns, and timeframe columns.
- Practical data analysis skills using FOCUS-conformed datasets including chargeback and showback implementation, cost allocation, budgeting, forecasting, anomaly detection, and cross-provider cost comparison using standardized billing data.
- FOCUS adoption strategies including data pipeline construction, provider-native export configuration for AWS, Azure, and GCP, data quality validation, and mapping proprietary billing columns to FOCUS standard columns.
- Advanced FOCUS analysis including commitment discount tracking via CommitmentDiscountId and CommitmentDiscountStatus, contract commitment datasets, SkuPriceId-based rate analysis, and allocation method transparency columns.
Not Covered
- Foundational FinOps Framework principles, lifecycle phases, and organizational concepts already covered by the FinOps Certified Practitioner certification.
- Engineering-level cloud infrastructure optimization, CI/CD pipeline integration, and infrastructure-as-code practices covered by the FinOps Certified Engineer certification.
- Advanced strategic FinOps practice management, organizational change leadership, and multi-cloud governance frameworks covered by the FinOps Certified Professional certification.
- AI-specific cost management including GPU cost allocation, model training versus inference billing, and token-based cost analysis covered by the FinOps for AI certification.
- Database administration, data warehouse design, and general SQL programming beyond what is needed to query and analyze FOCUS-conformed billing datasets.
Official Exam Page
Learn more at FinOps Foundation
FOCUS-Analyst is coming soon
Adaptive learning that maps your knowledge and closes your gaps.
Create Free Account to Be Notified