What is a "Power BI" dashboard?
Microsoft Power BI is a suite of business intelligence (BI), reporting and data visualisation products. Power BI lets data from multiple sources be combined, analysed in real time and presented visually.
MWS Technology have used Power BI to develop a suite of custom-built dashboards that give you quick access to the data your business needs across a range of key areas. The dashboards are fully embedded in Aptem, so you don't need any specialist knowledge or software to use them.
Who has the Ofsted/Quality dashboard been designed for?
The Ofsted/Quality dashboard is designed for anyone in the business who may be involved in preparing for an Ofsted visit or working with quality data, and who has been given access. Typically, this includes, but isn't limited to:
- Operations Director/Manager
- Ofsted/Quality Administrators
What information does the Ofsted/Quality dashboard contain?
The Ofsted/Quality dashboard provides Ofsted and quality information based on the data held in your Aptem platform. It shows DfE and funding-related Ofsted and quality data in these sections:
- Menu (including previous report information)
- Ofsted Headline
- Delivery
- Employment
- Contract
- Performance
- QAR (for details and caveats, see QAR and Accountability calculations in Aptem)
- Accountability
For the calculations used in the Quality dashboard, see Quality dashboard calculations.
New: Delivery Summaries (dynamic grouping)
The Quality dashboard includes a Delivery Summaries page, which gives you a flexible way to analyse delivery data using dynamic grouping.
Admins can group data by Qualification (the default), Age Range, Disability, Ethnicity and Gender. You can select several group levels, and the order you select them in sets how the data is grouped.
Data updates straight away when you change the grouping, without refreshing the page, and learners are only counted once in KPIs and summary measures.
Where is the data taken from?
The data in the Ofsted/Quality dashboard comes directly from the databases behind Aptem. Everything you enter into Aptem is stored securely in these databases and used to power the dashboards, so the dashboard shows up-to-date information when it's loaded or refreshed. You can refresh it once an hour at most.
The key data and filters used on each page (tab) of the Quality dashboard are described in the sections below. Each page has data assumptions, hard-coded filters and user-definable filters, explained where possible.
For reference:
- Data assumptions: assumptions made about the data that decide whether it's included in or excluded from the dashboard.
- Hard-coded filters: filters built into the dashboards that users can't edit or change.
- User-definable filters: page-level filters you can adjust to further shape the data.
- Some fields use external data provided by the DfE and Ofsted. Where this hasn't been published, for example inspection visits between publication dates or not yet carried out, some fields may be blank.
Notes
- If no group filter is applied to the data table, learners appear for each group they're in. All measures count each learner only once.
- Dynamic grouping is supported on the Delivery Summaries page. Learners in more than one group structure may appear in more than one grouping, but all KPIs and summary measures count each learner only once.
Individual tab details
- Tab: Menu
- Tab: Ofsted Headline
- Tab: Delivery
- Tab: Delivery Summaries
- Tab: Delivery Table
- Tab: Delivery Table (Ethnicity)
- Tab: Delivery by Qualification
- Tab: Learner Data
- Tab: ILR Destination Data
- Tab: Employment
- Tab: Contract
- Tab: Performance
- Tab: QAR Headline
- Tab: QAR Gender and Disability
- Tab: QAR Age and Ethnicity
- Tab: QAR Functional Skills
- Tab: Accountability
Tab: Menu
Visuals included
Current Ofsted data, including these fields:
- Overall Ofsted rating
- Is safeguarding effective?
- Type of provider
- Ofsted region
- Last report published
- Link to current Ofsted report (external)
- Inspection criteria and associated ratings
- UKPRN
- UPIN
- URN
Data assumptions
- A currently published Ofsted report is needed to fill in this information.
Hard-coded filters
User-definable filters
- UKPRN (single select)
When Ofsted report details update
Ofsted report details, including the overall Ofsted rating, aren't updated as soon as a report is published:
- Aptem checks for newly published Ofsted reports around the 11th of each month. The exact day can vary with the day of the week.
- The Menu page is then updated, usually 7 to 10 days after the new file is received.
For example, if your Ofsted report was published in June, expect the dashboard to update before the end of July. Updates are based on the date the report is published, not the date of the visit.
Tab: Ofsted Headline
Visuals included
- Gender split
- Ethnicity split
- Learner demographic
- Age range split
- Average age headline figure
- Number of learners headline figure
Data assumptions
- None
Hard-coded filters
User-definable filters
- Subscription status
- Age range
- Groups: this filter and the visualisations only contain the groups and learners you have access to. You see learners in every structure you belong to and have access to, so learners can appear more than once in the detail tables. KPIs and counts still count each learner only once.
- UKPRN
- Aim start year
- Category
- ILR status (current episode)
- Aptem programme type
- In current year
Tab: Delivery
Visuals included
- Learners enrolled per programme delivered
- Learners by programme type
- English IA and Maths IA levels
- Delivery demographic
- Average length of programme headline figure
- Number of traineeship learners headline figure
- Number on community learning programmes headline figure
Data assumptions
- None
Hard-coded filters
User-definable filters
- Subscription status
- Age range
- Groups: this filter and the visualisations only contain the groups and learners you have access to. You see learners in every structure you belong to and have access to, so learners can appear more than once in the detail tables. KPIs and counts still count each learner only once.
- UKPRN
- Learner type
- Learner funding status
- Learner in current year
Tab: Delivery Summaries
This tab lets admins group delivery data dynamically using a Group filter. Grouping can be applied across Qualification, Age Range, Disability, Ethnicity and Gender. You can select several group levels, and the order sets the grouping hierarchy.
Changing the grouping updates the table straight away, without a page refresh, and KPI calculations stay consistent.
Tab: Delivery Table
Important: in a future release, this page will be removed and replaced by the Delivery Summaries page, which does the same job with more grouping options. We recommend you start using Delivery Summaries now.
Visuals included
- Gender
- Age range
- Health or LLD problems
Data assumptions
- None
Hard-coded filters
User-definable filters
- Subscription status
- Learner type
- Learner funding status
- Learner in current year
- Groups: this filter and the visualisations only contain the groups and learners you have access to. You see learners in every structure you belong to and have access to, so learners can appear more than once in the detail tables. KPIs and counts still count each learner only once.
- Onboarding status
- Programme type
- Programme start year
- Programme planned end year
- Actual end year
- UKPRN
Tab: Delivery Table (Ethnicity)
Important: in a future release, this page will be removed and replaced by the Delivery Summaries page, which does the same job with more grouping options. We recommend you start using Delivery Summaries now.
User-definable filters
- UKPRN
- Programme start year
- Programme type
- Subscription status
- Learner type
- Learner funding status
- Onboarding status
- Programme planned end year
- Actual end year
- Groups: this filter and the visualisations only contain the groups and learners you have access to. You see learners in every structure you belong to and have access to, so learners can appear more than once in the detail tables. KPIs and counts still count each learner only once.
- Learner in current year
Tab: Delivery by Qualification
Important: in a future release, this page will be removed and replaced by the Delivery Summaries page, which does the same job with more grouping options. We recommend you start using Delivery Summaries now.
For using this tab to report achievement and retention, see Report on achievement rates, achievement grades and retention rates.
User-definable filters
- UKPRN
- Current year
- Qualification/Std/Fwork
- Subscription status
- Programme start year
- Programme planned end year
- Actual end year
- Onboarding status
- Programme type
- Learning status
- ILR status (current episode)
Tab: Learner Data
This tab has no hard-coded year filter, so it shows all ILR aims for hybrid end years from 2018/19 onwards. Use it to check learners whose records you can't see on the QAR tabs.
User-definable filters
- UKPRN
- Subscription status
- Learner type
- Learner funding status
- ILR status
- Start year
- Planned end year
- Hybrid end year
- Actual end year
- Groups: this filter and the visualisations only contain the groups and learners you have access to. You see learners in every structure you belong to and have access to, so learners can appear more than once in the detail tables. KPIs and counts still count each learner only once.
- Current year
Tab: ILR Destination Data
User-definable filters
- UKPRN
- Subscription status
- Hybrid year end
- Programme
- Start date
- Outcome type
- Category
Tab: Employment
Visuals included
- Levy vs non-levy paying employers
- Employer locations (map)
- Count of employers by sector type
- Number of employers headline figure
- Average number of employers per employee headline figure
Data assumptions
- None
Hard-coded filters
User-definable filters
- Approx. number of employees
- Filter by learners
- Sector type
Tab: Contract
Visuals included
- Funding values, consisting of:
- Funding line
- Value type
- Value
- Number of distinct funding lines headline figure
- Contract value headline figure
Data assumptions
- DfE published funding data available to reference.
Hard-coded filters
User-definable filters
- Value type
- Funding line
- UKPRN
- Year
Tab: Performance
Visuals included
- Performance (achievement rate) values for the named provider, consisting of:
- Age band
- Apprenticeship level
- Apprenticeship type
- Framework/standard
- Framework code
- Overall achievement rate %
- Overall cohort
Data assumptions
- DfE published achievement data available to reference.
Hard-coded filters
User-definable filters
- Age
- Apprenticeship level
- Apprenticeship type
- Framework / standard
- Hybrid end year
- UKPRN
Tab: QAR Headline
This tab calculates the overall achievement, retention and pass rates for apprenticeships, based on your ILR data in Aptem, for the current year (minimum, expected and maximum indicative values) and the previous two hybrid year ends. You can filter the measures by apprenticeship main aim, gender, age and ethnicity, and export the underlying data for review.
Which aims are included
QAR calculations only include aims where the ILR episode is Signed, QA Verified or Completed. Aims excluded from the batch are ignored.
QAR calculations are also based on planned end dates within the funding year, so an export from this tab doesn't include every learner, for example only a few records for a hybrid year. To see all ILR aims, use the Learner Data tab, which has no year filter. It's useful for checking any differences you see in the QAR summary table and confirming learners' hybrid end years. To export the data, see Report raw data for QAR headlines.
Visuals included
- Summary table, consisting of:
- Counts of learners, completed and achieved used in calculations
- Achievement, retention and pass rates
- Chart of QAR by hybrid year end
- Chart of retention rates by hybrid year end
- Chart of pass rates by hybrid year end
- Learner Aims table header, to enable export of selected data
User-definable filters
- Gender
- Ethnicity
- Subscription status
- UKPRN
- Category
- Age at aim start
- Standard/Framework
- Learning status (only affects the Learner Aims table)
- Hybrid end year (only affects the Learner Aims table)
Tab: QAR Gender and Disability
This tab calculates the overall achievement, retention and pass rates for apprenticeships, split by gender, age or disability group, for the current year (minimum, expected and maximum indicative values) and the previous two hybrid year ends. You can filter the measures by apprenticeship main aim and hybrid year end, and export the underlying data for review.
Visuals included
- Overall totals table, consisting of:
- Counts of learners, completed and achieved used in calculations
- Achievement, retention and pass rates
- Gender table, consisting of:
- Counts of learners, completed and achieved used in calculations per subgroup
- Achievement, retention and pass rates per subgroup
- Age table, consisting of:
- Counts of learners, completed and achieved used in calculations per subgroup
- Achievement, retention and pass rates per subgroup
- Disability table, consisting of:
- Counts of learners, completed and achieved used in calculations per subgroup
- Achievement, retention and pass rates per subgroup
- Learner Aims table header, to enable export of selected data
User-definable filters
- Hybrid end year
- Subscription status
- UKPRN
- Category
- Gender
- Disability
- Age at aim start
- Standard/Framework
Tab: QAR Age and Ethnicity
This tab calculates the overall achievement, retention and pass rates for apprenticeships, split by ethnic background, for the current year (minimum, expected and maximum indicative values) and the previous two hybrid year ends. You can filter the measures by apprenticeship main aim and hybrid year end, and export the underlying data for review.
Visuals included
- Overall totals table, consisting of:
- Counts of learners, completed and achieved used in calculations
- Achievement, retention and pass rates
- Ethnicity table, consisting of:
- Counts of learners, completed and achieved used in calculations per subgroup
- Achievement, retention and pass rates per subgroup
- Learner Aims table header, to enable export of selected data
User-definable filters
- Hybrid end year
- Subscription status
- UKPRN
- Category
- Gender
- Ethnicity
- Age at aim start
- Standard/Framework
Tab: QAR Functional Skills
This tab calculates the overall achievement, retention and pass rates for Functional Skills aims taken as part of an apprenticeship, based on your ILR data in Aptem, for the current year (minimum, expected and maximum indicative values) and the previous two hybrid year ends. You can filter the measures by apprenticeship main aim, gender, age and ethnicity, and export the underlying data for review.
Visuals included
- Summary table, consisting of:
- Counts of learners, completed and achieved used in calculations
- Achievement, retention and pass rates
- Chart of QAR by hybrid year end
- Chart of retention rates by hybrid year end
- Chart of pass rates by hybrid year end
- Learner Aims table header, to enable export of selected data
User-definable filters
- Gender
- Subscription status
- UKPRN
- Category
- Age at aim start
- FS type / level
- Ethnicity
- Standard / Framework
- Hybrid end year
Tab: Accountability
This tab shows measures from the Apprenticeship Provider Accountability Framework, based on your ILR data in Aptem, for the current year. You can filter the measures by apprenticeship main aim, gender, age and ethnicity, and export the underlying data for review.
Visuals included
- Summary table, showing for each apprenticeship main aim:
- Counts of learners, withdrawals, learners past end date and learners on a break used in calculations
- Withdrawal rate
- Past end date rates (180-364 days and 365+ days)
- BIL rates (180-364 days and 365+ days)
- Learners without EPA Org ID
- KPI cards for overall counts of learners, withdrawals, learners past end date and learners on a break used in calculations
- KPI cards for these measures:
- Withdrawal rate
- Past end date rates (180-364 days and 365+ days)
- BIL rates (180-364 days and 365+ days)
User-definable filters
- Gender
- Subscription status
- UKPRN
- Year (single select)
- Age at aim start
- Ethnicity
- Qualification/Standard/Framework
Power BI reports in Aptem Console
Admins with the Power BI Quality Report role can view the Ofsted/Quality Power BI report in Aptem Console. Once the role is assigned, it takes some time before the reports show.
To view Power BI reports in Aptem Console, select Power BI Reports in the left menu.
On the Reports screen, you can view the Quality report. If you have access to more than one report, use the navigation menu at the top to move between them.
You can view the information on each report's tabs.
Refreshing the Power BI report
Power BI reports don't refresh automatically. To see the latest information, select Refresh. The report takes a couple of minutes to refresh.
You can't refresh a report within an hour of the last refresh. The time of the last update, and the next time you can refresh, are shown.