---
title: "FinOps uses case with FOCUS and superset"
description: "This guide provides step-by-step instructions on configuring your Data Project to take your first steps inside the FinOps with a FOCUS file"
url: https://docs.ovhcloud.com/es/guides/public-cloud/data-platform/tutorials-finops-focus-superset
lang: es
lastUpdated: 2026-09-14
---
> For AI agents: the complete documentation index is available at https://docs.ovhcloud.com/es/llms.txt, the full documentation bundle is available at https://docs.ovhcloud.com/es/llms-full.txt.

# FinOps uses case with FOCUS and superset

## Objective

This guide provides step-by-step instructions on configuring your Data Project to take your first steps inside the FinOps with a FOCUS file.

![Banner](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/banner.png)
## Overview

[FOCUS](https://focus.finops.org/) is a specification inside the FinOps world to expose data consumption throughout multiple cloud providers. This guide will provide an example on how to consume this kind of file inside the Data Platform, and leverage the power of superset to create useful dashboards.

## Requirements

Before beginning, ensure you have:

- An active OVHcloud account with billing access

## Step-by-Step configuration

## 1. Retrieve the FOCUS file

We need to have a FOCUS formatted file to develop this use case. You can easily extract a CSV file with your OVHcloud account consumption by following this link: [OVHcloud Focus Extractor](https://finops.labs.ovh.net/).

![1. Retrieve the FOCUS file — Finops lab](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/finops-lab-1.png)
You can login on the interface through the OVHcloud SSO. This tool is a POC developped by our OVHcloud internal team meanwhile we are working to provide a more standard way to extract a FOCUS formatted file.

![1. Retrieve the FOCUS file — Finops lab (2)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/finops-lab-2.png)
Once logged, you can click on "Load Services Consumption".

![1. Retrieve the FOCUS file — Finops lab (3)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/finops-lab-3.png)
When the table is created, you can now click on "Export to CSV" to extract a complete file with your consumption.

![1. Retrieve the FOCUS file — Finops lab (4)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/finops-lab-4.png)
You have now a FOCUS formatted CSV that can be loaded inside the Data Platform

## 2. Load the FOCUS file inside the Lakehouse

### 2.1. Create the Data Source

You can now go to the [`Data Platform`](https://eu.dataplatform.ovh.net), inside the `Project` of your choice, then `Connectors` section, and to finish `Sources` in order to create a new `File Upload` source.

![2.1. Create the Data Source — Datacatalog](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/datacatalog-1.png)
You can name your source `focus`, and add the `export.csv` file you downloaded inside the previous step. You can now click on `Create`.

![2.1. Create the Data Source — Datacatalog (2)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/datacatalog-2.png)
Now the file is loaded, you can go into the `Explorer` section, and then click on your new source `finops` and then start the analysis of the file on clicking `export.csv`. After few seconds, your file should be analyzed successfully.

![2.1. Create the Data Source — Datacatalog (3)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/datacatalog-3.png)
### 2.3. Load the data into the Lakehouse

You can now go into the `Lakehouse Manager` section, and then `Tables`. You can hit `New Table` and `Create from a Connectors source`. Select your `export.csv` file, then hit `next`, rename the table into `consumption` and `create`.

![2.3. Load the data into the Lakehouse — Lakehouse](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/lakehouse-1.png)
![2.3. Load the data into the Lakehouse — Lakehouse (2)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/lakehouse-2.png)
![2.3. Load the data into the Lakehouse — Lakehouse (3)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/lakehouse-3.png)
![2.3. Load the data into the Lakehouse — Lakehouse (4)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/lakehouse-4.png)
## 3. Create the Superset Application

Now all the data is ready to be analyze in the Lakehouse, you need to create the Apache Superset Application. You can do so by following [this tutorial](https://docs.ovhcloud.com/es/guides/public-cloud/data-platform/tutorials-install-apache-superset.md).

Considering this tutorial, we consider you followed it until the `Step 5: Create your first Chart` and until the \`3. New Dataset' where you create the Dataset for:

- Database: `trino`
- Schema: `Default dataset`
- Table: `consumption`

![3. Create the Superset Application — Dataset](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/dataset-1.png)
You can now hit `Create Dataset and create dashboard`

## 4. Create the Charts

For now, we are going to create multiple charts, always from the same process:

- Click `Charts`, then `+ Chart`
- Chose the dataset `consumption`

We are going through multiple chart you can create:

### Effective cost - current

- Type: `Big number with Trendline`
- Temporal axis: `billingperiodstart`
- Metric: `Billed Cost` aggregate `SUM`
- Comparison Period Lag: `1`
- Show timestamp: true

![Effective cost - current — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-1.png)
### Effective cost - previous month

- Type: `Big number`
- Metric: `Billed Cost` aggregate `SUM`
- Filters: `billingperiodstart` with `Range type: advanced` as per the screenshot
- Display settings
  - Subtitle: `1 month ago`

![Effective cost - previous month — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-2.png)
![Effective cost - previous month — Chart (2)](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-3.png)
### Effective cost - 2 month

- Type: `Big number`
- Metric: `Billed Cost` aggregate `SUM`
- Filters: `billingperiodstart` with `Range type: advanced` and `- 3 month` and `-2 month`
- Display settings
  - Subtitle: `2 month ago`

![Effective cost - 2 month — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-4.png)
### Most popular region by effective cost

- Type: `World Cloud`
- Dimension: `regionname`
- Metric: `billedcost` with aggregate `SUM`

![Most popular region by effective cost — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-5.png)
### Total accounts

- Type: `Big number`
- Metric: `billingaccountname` aggregate `COUNT DISTINCT`
- Filters: `billingperiodstart` with `Last Month`
- Display settings
  - Subtitle: `Previous month`

![Total accounts — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-6.png)
### Total services

- Type: `Big number`
- Metric: `resourceid` aggregate `COUNT DISTINCT`
- Filters: `billingperiodstart` with `Last Month`
- Display settings
  - Subtitle: `Previous month`

![Total services — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-7.png)
### Total providers

- Type: `Big number`
- Metric: `resourceid` aggregate `COUNT DISTINCT`
- Filters: `billingperiodstart` with `Last Month`
- Display settings
  - Subtitle: `Previous month`

![Total providers — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-8.png)
### Effective cost per service

- Type: `mixed chart`

- X-Axis: `billingperiodstart`

- Time Grain: `Month`

- Query A:
  - Metrics: 'billedcost' with aggregate 'SUM'
  - Dimension: `Custom SQL` with `CONCAT(servicecategory, '-', servicesubcategory)`
  - filters: `billingperiodstart`

- Query B:
  - Metrics: 'billedcost' with aggregate 'SUM'
  - filters: `billingperiodstart`

- Customize:
  - Query A:
    - Serie type: `Bar`
    - Stack serie: `true`

![Effective cost per service — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-9.png)
### Cost repartition per service category and subcategory

- Type: `sunburst chart`

- hierarchy: `servicecategory` and `servicecategory`

- primary metric: `billed cost`

- Filters:
  - `billingperiodstart`: 'Last month'

![Cost repartition per service category and subcategory — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-10.png)
### Service Category Effective cost per region

- Type: `Sankey chart`
- Source: `region name`
- Target: `servicecategory`
- Metric: `billedcost`
- Filters: `billingperiodstart`

![Service Category Effective cost per region — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-11.png)
### Effective cost per sub account name

- Type: `Partition Chart`
- Metrics: `billedcost` aggregate by `SUM`
- Filters: `billingperiodstart`
- Dimensions: `billingaccountname`, `subaccountname`, `servicecategory`

![Effective cost per sub account name — Chart](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/chart-12.png)
## 5. Create the Dashboard

Now you have a lot of charts, you can put them together into a single place: the Dashboards. Click on `Dashboard`, then `Create`. You can name your dashboard `Billing Summary`, and drag and drop all the charts you previously created to finalize the view.

![5. Create the Dashboard — Banner](/images/public-cloud/data-platform/getting-further/finops-focus-superset/pics/banner.png)
## Conclusion

By following these steps, you can effectively configure and utilize the OVHcloud Data Platform to implement your first advanced FinOps use case based on the FOCUS format.

## Go further

If you need training or technical assistance to implement our solutions, contact your sales representative or click on [this link](https://www.ovhcloud.com/es-es/professional-services/) to get a quote and ask our Professional Services experts for a custom analysis of your project.

Ask questions, give your feedback and interact directly with the team building the Data Platform on the dedicated [Discord channel](https://discord.gg/ovhcloud).

If you need support with your OVHcloud services, create a request in our [Help Centre](https://help.ovhcloud.com/csm?id=csm_get_help).

Join our [community of users](https://community.ovhcloud.com/).