Reporting - The Learning progress report

*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***

The learning progress report provides detailed insights to answer everyday questions about both mandatory and optional learning activities. It also delivers a high-level summary of overall compliance for business reporting. From the summary metrics, you can apply specific filters to drill down into the details with just a few clicks, allowing you, for example, to:

• See how new starters are getting on with one-off and repeat learning
• Find your most/least popular optional Courses
• List the Users with outstanding Course assignments
• See the 'big picture' of training that must be repeated each month for the coming year

In this article we'll start by explaining the Summary compliance metrics then we'll cover:

• Typical use cases for this report
• Video tour of the report
• How to use filter and drill-through with the report
• Your FAQ's answered

Summary compliance metrics 

The key visuals on the summary page are the summary metrics for compliance from 3 perspectives – Course assignments, Courses, and people:

• Course assignments: The overall number of Course assignments, and the number of assignments that are complete/incomplete
• Courses: The overall number of Courses assigned to your people, and the number of Courses that have been completed by all Users assigned it
• People: The overall number of Users, and the number of Users that have completed all Courses assigned to them

View the FAQ Why does the compliance report have 3 headline metrics for compliance? for a detailed summary of the different perspectives.  

Typical use cases

The report is designed to get you quick answers to this kind of questions. Select the question for a summary of the steps:

The Health & Safety officer asks if Sales and Retail teams have completed ‘Manual handling’

Here's a summary of the steps to get your answer quickly:

1. Open the 'Course title' filter, and select the Manual handling Course
2. Open the 'Group' filter and select the Sales and Retail Groups
3. View the 'People' summary metric for your answer

View How do I find the mandatory Course completion rate for a Group of Users? for a detailed step-by-step, including options to dive deeper into the detail. 

Now you have the results, what next? 

• Save and share a report view
• Organise report views into groups
• Export a table visual straight to Excel

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

The L&D manager wants to know how new starters are getting on with onboarding training

Here's a (very!) brief summary of the steps to get your answer quickly:

1. Open the 'Days since user start date' filter, specify the required number of days

View How do I see learning progress for users that started in the last 90 days? for detailed steps to answer this query. We'll also explore further filtering options that may be useful, for example by filtering by a User field or Group membership.

Now you have the results, what's next? 

• Save and share a report view
• Organise report views into groups
• Export a table visual straight to Excel

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

The L&D team want to know how users are engaging with recently launched optional Courses

Here's a brief summary of the steps to get a summary of enrolments and completions with just a few clicks:

1. Switch the 'Course is mandatory? filter to show only optional learning
2. Open the 'Course title' filter, and select the optional Course(s)
3. View the 'Courses' summary metric for your answer

View Which optional Courses have had the most enrolments and completions? for detailed steps to answer this query. We'll also explore further options to drill right into the detail.

Now you have the results, what's next? 

• Save and share a report view
• Organise report views into groups
• Export a table visual straight to Excel

To print the screen straight to PDF, select CNTRL+P. Alternatively, use a snipping tool to grab a specific area. 

Video tour of the learning progress report

Get a guided tour of the Learning progress report from the team that built it: 

How to use filter and drill-through with the report

There are two key techniques to get from the summary to the detail. 

Apply filters at 3 levels

As with all fixed reports, the Learning Progress report has a selection of filters to help you find the detail you're looking for. There are 3 places where filters can be applied: to all pages, to this page, and to a specific visual. 

Watch the video below to see the filters configured for this report:

Drill-through to Course, lesson, or person-level detail

Data drill-through takes you from summary-level information, right through to the granular detail you need. Watch the below video to see examples with the Learning Progress report:

Your FAQ's answered

Follow the links for detailed step-by-step's to answer key questions about learning activity. In each case, we'll share options to dive further into the details and get exactly the information you need:

• Why does the Learning progress report have 3 headline metrics for compliance?
• How do I find the mandatory Course completion rate for a Group of Users?
• How many mandatory Courses need just a few User completions for 100% compliance?
• Which optional Courses have had the most enrolments and completions?
• Overall, how many mandatory Course assignments are due to expire next month?
• How do I see learning progress for Users that started in the last 90 days?
• How do I see the number of mandatory assignments for a Course, and who is not compliant?
• How do I show mandatory and/or optional Courses in the Learning progress report?
• How do I find out when a User completed a Course?
• How do I find out learning progress for a specific Lesson?
• How do I filter the Learning progress report to show completions between two dates?

How often does the reports database refresh?

• The report database refresh twice a day
• A time stamp showing the most recent database refresh is shown in every fixed report
• The 'database refresh' time stamp can also be added to a user-created report
• Each Dataset is refreshed individually, so the time stamp may differ between reports using different Datasets
• Where a fixed report and a user-created report are built using the same dataset, the time stamp will be the same

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.