*** 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:
Get deeper learning in The Academy
If you’re completely new to reporting and analytics, then Get started: Reporting and analytics with Power BI is the place to start. We'll start by introducing Power BI’s top five features, then, we’ll take a deep dive into each feature, with links to related learning and tips from the Kallidus team along the way.
If you're starting to explore user-created reports, take a look at Power BI Reporting: Deep dive previews. In this short course, you'll get a quick preview of each 'deep dive' scenario. If a scenario sparks your interest, follow the links in the Lesson description to view the full course.
Do you have a question about reporting? Come to our 'Ask me Anything' events in the Academy to ask questions 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.
Comments
0 comments
Please sign in to leave a comment.