Our mission was to develop an impact & probability matrix in order to visualize and analyze risks and status on different projects in a simple and interactive way.

‍

In project management, it is standard to use a risk management matrix. Not infrequently, it is created in Excel, where one axis shows probability and the other negative impact. In this way, risks are visualized and plotted out. We needed to create the same matrix for Power BI.

Since there is currently no visualization for risk matrices in Power BI, we had to think outside the box: the result was a combination of Scatter chart and custom graphic elements. The data source needed to be able to be updated by project managers directly in Teams and raw data smoothly washed and adapted and then loaded into the data model.

‍

"... when you saw the strength of the visualization of the risks, you just want more... and the discussions are done with the right focus..."With the help of customized graphic elements and creative problem solving, together with Almi, we created a fully interactive risk matrix in Power BI, which today is used by both project managers and group management.

In the report you can filter and turn all the data, and quickly get information and a clear overview. Here you will see the status of all project risks and the possibility is to delve into the details of each risk.