Power BI in Schools

Simplify data reporting


Transform the way your school collects, manages and reports data.

Leverage the full potential of Microsoft Power BI in your school and save staff time, reduce costs and improve student outcomes.

microsoft power bi dashboards

School Power BI report
How to create great Power BI reports

The best Microsoft Power BI reports and dashboards are simple. They turn large sets of tabular data into user friendly...

More...


Solve the data challenge in your school

We understand the challenges that schools face - schools are data rich envronments, but they are short on time and often have limited technical resources.

Our Microsoft Power BI service for schools combines technical expertise and education domain knowledge. It's tailormade to get you maximum value from Microsoft Power BI in an education context. Our service offer includes:

  1. Expert advice on how to organise data across different systems for simpler reporting.

    Find out how to consolidate and integrate data from different systems so you can then report on that data in Power BI.

  2. A fast and friendly report authoring service.

    Kickstart your Power BI reports and dashboards. When we write reports for you we also explain how the reports were built - knowledge is cascaded to your team.

  3. Setup and configuration of the Power BI online service.

    Take full advantage of Power BI to create a data driven culture across your school. We show you how to use the Power BI online service to share interactive reports and dashboards with colleagues - staff, school governors and other stakeholders.

  4. Training for school leaders, data managers and other staff.

    Develop an achievable Power BI roadmap for your school. Begin authoring interactive reports and dashboards.


Find out more about our Microsoft Power BI service for schools and MATS

Contact Us


Slicer visualization in Power BI - filtering by date with help from a simple measure

Slicer visualization in Power BI - filtering by date with help from a simple measure

Here's how you can use the slicer visualization and a simple measure to filter time based data. The data is basic school attendance data....

More...
Power BI in schools - how can you report on data from multiple MIS databases?

Power BI in schools - how can you report on data from multiple MIS databases?

The real challenge for any school that wants to use a tool like Microsoft Power BI to analyse and report on data is how to get at data that is spread across different application databases - you want a solution that doesn’t involve lots of copy and pasting between different spreadsheets....

More...
Power BI in schools - a student performance dashboard

Power BI in schools - a student performance dashboard

This is another look at how you could build a very simple Power BI report to track student performance. There are two tables of data – both imported into Power BI Desktop from an Excel Workbook. Power BI Desktop automatically joins the two tables on StudentId...

More...



Power BI in schools - a simple way to look at student attainment

Power BI in schools - a simple way to look at student attainment

This is one way of looking at student performance in Power BI. It’s a simple report built on top of single table of data about students and how they score in assessments. Three things about the dashboard are worth noting:...

More...
Visualising school performance in Microsoft Power BI

Visualising school performance in Microsoft Power BI

It’s easy to get hold of schools performance data about schools in England - data is available for download from the Department for Education website. This post uses the latest end of Key Stage data - the provisional dataset for 2016/17. You can find it here...

More...
Scatter Plots School Performance Power BI

Scatter Plots, School Performance and Microsoft Power BI

A scatter chart in Microsoft Power BI a great way to the relationship between two values. You plot 2 sets of numbers as a series of xy points and then look for patterns in the data - trends, clusters and outliers....

More...



Why data analytics with Microsoft Power BI might just be great for your school

Why data analytics with Microsoft Power BI might just be great for your school

You can use Microsoft Power BI to turn your in-house data into interactive data dashboards and reports. It’s now one of the top two or three business intelligence tools...

More...
A first look at the UK HE longitudinal education outcomes dataset with Microsoft Power BI

A first look at the UK HE longitudinal education outcomes dataset with Microsoft Power BI

How easy it to compare the earnings of graduates from different universities? Does a computer science graduate from Durham University make more money than one from the the University of Sheffield...

More...
The best way to develop Microsoft Power BI reports for schools

The best way to develop Microsoft Power BI reports for schools

The best Microsoft Power BI reports and dashboards are simple. They turn large sets of tabular data into user friendly, interactive visualisations that...

More...