Reporting - Datasets: Understanding data folders and data fields

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

In this article, we'll look at how a dataset is structured and how to use the data inside it. 

When you start a new report you'll be prompted to select a Dataset. This will include Data fields - information such as Name, Title, Course title etc) and measures. Measures are pre-built calculations with numeric data. For example, the % of enabled Users or the number of Users with a 'Not started' status for a Course. 

The Dataset selected will determine the Data folders available and the Data Fields available to include in the report. Find out more about the available datasets. 

Watch the video to find out more (We’ve chosen the Accreditation analysis dataset as an example, but the principles apply to other datasets too):

The Data panel

The Data panel contains folders, within which you will find all the information typically required to build a report with the selected dataset.

For example, The Accreditation dataset contains folders titled Accreditation, Accreditation, history, User and so on. Every folder contains subfolders. The 'Details' folder, for example, will contain typically non-numeric information such as Accreditation type, Accreditation title, Accreditation code, and so on.

There are also folders of custom fields, measures (pre-built calculations with numeric data), and Users - containing details such as 'last sign-in', start date, etc.

A green tick will identify when a data item is used in a visualisation, for example a table:

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.