Absence Maps in Power BI

An Absence Map can display the names and addresses of all the pupils absent TODAY, within minutes of morning registers closing. They allow your pastoral staff to take a very proactive approach to absence – by literally knocking on doors. Here’s how they...

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 and Teacher Assessed Grades

How can Power BI can help teachers decide on teacher assessed grades?With many pupil databases it can be difficult to analyse the latest teacher assessed grades next to results from previous exam seasons. With Power BI, this becomes relatively easy, synthesising data...

Measuring attendance in school using Power BI

As school leaders will already know, improving attendance rates in schools can be very difficult. Most schools have an attendance rate of between 95 and 96 percent. Getting an improvement of just one percentage point in the attendance rate requires a range of...
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...
School Analytics and Chris Quigley Assessment

School Analytics and Chris Quigley Assessment

The School Analytics system is easy to configure to fit with many of the different assessment frameworks used by schools. Several schools have asked me to re-configure the basic School Analytics system to use with Chris Quigley Milestones. Here’s an example...