The FinOps Foundation has released its newest and most technical certification: the FinOps Certified FOCUS Analyst. Unlike the general "Practitioner" exam, this test is hands-on. It validates your ability to actually work with the FinOps Open Cost and Usage Specification (FOCUS)—the industry standard for normalizing billing data across AWS, Azure, Google Cloud, and SaaS .

If you are a Data Analyst or FinOps Engineer, this is the badge that proves you can build the "Single Pane of Glass."

What is Covered?

The exam focuses on the FOCUS 1.2 Specification. You must demonstrate proficiency in three areas:

1. Schema Knowledge: Differences between BilledCost, EffectiveCost, and ListCost.

2. Normalization Logic: Mapping provider-specific concepts (like AWS Savings Plans) to standardized CommitmentDiscount columns.

3. SQL Querying: Selecting the correct SQL queries to answer business questions .

Key Concepts to Master

1. The "Cost" Columns You must understand the four pillars of cost in FOCUS:

• ListCost: The market price (MSRP).

• BilledCost: What you actually pay (Cash basis).

• ContractedCost: The price based on your EA/EDP discounts.

• EffectiveCost: The amortized cost including discount sharing (Accrual basis). This is the most important column for reporting .

2. Handling Discounts Understand how PricingCategory distinguishes between Usage, Purchase, and Tax, and how CommitmentDiscountId links a usage row to the savings plan that covered it .

3. Provider Neutrality The exam tests your ability to think multi-cloud (e.g., mapping GCP Projects to FOCUS SubAccounts) .

Preparation Strategy

1. Download the Spec: Read the official FOCUS 1.2 PDF, paying attention to "Attribute Definitions."

2. Use the Sandbox: Load the FinOps Foundation's FOCUS Sandbox CSVs into Excel or BigQuery to practice answering business questions.

3. Practice SQL: Be comfortable with GROUP BY, SUM, and WHERE clauses using standard column names .