I have taken control of a very messy safety management system at work. I'm working on creating a dashboard using pivot charts and slicers to make the KPI's easiy visualised without excessive manual input.
The biggest problem I'm having is that in fields such as Cause and Department I'm faced...