Aptem OData Power BI Dashboards

Using custom withdrawal reason fields in Aptem to give you more information than the standard ILR codes, you can identify areas for improvement which can have a direct impact on your Quality Achievement Rate (QAR).

Saving several metrics of engagement and participation in one place, you can identify learners who are at risk of not completing their apprenticeship early. This allows you to put timely interventions in place.

Being able to see how many learners you have at the onboarding stage on each programme and also projected end dates, allows you to plan your tutors' caseloads.

A detailed summary of all learners showing that they are logging into Aptem, submitting work, recording off-the-job hours and completing components can be used to show learner progress in one place. This can be filtered by employer so you can easily send them regular updates in a standardised format.

Using a proactive approach to manage reviews where next review dates are calculated, ensures you remain compliant with funding rules.

Monitoring your tutors' caseloads based on quality and compliance metrics that calculate risk using several performance measures, highlights best practice and identifies risk areas.

Understanding why learners have taken a BIL can highlight potential areas of concern. Having their return to learning date in Aptem BIL trackers or custom fields, means this process can be easily managed using the dashboards. 

The standard operational and strategic dashboards can be customised and further enhanced to show more live data. We work with you to create dashboards that track metrics over time, allowing you to demonstrate the positive impact of your improvement plans to governors and external regulatory bodies.

There is so much that can be created using Aptem OData and we are keen to support providers in developing their reporting capabilities. Some of the dashboards we have created to date include:

These dashboards allow leaders to monitor average marking days by case owner, the volume of components overdue, and the volume of components completed late. Tutors can easily see who has not submitted work against a component within a cohort. Learners can then be emailed directly from Power BI, or mail merges can be created for bulk emails.

These dashboards enable leaders to monitor the duration of each stage of their bespoke onboarding process, including skills radars and compliance checks, highlighting areas for improvement in processes and controls. Administrative staff can manage where a learner is in the onboarding process, ensuring appropriate actions are taken to keep the learner engaged with enrolment.

These dashboards enable finance departments to download all ILR apprenticeship financial records into a single table, which can be easily filtered to identify new learners subject to co-investment or those with a change in employer. This allows for quick invoice generation, thereby improving cash flow.

If a process is taking a long time or you need better insights about your provision from Aptem, get in touch!