Posted: May 22, 2020


The University of Alberta was completing a Literacy Research Program in three different Alberta school divisions to better understand how literacy education could be improved.  This program required three separate testing cycles throughout the year with teachers spending 50 hours to collect and validate student’s score per cycle.  This 150 hours per year was a significant challenge to scaling the program and the final product reporting needed to improve usability and interactivity.


Scott Mckenzie set out to reduce the time associated with this reporting through the utilization of better tools and automated reporting. Microsoft Power BI and Office 365 were identified as cost effective, easily accessible tools that could solve this problem if applied correctly.

  • An iterative approach that engaged stakeholders allowed users to feel a part of the development process and increased adoption
  • Processes were built to ensure this approach could be utilized in other schools using the Literacy Testing model


Untitled 3

The time to complete the data collection and validation dropped by 80% from 150 hours / year to 30 hours / year.  This was a time and cost savings of 80% throughout the year

  • The process was now scalable and transferable to other schools with 12 schools currently using the system across Alberta
  • This reduction in time resulted in Teachers championing the Literacy Testing program

Start Now. Start With Pontem.

Book a 30 minute demo where we’ll walk you through interactive reporting examples that are most relevant to your business.

Related Articles


The Power of An Executive Dashboard

McNish wanted to consolidate their information from different parts of their business into an Executive Dashboard that could provide both a high level snapshot of company performance and a detailed view of operational results. See how we did it.
Read More »
Csf pic3

Unlocking the Value of Data

Pontem Innovations has worked with CSF over the last 6 months to develop automated asset and agency performance reports that organize key metrics into insightful, easy to understand dashboards.
Read More »