If you're planning to create a report from scratch, you'll first need to choose the right dataset. In this article, we’ll summarise the Reporting and Analytics Datasets, and explain how they're used.
Note that reports are built using one dataset only. If your organisation uses Power BI or another external reporting tool, it is possible to extract all report data and transform the data as needed before loading it into your external reporting tools.
We'll cover:
- What is a dataset?
- How to choose a dataset
- Summary of the available datasets and how they can be used
Watch the video, and read on for more information:
What is a Dataset?
A Power BI dataset is a collection of pre-built fields, dates, and measures that are designed to give you a focused set of raw materials with which to build a report.
Field
A field is typically a non-numeric piece of data. For example, someone’s name, or a Course title, or perhaps a ‘yes/no’ statement such as whether a lesson is enabled or not enabled.
Search 'Name' (for example) to see all data items containing that term:
Date
A date is what you’d expect – a User’s start date, an Accreditation expiry date, a Course completion date, and so on.
Pro tip: hover to see a description of how to use the selected data item:
Measure
A measure is a numeric value. For example, the number of Courses for which a User is compliant, or perhaps the percentage of Accreditation assignments which are expired.
Pro tip: search with a hashtag to see all the measures available in the dataset you're using: View Datasets: Understanding data folders and data fields to find out more about how datasets are structured.
How to choose a dataset
Follow the steps to build a new User-created report. You will be prompted to select from one of the available datasets:
Summary of the available datasets and how they can be used
Once you know the type of report you want to build, choose from one of the following datasets:
Accreditation dataset
This contains Accreditation, User, Group and job profile data. It does not contain Course or Lesson data. The dataset is designed specifically to look at Accreditation data.
Find out more about the Accreditation analysis report, created using this dataset.
Added learning dataset
View and analyse data about learning records which your people have added themselves.
Find out more about the Added learning Fixed report, created using this dataset.
Catalogues, Courses, and Lessons administration dataset
This contains Catalogue, Course, and Lesson data. It does not contain any learning activity data. The dataset is designed to let you produce information about the structure of your Catalogues, Courses and Lessons. It also contains the Course and Lesson descriptions that you have added to Learn.
Find out more about the Catalogues, Courses and Lessons administration Fixed report, created using this dataset.
CPD dataset
Contains data about the CPD (Continuing Professional Development) Programmes to which people are assigned. This dataset also includes Other Learning data.
Find out more about the CPD report created using this dataset.
Development Activities dataset
Contains data about development activities data in Perform that your people have submitted.
Find out more about the Development Activities report, created using this dataset.
Evaluations dataset
Contains data about Course, Lesson and Event evaluations that your people have submitted.
Find out more about the Evaluations Fixed report, created using this dataset.
Events dataset
This contains Lesson, Event, User, Group and job profile data. It does not contain Course or Accreditation data. The dataset is designed to let you report on event data, choosing either events in the past, events in the future, or both.
Find out more about the Event management and analysis Fixed report, created using this dataset.
Feedback dataset
Contains data about feedback data in Perform that your people have submitted.
Find out more about the Feedback report, created using this dataset.
Learning progress dataset
This contains Course, Lesson, Other Learning, User, Group and job profile data. Note that the dataset does not contain Accreditation fields. However, it is important to understand that the data will take account of any repeat training requirements that apply to your Users.
Find out more about the Learning Progress Fixed report, created using this dataset.
Objectives dataset
Contains summary-level data about Perform objectives and Global objectives.
Find out more about the Objectives summary report, created using this dataset.
Reviews dataset
Contains summary-level and detail data about Perform reviews.
Find out more about the Reviews summary Fixed report, created using this dataset. View Using the Perform 'Review details' data-set if you'd like to drill into the details of reviews in your organisation.
User imports dataset
This contains data about the nightly user data import that takes place in Learn. It will not be of use to you if your Learn site does not have an automated data feed in place.
Find out more about the User import Fixed report, created using this dataset.
Users, Groups, and sign-in history dataset
This contains User, Group and sign-in history data. It does not contain any learning activity data. The dataset is designed to let you produce information about sign-in history, User volumes, Group structure and other administration-related topics.
Find out more about the Users, Groups, and sign in history Fixed report, created using this dataset.
Learning 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. This dataset also includes Other Learning data.
SCORM 2004 Dataset
SCORM is an industry-standard format used by eLearning authoring tools and all LMS systems. When eLearning is published at SCORM 2004 standard, Learn will record individual answers to questions. The SCORM 2004 analysis report details those question-level interactions.
Find out more about the SCORM question analysis Fixed report, created using this dataset.
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.