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

*** Please note, this article refers to Reporting and Analytics with Power BI. 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. 

Discover more about the Fixed reports

Want to get the most out of Fixed Reports? Our step-by-step guides cover the top queries on compliance and Event management, helping you use Fixed Reports effectively while learning key techniques along the way.

Prefer a live session? Join us for Key Techniques for using the Fixed Reports, where Gary walks through real-world use cases and answers your questions. For self-paced learning, explore our Key techniques eLearning.

Need quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources. You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts. 

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