2024/2025 Service Definition

SIMS and Power BI Data Analysis Setup


What is it?

This consultancy service is to help schools use the powerful data analysis tool Microsoft Power BI to analyse specific data extracted from SIMS.

Why do I need it?

Power BI enables schools to view and analyse their data in a meaningful and impactful manner.

Current analysis options available which are included in the setup are:

  • School Attendance Analysis reports.
  • Individual Student Attendance Analysis reports.
  • Weekly tracking reports.
  • Court reports.
  • Overview of information for OFSTED, for example, identify weekly attendance trends to see where timely intervention can improve attendance.
  • Easily identify key cohorts (FSM, PP, Gender, SEN) who are impacting whole school attendance so that specific interventions can be introduced.

What are the benefits?

  • No more running multiple SIMS reports to obtain meaningful data.
  • No need for Excel spreadsheets to manipulate data.
  • Allows senior leaders to have well informed conversations with OFSTED.
  • Data protected by Microsoft 365 cloud security.
  • The consultancy session will be scheduled at a date and time convenient for your school.

What is included?

With the help of one of our School Applications Support team, our SIMS and Power BI Data Analysis Setup Service is designed to give school staff the peace of mind knowing the setup of their Power BI data analysis report is complete. As part of the consultancy, we will:

  • Import and run through the Report Definition setup.
  • Demonstrate the use of the SIMS Report Command Script.
  • Import the Power BI Report.
  • Setup the Power BI Cloud Service Gateway via your Microsoft 365 tenancy.
  • Give an overview of what each report displays and how to drilldown to obtain more information.
  • Show how to refresh the data between SIMS and Power BI.
  • Microsoft 365 Power BI Cloud Service Gateway Installation for two users.
  • Provide documentation showing you how to add more users so they can view the Power BI reports.
  • Provide consultancy from a member of the Schools' Applications Team.

What is excluded?

Amendments or new requests for assistance should be commissioned separately.

What does it cost?

Log-in to find out information on our pricing.

Additional information

Is there anything I need to have in place before I can use this service?

Yes, to utilise this service, the school will need to have SIMS operational on a SIMS server hosted within the school, a unique Microsoft 365 log-in with Multi-Factor Authentication installed, and if your school has taken devolved admin for your Microsoft 365 tenancy or support your own tenancy, a Microsoft 365 tenancy administrator will need to be available during the course of the setup consultancy. 

IMPORTANT NOTE: If your school has taken the Microsoft 365 Devolved Admin option, you will need to ensure staff requiring the use of the Power Bi reports have access to the Power BI Cloud Service. You will need to ensure Share to Web (within Power Bi) has been disabled in your tenancy.

How many consultancy hours are included in this service?

This consultancy is expected to take one hour. If additional hours are requested or required, extra hours will be charged at our standard Price Band B consultancy rates.