Скачать или смотреть Replicating an Excel Maintenance KPI Matrix in Power BI Pt4 - KPI Grouping Headers using Power Query

Grouping your KPIs into logical sections makes the dashboard far easier to read than simply displaying a long list in a table.

In this video, I explain how to use power query APPEND QUERIES option to import the KPI grouping headers into Power BI from the source Maintenance KPI Excel file.

I also talk you through the updates you required in the data model to allow you to create headers for each of the groups of maintenance KPIs in the row-based matrix.

Other videos in the series:

Video 1: How to Import Row Based KPI data From Excel to Power BI using Power Query - Maintenance KPI Example -    • How to Import Row Based KPI data From Exce...  

Video 2: Formatting a MATRIX of Maintenance KPIs Imported from Excel into Power BI - Pt2-    • Formatting a MATRIX of Maintenance KPIs Im...  

Video 3: Adding KPI Target Values to a Maintenance KPI Matrix & How to Set the Display Format for Each - Pt3 -    • Adding KPI Target Values to a Maintenance ...  

-----------------------------------------------------
🎓 Power BI Dashboard Training
-----------------------------------------------------
👉FREE Power BI Quick Start Course - Learn how to create your first dashboard in around 90 minutes!
https://effectivedashboards.com/power...

👉 Power BI Quick Start PLUS - Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
https://effectivedashboards.com/power...

-------------------------
Resources
-------------------------
👉Access to the source PBIX files
https://effectivedashboards.com/cours...

👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
https://effectivedashboards.com/data-...