microsoft / microsoft/finops-toolkit
[Power BI] Create an Azure Hybrid Benefit Cost Savings View for Windows VM's.
@jamelachahbar is already working on this.
Since Jun 5, 2024.
- Dominant language
- PowerShell
- Stars
- 603
- Forks
- 249
- Avg merge
- 7d 11h
- Merged PRs (30d)
- 11
Description
📝 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:
- Please vote this issue up (👍) to prioritize it.
- 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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.