[Power BI] Create an Azure Hybrid Benefit Cost Savings View for Windows VM's.

[jamelachahbar]

📝 Scenario

As a FinOps practitioner, I need to monitor and track the cost savings of each Windows VM and the total savings after applying Azure Hybrid Benefit, in order to to evaluate the effectiveness and aggregate financial benefits of Azure Hybrid Benefit on Windows VMs.

💎 Solution

Addition of Key Performance Indicators (KPIs) to Power BI Reports for Azure Hybrid Benefit (AHUB) Analysis:

• [ ] Total cost savings per AHUB enabled Windows VM
• Formula: #Price Difference with Linux Meter Price * Quantity
• Objective: To quantify the total cost savings accrued per Windows VM utilizing Azure Hybrid Benefit over a specific period. This metric aims to provide clear insights into the financial benefits derived from the application of Windows Server Licenses to Windows VMs.
• Value: This KPI is crucial for evaluating the financial impact of Azure Hybrid Benefit on Windows VMs. It aids organizations in optimizing the allocation of Windows Server Licenses by highlighting effective usage and identifying potential new candidates for this benefit. Furthermore, it supports transparent reporting on the utilization of AHUB, helping to drive strategic decisions in cloud resource management.

ℹ️ Additional context

TODO: Add any other context or screenshots about the change request, including alternative solutions you considered and why you ruled them out.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

### Tasks
- [x] Import pricesheet table
- [x] Create custom column to generate common key between Linux and Windows Hardware Meters
- [x] Create a Common Key based on custom column and other available columns to generate a unique key
- [ ] Calculate Price Difference between Linux and Windows Hardware Meters based on this Common Key
- [ ] Create a separate Dimension Table with the added column showing the price difference
- [ ] Link this new table with the cost details table(FOCUS) in power BI

[jamelachahbar]

I will first create these transformations using Fabric notebooks. I will then evaluate if it makes sense to have a version where all transformations are done in Power BI queries. For large customers with a lot of data, this can be taxing on Power BI performance. Any opinion on this? @flanakin

Example(work in progress):

[flanakin]

We should probably keep it in Power BI for now. We're also looking at a full-Fabric version of the reports, but I'm hesitant to make that a blocker for adoption. Perhaps we could post a poll to get the community's thoughts. I'm open to whatever direction the community wants to take it.

[jamelachahbar]

Let me work on a Power BI version for now. Let us post a poll.

[jamelachahbar]

@flanakin, I have one challenge, the pricesheet I exported is big. Do we have a good sample datasets that I can test with, that can be used and is not too large? Any ideas on how to leverage without making the powerbi file too big. I was thinking of using Azure Data Factory to create a separate pipeline for this and export in parquet format to ADLS, unless there are other plans on parallel tracks related to this.