Arbor’s Microsoft Power BI Connector

Our Microsoft Power BI Connector automatically syncs your Arbor data into Power BI, so you can customise and visualise it however you need to. Please note, our Connector comes with a fair use policy.

  • Ready to go - Your key Arbor data is pre-loaded in Microsoft Power BI, which means no need for a manual export.
  • Templates to get you started - We’ve created five template dashboards giving you the key information you need to dig deeper into questions about your performance, from attendance to assessment to behaviour.
  • More customisation - Bring your Arbor data to life with powerful visualisations in Microsoft Power BI, and pull in any other data you want to build the insights you need.

We will be continuously building on this feature to enable you to export more data in the future.

What templates are available?

We’ve created a template that gives you 5 ready-made dashboards:

  • School/trust dashboard built with an overview of your Key Performance Indicators (KPIs)
  • Attendance
  • Assessment
  • Behaviour
  • Demographics
What data is available?

Data synced from Arbor to Power BI:

  • Student data
  • Student demographic data
  • Attendance statutory roll call marks
  • Behaviour incidents
  • Exclusions
  • Summative assessment raw grades, targets and baselines
  • Exam results
  • KS4 Exam analysis
  • Attainment 8 and EBacc assessment analysis
  • Standardised DfE assessments - including DfE assessments, Hodder and Granada Learning (UL schools only)
  • Staff data

Coming soon:

  • Staff data:
      • Personal data
      • Contract information
      • Absences
  • National Ofsted data sets
 

 

Before setting up the Connector

Our Connector can be purchased as a standalone feature and isn't included by default in our packages. To discuss your upgrade options, get in contact at accountmanagers@arbor-education.com

The Connector is designed for experienced Power BI users, so make sure you’re confident using the platform first. There’s some useful information on the Power BI website.

We first need to assess the quality of your Arbor data before we input it into Power BI. Our Product Team will arrange this before you purchase the Connector, and we’ll let you know if you need to take any action to sort your data. 

Support with the Connector:

  • If you have any issues with the Arbor side of the Connector (e.g. not all your Arbor data is synced) get in touch with our Support Team.
  • If you have any queries about how Microsoft Power BI works, please contact the Microsoft Power BI Community.

Please allow a maximum of four weeks to set up your Connector.

 

How to set up the Connector

Once you've purchased the feature and we've sent over your credentials (including server name and warehouse) via email and the templates, watch the video below to see how to set up the connector.

Setting up Arbor's Power BI Data Connector

The video above shows how to add in your credentials and connect your data to Microsoft Power BI.

 

Attainment 8 and EBacc assessment analysis

Our Key Stage 4 summative assessment analysis available through our PowerBI data sets takes the hard part out of analysing your data. It includes the data drop by data drop calculation Attainment 8 and EBacc scores, and 'eligibility' flags (whether the student’s spread of assessments makes them eligible for EBacc).

How to set up your assessment analysis

To be able to use assessment in your analysis, make sure the assessments have been set up using Arbor's out-of-the-box Progress 8 assessments, with one of the out-of-the-box grade sets. Other assessments set up or set up with custom grade sets cannot be used. If you modify the out-of-the-box grade sets, your results may be skewed. You can see how to set up assessments here: Setting up and analysing Progress 8 Assessments

Check you've set these up correctly by going to Students > Assessments > Annual Policy > Manage Assessments. You can see whether it's a Progress 8 assessment here, and click on it for more information.

Screenshot_2022-01-17_at_10.08.03.png

 

You can see some example screenshots of how it will look below.

Screenshot_2022-01-14_at_13.54.49.png

Screenshot_2022-01-14_at_13.59.57.png  

 
Was this article helpful?
1 out of 2 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.