A Senior Leader’s Guide to Power BI in Schools

A Senior Leader’s Guide to Power BI in Schools

I’m often asked to talk to senior leaders in UK schools about the benefits of Power BI. Here are some of the key advantages that I can see for schools and MATS who are considering Power BI: Data Visualization: Power BI allows senior school leaders to create...
A Senior Leader’s Guide to Power BI in Schools

Analysing Pupil Attendance with Power BI

Introduction As a school administrator or senior leader, tracking the attendance of pupils is a crucial part of ensuring their success. Since COVID there has been a focus on attendance, which for many schools has still not returned to pre-pandemic levels. This is...

Academic Weeks in Power BI using DAX

Working in school environments we often encounter time perios that are completely unique, terms and academic years spring to mind, and each of these needs a differnt approach to the more commonly used DAX formulae. Another example of this is the concept of an academic...
Power BI dashboards for SIMS

Power BI dashboards for SIMS

This article is reprinted and updated from davidpott.com. Here’s the first page of my School Analytics pupil dashboard. It’s built using SIMS and Power BI – where SIMS provides the raw data and Power BI provides the analysis and visualisation – and it is intended to...