THE LINUX FOUNDATION PROJECTS
FOCUS Logo
See what is coming in v1.5 FOCUS 1.5
Docs navigation
On this page

    Analyze resource costs by SKU

    This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.

    FOCUS Versions

    v1.0 v1.1 v1.2

    Context

    Understanding the highest costing SKUs can help multiple personas in an organization achieve goals, such as:

    1. Contract negotiation: Procurement teams can use this information to negotiate the best possible discounts with cloud providers.
    2. SKU-based forecasting: Product and Finance teams can use this information to forecast future demand for SKUs and plan accordingly.
    3. High unit-cost cleanup: FinOps teams can use this information to identify and prioritize SKUs with high unit costs, which can be optimized or eliminated to reduce overall cloud spend.

     

    FOCUS SQL Query

    SELECT
  ProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice,
  SUM(PricingQuantity) AS TotalPricingQuantity,
  SUM(ListCost) AS TotalListCost,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
  ProviderName,
  ChargePeriodStart,
  ChargePeriodEnd,
  SkuId,
  SkuPriceId,
  PricingUnit,
  ListUnitPrice
ORDER BY
  ChargePeriodStart ASC
LIMIT 100

    FOCUS Datasets

    Cost and Usage

    FOCUS Columns

    Provider Name Charge Period Start Charge Period End SKU ID SKU Price ID Pricing Unit List Unit Price List Cost Pricing Quantity Effective Cost

    Related Capabilities

    Reporting & Analytics Forecasting Usage Optimization

    Related Personas

    Finance Procurement Product FinOps Practitioner

    Related KPIs

    Percentage of Normalized, Queryable Data within Repository Calculate percentage of normalized and queryable data in data warehouse, repository, or similar, vs Accounts Payable Invoice.
    Percentage Resource Utilization Measure of cloud compute resource utilization, e.g. Compute (EC2), Block Storage (EBS), or Object Storage (S3).
    Percentage of Legacy Resource Measure of the percentage of resources running on ‘modern’ types (e.g. instance types, volume type).
    Auto-scaling Efficiency Rate Measures effectiveness of an auto-scaling system.
    Forecast Accuracy Rate (Spend) This metric compares forecasted vs. actual cloud spend over a specific period (e.g., day, month, quarter).
    Previous Analyze marketplace vendors costs Next Analyze service costs by subaccount