Analyze service costs by region

FOCUS Versions

v1.3 v1.4

Context

Analyzing Service level spending trends over a time period can expose expected and unexpected growth in the consumption of various services, by region, across all service providers and is a good way for the FinOps team to prioritize usage and rate optimization conversations with product, engineering and finance leaders within the organization.

FOCUS SQL Query

SELECT
  ChargePeriodStart,
  ServiceProviderName,
  RegionId,
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ChargePeriodStart,
  ServiceProviderName,
  RegionId,
  ServiceName
ORDER BY ChargePeriodStart,
  SUM(EffectiveCost) DESC

FOCUS Datasets

Cost and Usage Contract Commitment

FOCUS Columns

Charge Period Start Service Provider Name Region ID Service Name Effective Cost Charge Period End

FinOps Practitioner

Previous Analyze costs by service name Next Compare resource usage month over month