Determine Effective Savings Rate by Service

FOCUS Versions

v1.3 v1.4

Context

This use cases focuses on Effective Savings Rate (ESR) per Service.

The Effective Savings Rate is a KPI to track the efficiency of using commitment-based discounts. The KPI calculation is (Contracted Cost – Effective Cost) / Contracted Cost)

FOCUS SQL Query

SELECT
  ServiceProviderName,
  ServiceName,
  SUM(ContractedCost) AS ContractedCost,
  SUM(EffectiveCost)  AS EffectiveCost,
  (SUM(ContractedCost) - SUM(EffectiveCost)) / NULLIF(SUM(ContractedCost), 0) AS EffectiveSavingsRate
FROM focus_data_table
WHERE ChargePeriodStart >= ? AND ChargePeriodEnd < ?
GROUP BY ServiceProviderName, ServiceName

FOCUS Datasets

Contract Commitment Cost and Usage

FOCUS Columns

Service Provider Name Service Name Contracted Cost Effective Cost Charge Period Start Charge Period End

Previous Determine Effective Savings Rate Next Effective Cost by Service and Region