Provincial Ministry Committee

Metrics strategy and dashboard for 300+government-funded agencies

A Committee within a Provincial Ministry in the Government of Ontario came to AAARL with a problem: increasing the adoption of analytics and data metrics in their consortium of agencies, as it was critical to the success and growth of the sector. AAARL performed a literature review, conducted stakeholder interviews, and surveyed existing processes to build a set of tools to be distributed to more than 300 agencies in the sector. Subsequently, AAARL helped promote the tools through speaking engagements at relevant forums. As well, AAARL hosted four workshops to give users hands-on practice with the tools and a chance to ask questions.

The set of tools include one excel template with metrics categories for users to input, as well as a dashboard template created in Qlik Sense that pulls the data and creates data visualizations. They were also given a complete manual, explaining how the tools can be best used.