Asset Library / FinOps Use Cases / Determine Effective Savings Rate by Service
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)
SELECT ProviderName, ContractedUnitPrice, PricingQuantity, EffectiveCost, ((ListCost - EffectiveCost)/ListCost) AS ESROverList, ((ContractedUnitPrice - EffectiveCost)/ContractedUnitPrice) AS ESROverContract FROM focus_data_table WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
Return on investment metric of all commitment discounts by commitmentDiscountId / commitmentDiscountName, commitmentDiscountStatus, commitmentDiscountType, etc..
Data Sources:
Average cost, after amortization of unused commitment discounts, of each Core per calendar month.
(Effective Cost + Unused Commitment Discount Cost + Compute Cost) / Total number of Cores
Data Sources:
FinOps Practitioner
Reporting & Analytics
Rate Optimization 