Reporting - The Lesson history Dataset

*** Please note, this article refers to Reporting and Analytics with Power BI. View the FAQ for more details. ***

In this article, we'll explain the main uses of the Lesson History dataset.

The Lesson history dataset is designed to help you look back at the history of each User interaction with a Lesson. Note that it is not a dataset for reporting compliance. Instead, it is there to show volumes of Lesson activity.

How is it different to the Learning Progress dataset?

The Lesson History dataset provides insights into Lesson activity but does not track compliance. It is specifically designed to display the history of Lessons Users have completed. For compliance reporting, consider using the Fixed Learning Progress report or starting a new report using the Learning Progress dataset.

What can the Lesson history dataset be used for?

In reporting, each interaction is known as a Lesson 'use'. For example, if a learner views a Lesson five times, they will have five Lesson 'uses' for the Lesson. With the Lesson history dataset, you can look back at Lesson uses. For example, to show how many times a learner accessed a learning module or the number of times they failed before passing it.

Among the things you could do with the dataset are the following: 

• Track detailed User learning activity, including multiple interactions with a Lesson
• Summarise Lesson usage volumes at User, Lesson or Course level
• Pinpoint specific metrics such as Competency check passes and Lesson failures
• Track an individual User's progress from failure to Lesson completion

Tables built using the Lesson history dataset

Here are some examples of how the dataset might be used. 

This table visualisation shows Lesson history for an individual User:

This table visualisation shows Lesson history for all Users:

This table visualisation shows the number of attempts each User has made at completing an eLearning Lesson:

Discover more about User-created reports

For a hands-on learning experience, explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs. 

If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. You'll begin with Power BI’s top five features, then dive deeper into each one with step-by-step guidance.

Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, packed with 100+ common questions and in-depth resources. You can also join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.

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