Reporting - How do I see which optional Courses have had the most enrolments and completions?

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

In this article, we'll show how to find out which optional Courses have had the most enrolments and completions.*

We'll also:

• Show how to drill-through and see which Users have completed a Course
• Highlight additional filters for this scenario
• Signpost options to export, save, and share results

To answer this question, we'll use the Learning progress report. Note that by default, the Learning Progress report is pre-set to include mandatory Course assignments only. 

*A User is enrolled on a Course when it appears in either 'Courses I've done', or 'Courses I've chosen to do'

See which optional Courses have had the most enrolments and completions

1. Open the Learning progress report
2. Select the Course is mandatory? filter:
3. De-select Yes
4. Select No:
   If you'd like to choose a specific selection of optional Courses, continue to step 5. To include all optional Courses, skip to step 7
5. Select the Course title filter
6. Select the Course(s) of interest to you. Use the search if required:
7. In the Courses summary panel, select View:

The resulting table lists all selected Courses, with a number/percent overview of the number of assignments and completions for each. Select any column to change the sort order. For example, select #user assignments to order the list by most/least assignments:

Drill through and see which Users have completed a Course

Hover over a row (or right-click) to see a drill through option. for the above data table, this can be used to see person-level information for a specific Course:

Additional filters for this scenario

There are two further filters applied by default to the Learning Progress report that you may choose to change; 'User is enabled' and 'Course is currently enrolled'. Both are set to 'Yes' by default:

User is enabled

De-select 'Yes' (or select 'No' in addition to 'Yes') and the report will include any Users who have left the organisation. They may have left, but their training activity can still be reported. 

Course is currently enrolled

A User can remove an optional Course from 'Courses I've chosen to do' by selecting 'Remove Course'.

De-select 'Yes' (or select 'No' in addition to 'Yes') and 'removed' Courses will be included in this report. By This may give a better picture of how your people have engaged with the optional content. 

Export, save, and share the results

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. 

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.