SIMS + Power BI: Intermediate Skills

Create advanced Power BI analyses for your school automatically from SIMS

  Enroll in Course


Microsoft Power BI is an exciting way to create very deep and informative analysis of school data. This course will show you how to integrate Power BI with your secondary school's SIMS system and help you find new insights into your pupils. On this course you will learn how to extract data from SIMS and import it into Power BI. Once your data is in Power BI you'll find out how to create interactive visualisations that help your staff find new insights into their pupils. Learn Power BI with over 8 hours of video lectures on this self-paced course.

Who should take this course

This course is aimed at data managers, business managers, SIMS coordinators and senior leaders in secondary schools who have some experience of using SIMS with Power BI and who want to develop their skills further.

What you will learn from this course

By the end of this course you will be able to:

  • Extract data from your SIMS system
  • Import the data into Microsoft Power BI
  • Process and shape the data from SIMS into the best format for analysis
  • Create amazing analyses of your pupil data in Power BI
  • Automate the whole process to run termly, weekly or even daily updates
  • Understand the key concepts of Power BI, including calculated columns, measures, filters and slicers

This course shows you how to analyse the following information from SIMS:

  • Pupil data
  • Internal assessment grades and targets
  • Subject and class attainment
  • Attendance
  • Behaviour
  • Exclusions
  • External exams
  • Key stage 2 data

Learn how to create these analyses

By the end of the course you will be creating analyses like these:

Course Curriculum

  Useful information about this course
Available in days
days after you enroll

"May I take the opportunity to thank you for what was a comprehensive, enlightening and instructive set of courses? It has saved a lot of time in learning the intricacies of PBi and will result in a impact on school data."

- Phil Segal, Perins School, Alresford

"Good course David. Very focused for SIMS schools analysis. I recommend this course, Thanks."

- Peter Allen, South Gloucestershire Council via Facebook

Your Instructor

David Pott
David Pott

I'm an independent SIMS consultant working with primarily with SIMS Assessment Manager for nearly 10 years. I spend lots of time in different schools, talking about the best ways to use SIMS and creating effective assessment systems. I run a popular assessment manager blog full of tips and trick for data managers in schools. I also supply an off-the-shelf assessment system.

Frequently Asked Questions

When does the course start and finish?
You can start the course immediately and take the lectures at your own pace.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact me for a full refund.
Can I pay by invoice?
Yes, you can use a school invoice. Email the invoice to [email protected] - if possible, please include a purchase order reference number.
Can I pay by debit/credit card?
Yes, just go through the usual checkout process.
Do I need a copy of Microsoft Power BI?
Yes, but Power BI is free - google it to download it to your PC before we start the course.

Get started now!