Stage 2 · Lesson 7 of 7

Your first billing query

Once billing data is in a table, answers questions the console cannot: cost by tag and service for the last 90 days, the top 20 resources by cost, or week-on-week change per team. Start with three queries you will reuse: total by month and service, total by team tag including an "untagged" bucket, and top resources this month.

Check that your monthly total matches the before trusting any other query. on a laptop is enough for sample files; Athena, BigQuery or handle real exports.

Common trapa query that silently drops rows with a missing tag, so the totals look smaller than the bill.

A question to check yourself, an AI practice session and 1 cheat sheet entry come with the full roadmap. Unlock

Resources for this stage

Start with· follow one of these

CourseFree
Microsoft Learn FinOps modules
Microsoft · Beginner
Free: the "Understand cloud usage and cost" unit of Adopt FinOps on Azure
BookPaid
Cloud FinOps, 2nd edition (O'Reilly)
O'Reilly Media · Intermediate · Paid book
Paid: the chapters on allocation and tagging strategy explain the reasoning behind a good policy

Practise

Microsoft FinOps toolkit
Free sample cost exports to practise queries on, whichever cloud you chose
DuckDB Documentation
Query a billing CSV or Parquet file with SQL on your laptop, no database to set up

Keep handy

Microsoft Cost Management documentation
The official Cost Management, Billing and Advisor docs for every Azure tool named in this stage
FOCUS: the FinOps Open Cost and Usage Specification
Learn the common column names now; they make every provider's export easier to read

Also worth your time

Tutorial: Create and manage Cost Management exports (opens in a new tab)Read
Datasets, schedules, formats and how to backfill past months
Kimball Dimensional Modeling TechniquesGo deeper
If you will build cost data models, the classic patterns for facts and dimensions apply directly