Get historical usage and rates to enable cost forecasting

FOCUS Versions

v1.3 v1.4

Context

While Finance will look at higher-level forecasting data such as amortized costs and total cashflow, a FinOps Practitioner needs to forecast costs from quantities of priced units and effective costs based on historical rates. Effective costs are used to account for the costs of commitment purchases.

This query extracts cost and usage data by Region and Service. More fine-grain extrapolation could be done based on further dimensions like Tags.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceCategory,
  ServiceName,
  RegionId,
  RegionName,
  PricingUnit,
  SUM(EffectiveCost) AS TotalEffectiveCost,
  SUM(PricingQuantity) AS TotalPricingQuantity
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd <= ?
GROUP BY
  ServiceProviderName,
  BillingPeriodStart,
  BillingPeriodEnd,
  ServiceCategory,
  ServiceName,
  RegionId,
  RegionName,
  PricingUnit

FOCUS Datasets

Contract Commitment Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Service Provider Name Billing Period Start Service Category Service Name Region ID Pricing Unit Effective Cost Pricing Quantity Billing Period End Region Name

FinOps Practitioner

Previous Forecast cashflow month over month based on historical trends by service Next Report subaccounts by region