Verify accuracy of services charges across providers
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.0
v1.1
v1.2
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 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,
ServiceNameFOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
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.
ETL Processing Time
This measures the cycle time taken to complete the ETL (Extract, Transform, Load) processes.
Cost Visibility Delay
Time (hours/days) between the cost occurring and the cost being ingested, normalized, and displayed to stakeholders.