Learning Management System Dashboard using Power BI

ATNZ was created in 1999 to provide dedicated and focused training for apprentices in the engineering and manufacturing industries. From humble origins in Hawkes Bay, ATNZ expanded quickly to become a national organisation and is now New Zealand’s largest employer of apprentices in mechanical engineering and related industries. ATNZ employs over 370 apprentices throughout New Zealand, hosted by over 170 companies.

As part of the work we have already completed for ATNZ this was phase 2 of their data journey. Speaking to the CEO, who was excited after the delivery of Selma's reporting and was interested in exploring the options with Canvas (learning management system) data.

Solution

Our initial goal with this project was to understand Canvas API, our data engineering team worked on calling Canvas API data and creating automated data pipelines to Azure Blob Storage. Once the data was available, we worked with ATNZ team to understand the business requirements. We ingested the data into Power BI via Azure Blob Storage and developed the data model. Post this, we continued the development of the dashboard, giving regular check-ins with the team.

Outcomes

• Partnering with the SLT and Account management team, we developed an interactive Power BI Dashboard to better manage student submissions.

• ATNZ were able to gain visibility and leverage a new data source

• Automated data flows to remove any manual data efforts

Check out our project reviews on:

https://simpleanalytics.co.nz/reviews