Azure Cost Management Dashboard

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Microsoft-Logo-768x251.png

Author introduction

Hi, I am Saira Shaik, Working Principal customer success account manager at Microsoft India.

 

Azure Cost Management Dashboard

I created this Dashboard to display the units consumed and the respective cost for Selected filters.

 

This Dashboard will be helpful for any Azure Customer, irrespective of their contract agreement with Microsoft. 

 

Customers can view their usage and cost by uploading the Usage files into this Power BI file. You can download .pbit file and setup instructions from Setup 

 

Please note that all the screenshots on this page are mock-up screens; hence each screen data will differ. These screens are captured to show you what the screen looks like based on the data you will be uploading.

 

Azure Cost Management Dashboard

This Dashboard helps customers to understand the billing details, including monthly bill, monthly usage cost, and monthly purchase cost, along with the number of units each Service consumed and the respective cost by Services running on On Demand or Reservations or Savings Plan with the Top 5 drivers contributing to the cost. These drivers are the Top 5 Subscription Names, Top 5 Instance Types, and Top 5 Locations. Customers can view details of any Service monthly and daily insights of usage and respective cost with a granular level of drill down to Resource Name.

 

Filtering

Customers can filter the Usage details by Meter Category / Service, Meter Subcategory / Instance Type, Date, Subscription Name, Tags, Resource Location, Resource Group, and Resource Name. These filters can be helpful if you need to view usage and cost based on specific criteria. For Example, Customers want to view the usage details by specific subscriptions or based on particular tags or months.
pic1.png

Monthly Usage and Purchases Dashboard

This dashboard displays Monthly usage cost, purchase cost, and service cost for selected filters from the filters dropdown section.

Monthly Cost View

Monthly billed amount for selected filters from the Filters dropdown section

pic2.png

Monthly Usage Cost View

Monthly usage cost for selected filters from the filters dropdown section

pic3.png

Monthly Purchase and Refunds Cost View

Monthly purchase and refund cost for selected filters from the filters dropdown section, followed by all the purchases made.

pic4.png


pic5.png

 

Monthly Usage and Cost by Service

Cost by Meter Category month-wise with a granular filter to drill down to see Subscription Names, Resource Locations, Resource Groups, and Resource Names.
pic6.png

Daily Usage and Purchases Dashboard

This dashboard displays Daily usage cost, purchase cost, and service cost for selected filters from the filters dropdown section.


Daily Usage Cost

Chart displaying the day-wise cost for selected filters from the filters section.

pic7.png


Daily Purchase and Returns

Chart displaying the day-wise purchase and refund costs for selected filters from the filters section.

pic8.png


Daily Cost by Service

Chart displaying the day-wise costs for selected filters from the filters section.

pic9.png


Resource Level View Dashboard

Detailed resource details of units ran on On Demand, Reservations, Savings Plan, Top 5 Subscription Names, Top 5 Instance Types, and Top 5 Resource Locations drivers contributing cost.

pic10.png


Daily Usage Units and Cost for On Demand, Reservations, and Savings Plans

Chart displaying the number of units consumed and the respective cost day-wise for selected filters from the filters section, followed by the display of 4 tables:

  • Daily Usage Units and Cost - All the services
  • Daily On-Demand Usage Units and Cost - Services running on On-Demand only
  • Daily On Reservations Usage Units and Cost- Services running on Reservations only
  • Daily On Savings Plan Usage Units and Cost - Services running on Savings Plan only


Each table above displays Meter Categories, consumed units, and respective cost month and day wise, with a granular drill down of Meter Name, Month, Subscription Names, Resource Locations, Resource Groups, and Resource Names. The month column in the table will be helpful when multiple months are selected from the Date dropdown filter to view the cost of each month.
pic11.png
Daily On Demand, Reservations, and Savings Plans display of consumed units and respective costs will be the same as the below Chart.

pic12.png

Top 5 Subscriptions drivers contributing to the cost

Chart displaying the top 5 Subscription Names contributing to the cost day-wise, followed by a table consisting of all the Subscription Names, Meter Names, Resource Locations, Resource Groups, and Resource names to view how many units each resource utilized along with cost day-wise.

 

pic13.png

pic14.png

Top 5 Instance Types drivers contributing to the cost

Chart displaying the top 5 Instance types / Meter Names contributing to the cost day-wise, followed by a table consisting of all the Meter Names, Subscription Names, Resource Locations, Resource Groups, and Resource names to view how many units each resource utilized along with cost day-wise.


pic15.png

pic16.png

Top 5 Resource Locations drivers contributing to the cost

Chart displaying the top 5 locations contributing to the cost day-wise, followed by a table consisting of all the Resource Locations with a granular drill down of Subscription Name, Meter Name, Resource Group, and Resource name to view how many units each resource utilized along with cost day-wise.

pic17.png

pic18.png

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.