Analysing Pupil Attendance with Power BI

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...

Pupil attendance patterns in Power BI

Introduction How can we use Power BI in the fight to reduce pupil absence? In May 2022 the DfE launched a new initiative to improve attendance rates in schools – “Working together to improve school absenteeism”. The challenge for those of us who work...

Installation from Power BI App

Before you start To install, customize, and distribute the School Analytics template app within your school, you need: A Power BI pro license.Permissions to install template apps on your tenant. If you are not sure, contact the person in your school who is responsible...

Using Microsoft Forms with Power BI

Many schools are using Microsoft Forms to gather the results of questionnaires sent out to parents, staff and pupils. Schools can also create forms that allow surveys, quizzes, and polls and even formative assessment, with different levels of difficulty that are...

Pupil Absence Maps in Power BI

A Pupil 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...

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...