microsoft / microsoft/finops-toolkit
[Power BI] Add cost summary KPIs
Open
Nobody has claimed this yet.
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 the average price of each resource type in order to quantify the ROI for workloads running on those resources
💎 Solution
Add the following KPIs to Power BI reports:
- Average cost per hour of compute
- Formula: #Total spend of Virtual Machines resources / #total time used
- Objective: To measure the average cost of running instances during the period.
- Value: This metric provides insights into the value of resources being used. It helps organizations assess the purchase process and to enhance its effectiveness into the selection and assignation of available services in the public cloud.
🙋♀️ 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.
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.
Research direction
Start by locating the Power BI reports and the existing cost and Virtual Machines measures. Confirm how total spend and total usage time are represented before defining the average cost-per-hour KPI. Done means the report includes the compute average-cost KPI for the stated period and its value can be checked against the supplied formula.
Written by the indexing model from the issue text.
Assessment
- Domain
- analytics, data-visualization
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100