Reporting - How do I find how many mandatory courses need a few more user completions for 100% compliance?

*** 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 see which Courses need just a few Users to achieve 100% compliance. Then, we'll drill into the detail to:

• List the Users for each incomplete Course
• Signpost options to export, save, and share results

Note that the same steps might be followed to identify which Courses need the most users to complete for 100% compliance.

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. View this article to see how to switch to view optional assignments.

See which Courses need just a small number of Users for full completion

1. Open the Learning progress report
2. The 'Courses' summary metric will show, at a glance, the number of Courses that are fully complete, and not fully complete. In the below example, 18 Courses are not fully complete. Select View to drill into the detail: 
3. Select the column '#non-complete assignments' to sort the table by values in this column. Results will be listed with the largest number of non-complete assignments
4. Select the column '#non-complete assignments' again, to re-sort by Courses with the lowest number of non-complete assignments. In this example, the Course 'Living our company values' needs just one User to complete the Course to take it to 100% compliance:

List the Users for each incomplete Course

1. Follow the steps above to see which Courses need just a small number of Users for full completion
2. Hover over, or right-click a row
3. Select Drill-through
4. Select See Person-level information for this Course:
5. All Users enrolled on the Course will be listed. Select the column 'Course compliance status' to sort the table by values in this column (Select again to reverse the sort order if preferred). For this example, we can see the one person who is not compliant for this Course is Heather Wilson:

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.