Skip to content
All workshops

Private, hands-on workshops with the toolkit maintainers

FOCUS & KQL

The FinOps toolkit’s FOCUS data model and the KQL to analyze it, worked through on your own cost records.

You bring

Your cost questions, FOCUS basics, and your own FinOps toolkit hub if you have one.

We build together

Queries against your own cost records, from the FinOps toolkit data model to a library your team keeps.

You leave with

A reusable KQL query library built on your own cost records, and a team that understands the FinOps toolkit data model well enough to keep extending it.

Is this for you?

  • Your analysts wait for reports someone else builds
  • Cost questions die in the backlog
  • You want the querying skills in-house, not on retainer

What we’ll work through

We work through how the FinOps toolkit implements FOCUS, the trade-offs behind that model, and the datasets your hub already holds. Then we write KQL against your own cost records: joins, your own and external tables, and the analysis that goes well past a summarize.

  • How the FinOps toolkit implements FOCUS, and the modeling trade-offs behind it
  • The datasets your hub already holds, and what each one is good for
  • KQL patterns for cost analysis: filtering, summarizing, and joining
  • Bringing your own and external tables into the picture
  • Your questions, turned into queries, on live data
  • Going further: forecasting and statistical anomaly detection in KQL
  • Where FOCUS goes next, from the working group

What stays with your team

  • A reusable KQL query library on your own cost records
  • Answers to the cost questions you brought along
  • The FinOps toolkit’s FOCUS model and its trade-offs, understood by the people who query it
  • Query patterns for joining your own and external data

What the price covers

Included

One FinOps toolkit hub and the cost questions you bring. We cover the FinOps toolkit’s FOCUS implementation and its trade-offs, the datasets already in the hub, KQL patterns including joins, linking your own and external tables, and the analysis KQL makes possible such as forecasting and statistical anomaly detection.

What we tailor to you

Which of your questions we turn into queries, and which of your own or external data sources we join into them.

If you need more than this

Productionizing a new data source, or building the reporting layer on top, is where the Build your own dashboard workshop picks up, and we are happy to scope that with you as its own piece of work.

Build your own dashboard

Related workshops