Risk Matrix (Microsoft Excel)

This is a Risk Matrix dashboard in Excel. This was a Workout Wednesday Challenge (Week 10, 2022). The dataset used is an open dataset from the City of Phoenix containing information about claims made against the city.

Following the instructions, I analyzed the data using Power Query at the cause level and calculated scores based on the number of claims and cost per claim with three levels of risk: High, Medium, and Low.