Aptem's Power BI reporting Dashboards are built to provide valuable insights and analytics into apprenticeship data. Its real-time, dynamic data allows users to drill down on key apprenticeship reporting data, build custom reports, filter and export data, view analytics reports and more.

In the video recording below, our Head of Data Analytics, Mark Abrahams, walks through three out of Aptem's four standard Power BI reporting Dashboards: Funding, Compliance and Quality Dashboards. The Caseload Dashboard was covered during the live webinar.

You can also access the pdf version of the PowerPoint presentation used during the webinar here. These slides overview each of the four Power BI reporting dashboards.

Q and A transcript

The following is a transcript of the questions asked during the webinar, along with the expert's answers. For any further information, do contact your IC or support.

Are Caseload, Compliance, Funding and Quality the 4 main reports that should be available to all Admins?             

Ideally reports should be available to admins depending on the data that they need to access, e.g.: Funding includes Learner Funding Data - a table of all ILR Aims. Compliance - lists all compliance etc. documents.

Can you include Archived users?

Archived users can be included using the relevant subscription status filter. Our demo account did not contain any archived learners.

How do we get access to these reports? We only see Funding.    

In Aptem Classic you will need to edit the roles for each administrator. View the administrator profile and click on "edit admin details". In roles section, select the relevant Power BI roles. See List of Administrator Roles.

Our latest Ofsted grading is incorrect, but the data was refreshed today. When will this be updated on the Quality dashboard?       

The gradings are not directly synchronised to the Ofsted website. We need to periodically update the inspection data in the reference data that sits behind the report. We will refresh the inspection data.

How can we see who has signed the signed completed reviews?

For searching purposes this can accessed via the "Review Signatures" tile in Classic. This functionality is expected to be available in console in the next 2 months.

Are you thinking about doing compliance reports for reviews? At the moment I can see a review planned start date and if it's been started for all our applicants / apprentices at both onboarding and delivery level. Currently I have to keep an excel to keep track.         

Thank you for the suggestion - we will explore this.

With the subscription status, does black or grey indicate what is filtered in or out?             

It indicates what is included - like a checkbox being selected.

What does learner with no ILR aim mean?            

A learner with an Aptem subscription, who does not have any associated ILR aims (i.e., no ILR).

Would these be in an onboarding programme?  

Yes, they could be in onboarding.

ESFA have recently introduced an accountability framework for apprenticeships. Is there any intention to develop a Power BI report that would provide a live report on the KPIs set by ESFA for providers to use in managing their provision? Could this be taken as a development request if not?

This is something we are currently working on.

PDF version of the slides

A pdf version of the slides used in the webinar is attached for your reference.