Updated for Summer 2022

Power BI for Schools

Clear, insightful analysis of your school data.  Visually appealing and user-friendly. Easy to share with colleagues. Secure, available across all devices and always reliable. Works with SIMS, Bromcom and Arbor. Built with Microsoft Power BI.

Whole School Summary

A snapshot of your school as others may see it. All the information on this screen comes directly from your pupil database and can be viewed by key stage, year group or registration group.

Comparing this year's attendance with last year

If you need to see this year’s attendance overlaid against last year’s attendance and even the year before’s attendance, you need this graph.

Unauthorised absences

Unauthorized absences are difficult for a school to control. Power BI makes it easy to keep track of the trends in your school.

Pupil Demographics

Analyse your pupil demographic data by pupil premium, SEN, FSM, Summer Born and many other metrics. Show facts and figures as precentages or pupils counts. Right-click to find out the names and more details of each pupil. The data is also presented as a table.

Attendance Gauges

Get instant attnendance statistics for all your most vulnerable pupil groups. Each gauge uses conditional formatting to give a traffic lights system of red (below 90%), amber (90-94%), green (95-99%) and blue (100%) attendance bands.

Attendance Statistics

See percentage attendance by  year group, drill up to key stage or down to registration group. See how many pupils fall into each attendance band. Identify persistent absentees. Drill through to pupil attendance details.

Attendance Bands

List each pupil in a league table style report. Identify pupils with the highest attendance and pupils who are persistent absentees. Intervene early to solve attendance problems. Celebrate good attendance.

National Comparisons

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Drill though to pupil details

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

Interactive help

Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

School Analytics is a set of Power BI visualizations for schools that shows your pupil data in new ways and helps you drive school improvement. It provides cost-effective, consolidated analysis for your school and it integrates with SIMS, Arbor, Bromcom and other pupil databases.

k

Pupil First

Pupil details are never more than a click away. So you know the pupils behind the statistic.

Insightful

Power BI visualisations give a very clear picture of your school’s data.

Secure

Pupil data is hosted on Microsoft’s secure servers and integrates with Office 365.

Shareable

Instant access for your entire senior team. View analyses on PC, tablet or mobile phone.

Beautiful

School data looks well presented, clear and aesthetically pleasing. No clutter.

Accurate

Data is imported quickly and directly from SIMS or other MIS. Choose your own data update schedule.

New ways to see your school data

See the deeper trends that make your pupils unique. School Analytics looks at your school’s SEN, pupil premium, FSM pupils and a wide range of other key pupil indicators and lets you make informed decisions about your most vulnerable pupils.

Power BI Venn diagram

Why POWER BI for SCHOOLS?

Because SIMS, Bromcom, Arbor and all the other pupil databases can no longer keep up with our need for data analysis. Schools need tools that are more flexible than one pupil database supplier could ever provide. Power BI provides this, and more.

POWER BI Advantages

Power BI can bring together data from multiple sources, including your school pupil database, but also from your HR system, your finance system, or even a simple Excel spreadsheet. All these data sources can be brought into a single Power BI report and analyses side-by-side. School Analytics uses data from your pupil database and from Excel to provide a level of analysis that hasn’t previously been available to schools.

  • Easy data export from your pupil database.
  • No spreadsheet tweaking required.
  • No admin time required – can be fully automated.
  • Cost effective – from £295 with no annual subscription.
  • Always available.
  • Always up to date.

NEXT Steps

You will find pricing and ordering details here. For more information email david@schoolanalytics.co.uk