Arbor's BI Connector allows automatic syncing of Arbor data into BI tools via Snowflake, enabling customisation and visualisation of key performance metrics. It includes pre-loaded data, template dashboards, and requires experienced BI users for setup.
Our BI Connector automatically syncs your Arbor data into your BI tool of choice through our Snowflake data warehouse, 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 into your BI tool, which means no need for a manual export.
- Templates to get you started - Template dashboards giving you the key information you need to dig deeper into questions about your performance.
- More customisation - Bring your Arbor data to life with powerful visualisations, and pull in any other data you want to build the insights you need.
The Connector is designed for experienced BI users, so make sure you’re confident using your BI tool first.
Top Tip: You can add any feedback about this feature here: BI Connector Improvements
What data is included in the connector?
Take a look over on our Arbor HQ for further templates and tips shared by other users: Data and BI on Arbor HQ
This is no longer available to purchase and will be discontinued shortly.
If you are currently using this you will need to change the data source for your dashboards from POWER_BI_PRODUCTION to ARBOR_BI_CONNECTOR_PRODUCTION. Be sure to revise any measures and calculated columns in your reports to align with the new view and column names - you can use the table below to translate between the old and new datasets.
- Open the Power BI Transform Data page
- Go to the table you want to change.
- In the Navigation step (on the right), click the settings cog button.
- Change the table to the new one under ARBOR_BI_CONNECTOR_PRODUCTION
Translated View Names
Most views used the old field name of person_unique_id
The new field name used is either student_unique_id or staff_unique_id depending on the type of data.
You can see a full list of what data is available here: BI Connector Version 1 Datasets
This gives you a comprehensive collection of datasets to support analysis, metrics and includes some publicly available data such as IDACI all in one place so you can get started quickly.
You can see a full list of what data is available here: BI Connector Version 2 Datasets (for MATs and Schools) or BI Connector Version 2 Datasets (for LAs)
We also offer an out-of-the-box Power BI template for you to get started, this covers 5 key areas:
-
- Attendance
- Suspensions & Exclusions
- Assessment
- Pupil Context
- Staff Context
How to set up the Connector
Step 1 - Purchase the connector
- Schools - Both our old and new Connectors can be purchased as a standalone feature and aren't included by default in our packages.
- MATs - While our old Connector could be purchased as a standalone feature, the new connector is part of our Plus package. If you are currently using our old connector while not on the Plus package, we'll give you access to the new connector until your next renewal date.
- LAs - the BI Connector will be included as standard in your contract.
To discuss your upgrade options, get in contact at customersales@arbor-education.com
Step 2 - Set up the connector
Once you've purchased the feature and we've sent over your credentials via 1Password, which includes the server name and warehouse that you will need, you can then set up the connector.
Included below are instructions for the two most common BI tools used, Microsoft Power BI and Google Looker Studio. A similar process applies when setting up with other BI tools, such as Tableau.
Follow these steps to set up the BI Connector with Microsoft Power BI - you'll need the desktop version to be able to create and share reports.
- Click the Get Data button in the Microsoft Power BI taskbar
- Enter Snowflake into the search bar to find the correct connector and click to set up
- For Server enter the Snowflake account URL we have shared with you, for Warehouse enter POWER_BI_GENERAL
- Enter your Account and Password which we will have shared via a 1Password link
- In the navigator choose ARBOR_BI_CONNECTOR_PRODUCTION
- Select the appropriate Schema - either ARBOR_MIS_ENGLAND_ANALYSIS or ARBOR_MIS_ENGLAND_MODELLED
Follow these steps to set up the BI Connector with Google Looker Studio:
- Click the Add Data button in the Google Looker Studio Taskbar.
- Select Snowflake from Partner Connectors.
- Enter your Snowflake Account URL that was sent to you by us.
- Enter these details:
- Choose Role - add your username
- Choose Warehouse - POWER_BI_GENERAL
- Choose Database - ARBOR_BI_CONNECTOR_PRODUCTION
- Choose Schema - Either ARBOR_MIS_ENGLAND_ANALYSIS or ARBOR_MIS_ENGLAND_MODELLED
- Enter SQL Query - Select the data from the table you want to bring in.
Please note that there is a 1 million row limit when using the BI Connector with Google Looker Studio that cannot be exceeded.
Step 3 (optional) - Set up Attainment 8 and EBacc assessment analysis
Our Key Stage 4 summative assessment analysis 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).
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.
- If the assessment is not Progress 8, you'll need to use our marks migrator
- If the assessment has a bespoke grade set, you'll need to change this back to the default
You can see some example screenshots of how it will look below.
Step 4 (optional) - Arbor Templates
Please download the templates by clicking on this link. This file contains 5 dashboards to get you started in understanding how to use the BI Connector.
Help with the Connector
Here are some things to check when having issues with the connector:
- Different data items are synced on difference schedules. You can set your own refresh schedule within your BI tool.
- If you have connection issues (such as an 'Unable to connect' error in Power BI), contact your IT manager to request that they update your firewall to allow to access your Snowflake URL.
- Check whether you have enough memory on your computer to use your BI tool (suggested 16 GB of RAM) - you can check the amount of memory free in your hard drive for an indication.
How to get support
If you have any issues with the Arbor side of the Connector (e.g. not all your Arbor data is synced), please contact the Arbor Support Team with reference 1029 if supported by Arbor, or your Support Partner if not supported by Arbor.
You can also post in the Arbor HQ for support from other Schools and MATs using the BI Connector: Data and BI on Arbor HQ
If you have any queries about how your BI tool works, please contact them. For example, the Microsoft Power BI Community.
Comments
Article is closed for comments.