Verify accuracy of services charges across providers
Context
In order to verify that the charges found in the FOCUS dataset match those of the providers invoices a FinOps Practitioner can aggregate cost data from providers per service for a billing period and compare it to individual service charges found inside invoices.
FOCUS Columns
FOCUS SQL Query
SELECT ProviderName, BillingAccountId, BillingAccountName, BillingCurrency, ServiceName, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY ProviderName, BillingAccountName, BillingAccountId, BillingCurrency, ServiceName
Related KPIs
Frequency of Data Updates
Time (hours/days) between updates of cost data, e.g. the time since the last ETL run or sharing of data.
This time will become shorter at higher levels of maturity. It may be days or a month when done manually at the Crawl phase. At the Run phase, internal cost updates may happen as frequently as the CSP provides new data (e.g. AWS = up to 3x/day) or intentionally slower to reduce ETL execution cost.
Formula
Data Update Frequency = Time of Latest Cost Update – Time of Previous Cost Update
Data Sources:
- CSP Billing Data
- ETL system
Related Capabilities
ETL Processing Time
This measures the cycle time taken to complete the ETL (Extract, Transform, Load) processes.
It should be faster than the frequency of data updates to avoid obsolete data being presented.
Formula
Processing Time = End Time – Start Time
Data Sources:
- ETL system logs
- ETL interface for process timestamps
Related Capabilities
Cost Visibility Delay
Time (hours/days) between the cost occurring and the cost being ingested, normalized, and displayed back to cloud stakeholders.
This time is shorter at higher levels of maturity. At the Crawl phase, it may be around one month. At the Run phase, internal cost updates happen as frequently as the CSP can provide accurate data (e.g. AWS = 2 days).
Formula
Cost Visibility Delay = Time of Displaying Cost – Time of Cost Generation
Data Sources:
- CSP Billing Data
- ETL system
Related Capabilities
Related Personas
FinOps Practitioner
Related Capabilities
Data Ingestion