Secondary schools and MATs usually need a bespoke solution. Here is a demo system to give you some ideas for your school’s Power BI analysis. It contains lots of ideas – you might want to use all or some of these suggestions. And remember that Power BI is so flexible that many other analyses are possible, even if you don’t see them here. So if you have an idea for an analysis, just ask and I’ll let you know if it’s possible.


Drill Down

Drill down from whole school,  year group and to class.

Drill through

Go from a key stage or a year group directly to a list of pupils.

Cross filter

Click on a data point and see how it affects other graphs.


Your SIMS data can be exported quickly and automatically up to eight times per day, so it’s always up to date. Bromcom and Arbor already have Power BI integration which makes the process even easier.