microsoft / microsoft/finops-toolkit

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

Open
#695 4 comments 1 reaction 1 assignee View on GitHub

@jamelachahbar is already working on this.

Since Jun 5, 2024.

Tool: Power BI Type: Feature 💎
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:

  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

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.