Analyze costs by service name

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 a service, 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
  BillingPeriodStart,
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName,
  SUM(BilledCost) AS TotalBilledCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ServiceName = ?
  AND BillingPeriodStart >= ? AND BillingPeriodStart < ?
GROUP BY
  BillingPeriodStart,
  ServiceProviderName,
  SubAccountId,
  SubAccountName,
  ServiceName

FOCUS Datasets

Billing Period Cost and Usage Invoice Detail Contract Commitment

FOCUS Columns

Billing Period Start Service Provider Name Sub Account ID Sub Account Name Service Name Billed Cost Effective Cost

FinOps Practitioner

Previous Verify accuracy of provider invoices aka invoice reconciliation Next Analyze service costs by region