Forecast amortized costs month over month based on historical trends

Context

Finance needs to perform month over month forecasting by extrapolating amortized costs based on historical rates. Having this data enables Finance to create amortized cost models.

FOCUS Columns

FOCUS SQL Query

SELECT
  MONTH(BillingPeriodStart),
  ProviderName,
  ServiceCategory,
  ServiceName,
  ChargeCategory,
  SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE BillingPeriodStart >= ?  AND BillingPeriodEnd < ?
GROUP BY
  MONTH(BillingPeriodStart),
  ProviderName,
  ServiceCategory,
  ServiceName,
  ChargeCategory