October 29, 2025 at 12:00 am
Comments posted to this topic are about the item Reducing Cloud Cost
October 29, 2025 at 3:36 pm
One of my past projects was creating a daily scheduled ETL job that downloads Azure billing data to a SQL Server data mart, and then someone on the DevOps team created a PowerBI dashboard for use by executive management and accounting to keep track of spending. It's very granular, for example we can see day to day Azure SQL scale out usage, CosmosDB request units, or storage costs for a storage container. Aside from the accounting aspect, it's also useful for operations just as an inventory for what resources are currently provisioned and what's actually being used (or not used). One thing we discovered is that telemetry and performance metrics data archived to Log Analytics can get very expensive, because accumulating 100s GB monthly is not necessarily expensive in terms of storage but can be for data ingress/egress charges.
Yes, we can use Azure Portal drill down on that usage / billing data for each resource, but analyzing it from a BI dashboard is a game changer.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply