5 easy steps to build a BI dashboard with your Arbor data

Andrew Mackereth - 30 June, 2020

Category : Blog

5 easy steps to build a BI dashboard with your Arbor data

As you begin strategic planning for Autumn Term, you may want to dig into your data from the last three years in order to shape your new improvement plan. Arbor’s out-of-the-box dashboards make this easy, helping you quickly access meaningful data so you can make the best decisions. You can drill down into key attendance,

As you begin strategic planning for Autumn Term, you may want to dig into your data from the last three years in order to shape your new improvement plan. Arbor’s out-of-the-box dashboards make this easy, helping you quickly access meaningful data so you can make the best decisions. You can drill down into key attendance, behaviour and attainment metrics and easily spot useful patterns, all without the need for any special training (and no need for a complex setup process!). 

We’ve been working with schools and MATs recently who want to customise how they analyse and visualise their data even further using BI (Business Intelligence) tools, such as Microsoft Power BI, Google Data Studio or Excel. We make it easy to export your Arbor data securely into BI tools if you want to, so you can dig even deeper into your student measures. 

Using BI tools are great for:

  • Driving strategic planning by bringing data from your MIS, HR, and finance systems all into one dashboard
  • Exploring contextual factors affecting your performance by bringing in other national and regional data sets, such as GIAS (Get Information about Schools), IMD (Index of Multiple Deprivation) or crime statistics
  • Visualising your data in new ways – choose from lots of different chart and graph options

 

How to create a custom BI dashboard – an example 

So what does using BI look like in practice as a MAT? Andrew Mackereth, Arbor Senior Partnership Manager, caught up with Empower Trust in Shropshire about how they created a custom dashboard in Google Sheets using their Arbor data. Find out why they wanted to create it and how they built it in five easy steps below.

Google Sheets screenshot 2

 

3 things they wanted to achieve

 

1. Share information with the Board

As the Board of Trustees is accountable for the performance of the Multi-Academy Trust and its Academies, a key issue for Ian Nurser, Empower’s CEO, was to provide them with a breadth of accurate, timely information across a range of key performance indicators (KPIs). This would allow the Board to understand the trust’s strengths and development issues, assess progress and review future risks and priorities.

Pulling everything into a single live dashboard would give the Board a single source of truth. At each meeting, the data would automatically refresh, updating the current picture, or monthly/termly trends at the same time. 

 

2. Make sure everyone has the same information

It was important to Empower that the CEO, the Trust School Improvement Officers and local governing bodies (LGBs) had access to the same Academy-level information to allow them to question, support and appropriately challenge Academy leaders to build on their strengths and continually improve. 

 

3. Bring together a range of live data sources

Empower wanted to bring together real-time information across a broad range of KPIs including attainment and progress for all year groups, pupil attendance, exclusions, SEND, safeguarding and staff absence (as an indicator of staff wellbeing). Using Google Sheets would enable the reports to automatically update as each Academy entered data. 

As well as providing real-time information, they wanted to increase efficiency and save leadership time by compiling the content for their termly CEO and Headteacher reports to Trustees and LGBs automatically. They also wanted this information to be available to other groups of Trust and Academy staff such as SENCos and EWOs, so they could better monitor SEND, attendance, staff wellbeing, etc.

 

How they built their custom dashboard

Empower took the following steps to plan and build their Google Sheets dashboard:

1. Agree the data they want it to show
2. Find the sources of the data
3. Plan the structure of the dashboard
4. Export the data they want from Arbor
5. The dashboard is ready and will refresh automatically!

The main process involved in creating a dashboard in Google Sheets is exporting data sets from Arbor using “Live Feeds”. Empower pulled the majority of their data from the data tables in Arbor and the other information (such as the number of days of absence caused by holiday) using Arbor’s unique Custom Report Writer. 

For each data set (table) they wanted to export from Arbor, they created a “Live Feed” for it, then inserted it into their custom dashboard using the Google Sheets add-on. Then they selected the graph type they wanted to use to illustrate the data (like the bar chart below). 

Google Sheets screenshot 1

 

Ensuring the data is secure

It’s important to be confident that your data is safe when you export it out of your MIS. That’s why in Arbor you can add authentication to your “Live Feeds”. This means that anyone accessing your new custom dashboard (whichever BI tool you create it in) must enter a password. You can also track when each Feed was last accessed. Read more about how Arbor keeps your data secure here.

Google Sheets Google Sheets screenshot 3screenshot 3

 

To find out more about how to explore BI tools with your Arbor data, join our free webinar next Tuesday (7th July) at 11am. In this 45-minute session, we’ll show you how to get the most insight from your school data, both within Arbor MIS and using Power BI. Former Middle Leader at a secondary school and now Arbor’s Lead Product Manager Stephen Higgins will be joined by two data experts – Ed Cadwallader, School Improvement Consultant, and Mark Hodges, Education Systems Manager at Cantium Business Solutions.

  • Part 1: Data analysis in Arbor MIS with Stephen Higgins
  • Part 2: Creating a MAT dashboard in Power BI with Ed Cadwallader
  • Part 3: Supporting schools and MATs with Power BI with Mark Hodges

There’ll be plenty of time for questions of our three panellists.

 Click here to sign up for your free place – hope to see you there!

Leave a Reply