This article provides a comprehensive list of datasets available in Version 2 of the BI Connector, including details on specific views like Detentions, Academic Calendar Dates, and Assessment Completion. It also outlines the refresh schedule for these datasets and highlights the increased refresh rate during exam results days. Users can suggest new datasets and access an Entity Relationship Diagram for better understanding.
Below you'll find a list of all the available datasets for Version 2 of our connector, which is sometimes referred to as a Data Dictionary.
A full explanation of how to purchase and install the connector is available here: Arbor’s BI Connector
Want to suggest new datasets we may add in future? Add your feedback here: BI Connector Datasets and Improvements
BI Connector Data Sets
These datasets can be found under the ARBOR_BI_CONNECTOR_PRODUCTION database
- For English Schools or MATs these datasets are in the ARBOR_MIS_ENGLAND_MODELLED or ARBOR_MIS_ENGLAND_ANALYSIS schemas.
- Refer to the English Data Catalogue for further details
- For Welsh Schools these datasets are in the ARBOR_MIS_WALES_MODELLED or ARBOR_MIS_WALES_ANALYSIS schemas.
- Refer to the Welsh Data Catalogue for further details
National datasets can be found in ARBOR_DATA_CONNECTOR_PRODUCTION.NATIONAL, the National tab in the relevant catalogue gives details of what's available.
Entity Relationship Diagram
We publish Entity Relationship Diagrams (ERD) illustrating how our datasets are connected together, these are slightly different depending on the country:
English BI Connector ERD - MIS Data (Version 3.1)
Welsh BI Connector ERD - MIS Data (Version 1.2)
Column-Level Data
For the full detailed list of data fields available, click on the relevant link below:
Arbor BI Connector Data Catalogue (England)
Arbor BI Connector Data Catalogue (Wales)
Refresh Schedule
The refresh frequency depends on the dataset. Please see the Data Catalogue for a full list of the views and their update schedules. Each dataset is set on a schedule according to the amount of feed-in data and complexity of logic. The options are:
| Frequency | Description |
| Fastest | Updates every 15 mins |
| Hourly | Updates at 5am and every hours 8-6 on weekdays |
| Slowest | Updates at 5am, 11am, 1pm |
Results Days
KS2 Sats - Release date 8th July - results will refresh every hour from 7am
On 13th, 14th, 20th and 21st August 2025 we will increase the refresh rate for the following BI Connector Datasets. This is to help schools and trusts rapidly analyse their exam results.
From 6am to 10pm we will refresh these datasets every half hour. We cannot give precise times of when data updates run due to complexities in the workflow from external software providers.
| Schema | Dataset |
| ARBOR_MIS_ENGLAND_MODELLED | STANDARDISED_ASSESSMENT_MARKS |
| ARBOR_MIS_ENGLAND_MODELLED |
SUMMATIVE_ASSESSMENT_MARKS EXAM_RESULTS |
| ARBOR_MIS_ENGLAND_ANALYSIS |
EXAM_RESULTS_HYDRATED EXAM_RESULTS_KS4_SCHOOL_HEADLINE EXAM_RESULTS_KS4_STUDENT_SUMMARY |
Please note that exam results come into the BI Connector as soon they are in the MIS and before the embargo period. Therefore please consider this when analysing exam results during the embargo period.
Notes on specific views
- Detentions - This view contains a row for each student who attends a detention. Therefore detention sessions will not appear unless a student attends that detention session.
- Academic Calendar Dates - Dates range from 1990-2029
- Internal Exclusions - This includes attendance.
- Intervention Staff Costs - Only schools who use this will have this data.
- Assessment Completion - Assessment Completion allows staff to view the completion rate (students with a mark or non submission reason are counted as complete) of an assessment by the group an assessment is assigned to, which includes courses, registration forms, year groups, academic years, teaching groups and custom groups. Only students enrolled in the group on the last day of the period are included.
- Custom Groups - Please note that there are student, staff and guardian custom groups.
- EXAM_RESULTS_HYDRATED - Please see our dedicated guide for further information on this view: EXAM_RESULTS_HYDRATED in the BI Connector
Comments
Article is closed for comments.