School Analytics Blog
Analysing pupil prior attainment in Power BI
Introduction When it comes to education, the prior attainment of pupils is a key factor in determining their future success. Understanding the prior attainment of pupils, and how it has been achieved, is crucial for teachers, parents and other education professionals...
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 with school data...
Business Intelligence for Schools and Multi Academy Trusts
Introduction Many schools and multi academy trusts are looking to improve their data analytics capabilities. Business intelligence tools like Microsoft Power BI can help you take your data to the next level with automated insights and visualisations that generate new...
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
https://youtu.be/hTsEDAHDqVo 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...
This year’s attendance vs last year’s attendance
Schools often need to compare this year's attendance against last year's attendance. Power BI gives us powerful new ways to analyse data, one of which is showcased by this visualization which allows schools to compare the percentage attendance this year, last year and...
Are unauthorized absences increasing in your school?
Unauthorized absences are difficult for a school to control. By definition, they are absences that you can't sanction, that still happen when you've had a word with parents about school time holidays, or even set fines. You may or may not have a problem, but what's...
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 they work......