How data is processed in FinOps hubs From data cleanup to normalization, FinOps hubs do the work so you can focus on driving business value.
FinOps hubs perform a number of data processing activities to clean up, normalize, and optimize data. The following diagram shows how data flows from Cost Management into a hub instance:
sequenceDiagram
Cost Management->>msexports: ① Export data
msexports->>msexports: ② msexports_ExecuteETL
msexports->>ingestion: ② msexports_ETL_ingestion
Power BI-->>ingestion: ③ Read data
- Cost Management exports raw cost details to the msexports container.
- The msexports_ExecuteETL pipeline kicks off the extract-transform-load (ETL) process when files are added to storage.
- The msexports_ETL_ingestion pipeline transforms the data to a standard schema and saves the raw data in parquet format to the ingestion container.
- Power BI reads cost data from the ingestion container.