Power BI Visual Guide #9 - Scatter Chart Pt2 - Creating a Risk Matrix Using a Scatter Chart
11.1 هزار بار بازدید -
3 سال پیش
-
In this video, I explain
In this video, I explain how to create a risk matrix using a scatter chart.
I've created videos and courses (linked below) on how to create a risk matrix in Power BI before. However, this is a different approach and allows for a higher granularity and overlaying the description of risks on a matrix.
I also explain how to configure the Power BI scatter chart so that the size of each dot represents the age of the risk and the colour represents the cost to mitigate the risk, in effect showing 4 different measures on one plot. - Risk Severity, Risk Likelihood, Age of risk and finally cost to mitigate.
This approach is better suited to displaying a smaller number of risk, probably up to 10 so would be ideal for a summary of the top 10 risks for a company, project, safety concerns or defects on an item of equipment.
------------------------
Related videos
------------------------
Risk Management Dashboard - Power BI Case Study - Building an Equ...
Power BI Visual #9 - Scatter Chart Pt1 - Cost Optimisation Using a Scatter Chart and Analytics Lines
Power BI Visual #9 - Scatter Chart Pt...
-----------------------------------------------------
🎓 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 for my YouTube videos:
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-...
I've created videos and courses (linked below) on how to create a risk matrix in Power BI before. However, this is a different approach and allows for a higher granularity and overlaying the description of risks on a matrix.
I also explain how to configure the Power BI scatter chart so that the size of each dot represents the age of the risk and the colour represents the cost to mitigate the risk, in effect showing 4 different measures on one plot. - Risk Severity, Risk Likelihood, Age of risk and finally cost to mitigate.
This approach is better suited to displaying a smaller number of risk, probably up to 10 so would be ideal for a summary of the top 10 risks for a company, project, safety concerns or defects on an item of equipment.
------------------------
Related videos
------------------------
Risk Management Dashboard - Power BI Case Study - Building an Equ...
Power BI Visual #9 - Scatter Chart Pt1 - Cost Optimisation Using a Scatter Chart and Analytics Lines
Power BI Visual #9 - Scatter Chart Pt...
-----------------------------------------------------
🎓 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 for my YouTube videos:
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-...
3 سال پیش
در تاریخ 1400/03/24 منتشر شده
است.
11,136
بـار بازدید شده