New analyses with Microsoft Power BI

Microsoft Power BI is an analysis tool that allows you to create powerful data visualisations easily and quickly – it’s like Excel on steroids. The BI stands for Business Intelligence and it’s used by many large business organisations to help them understand their data. It’s also incredibly useful for schools that want to analyse their pupil data. It doesn’t matter if your school uses SIMS, Arbor or Bromcom – Power BI can transfer your pupil data into graphs that can give impoirtant insights into your pupils.

Power BI has been around for a few years and some schools have already been using it. As an analysis tool, it’s very easy to create insightful graphs.

SIMS Schools

For SIMS users, the hard bit is exporting the data from SIMS and getting it in the right format to be used in Power BI. So Capita have released a set of batch files and SIMS reports designed to make the process of exporting from SIMS and importing into Power BI much simpler. 

Capita are calling the resources ‘SIMS Consolidated Reporting’ and they include routines to extract data from primary schools, secondary schools and MATs.

The MAT version of the resources extracts data from each school in the MAT and allows you to create analyses that span every school in the MAT. 

The analyses can also be amended to include your school’s own assessment data. The routines even allow for a degree of automation, so schools can update their analyses on a nightly basis.

I’ve included some examples of the analyses that come with the resources and you can sign up for the special Capita mailing list here:

You can read Capita’s blurb here: At the bottom of the page you’ll find a link to a recorded webinar by Capita’s John Christian which is highly recommended.

Once you have expressed your interest, Capita will send you a link to the resources and you can download them.

The great thing is there’s no charge for the SIMS resources. Microsoft Power BI desktop itself is free and downloadable now from Microsoft. If you just want to print out the finished analyses (or save them as a PDF), there’s no cost at all.

However, publishing the report in its full interactive online form does require a license. You can either a) purchase this Power BI license as part of the top tier Education Office 365 license (for which Microsoft charge £7 per user per month) or b) you can purchase a special education license for Power BI only for £1.70 per user per month. Either way, it’s not an expensive option.

Personally, I’m learning all I can about Power BI – there’s lots of information online. I’m also learning as much as possible about data visualisation – because many people think data analysis in schools needs to improve – and Power BI will give us access to better, more powerful analyses.

Arbor, Bromcom and iSAMS

If your school uses one of these MIS rather than SIMS, then the process is much easier – all of these systems have special Power BI connectors which link Power BI directly to your live pupil data, without the need to create csv files or run extra reports. Here’s an example of Bromcom’s Power BI solution.

Power BI Training and Consultancy

I’ve written a sequence of courses to take you from beginner to expert with Power BI – here’s the link: I also offer Power BI consultancy and off-the-shelf Power BI solutions on my other website https;//

Download the example files

You can download a fully working demo with instructions from MyAccount. For those of you without access to MyAccount I have provided access to a copy of Capita’s file here. Remember that this copy will not be kept updated and therefore you shouldn’t rely on it being the most up to date version – ask your local support unit for a password to MyAccount, or use the online application for a MyAccount password.

UPDATE 1: I’ve added some direct links to the zip files in MyAccount in the comments below this post. Also, many thanks to John Christian for updating me on the Microsoft licensing options.

UPDATE 2: Note that the resources from Capita are focused on helping schools extract their data and don’t include specific Power BI analyses – you have to create your own analyses from scratch – but Capita have also released example Power BI reports that you can copy.

UPDATE 3: I’ve released a free SIMS and Power BI course to help you get to grips with the key concepts of Power BI in a SIMS school. I recommend that you take the course before trying to implement the SIMS Consolidated Reporting resources. Did I mention it was free?