Asset Library / FinOps Use Cases / Report costs by service category and subcategory
Understanding costs across providers, billing periods, and service categories (Analytics, Compute, Database, Storage, etc.) and service subcategories (Virtual Machines, Relational Databases, Content Delivery, etc) provides valuable insight into total costs.
SELECT ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? and BillingPeriodEnd < ? GROUP BY ProviderName, BillingCurrency, BillingPeriodStart, ServiceCategory, ServiceSubcategory ORDER BY TotalBilledCost DESC
The rate at which an organization is consuming or spending its allocated budget for cloud services from a CSP.
This rate provides insights into how quickly the organization is using up its budgeted funds for cloud resources and services. A higher burn rate indicates that the organization is consuming its budgeted cloud funds at a faster pace. This might be due to increased resource usage, additional projects, or unexpected costs. It can prompt the need for adjustments in resource allocation, optimization efforts, or budget reconsideration.
Lower Burn Rate: A lower burn rate suggests that the organization is spending its cloud budget at a slower pace than anticipated. This could mean that the allocated budget is sufficient, resources are being used efficiently, or cost-saving measures are effective.
Matching Burn Rate to Budget: If the burn rate closely matches the budget allocation over the specified time period, it indicates that the organization is on track with its spending plans.
Measure of success: Matching burn rate to budget.
(Actual Cloud Spending / Time Period)
Data Sources:
Related Capabilities
FinOps Practitioner
Reporting & Analytics
Budgeting