
Power BI Masterclass - Data Modelling - How to Create Dynamic Hierarchies
Interactive Video
•
Information Technology (IT), Architecture, Business
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
Read more
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the first step in creating a dynamic hierarchy?
Deleting unnecessary data
Adding a new column
Creating a new data model
Modifying the orders table
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Why is an index column added during data preparation?
To assist with the unpivoting process
To sort the data alphabetically
To filter out unnecessary data
To create a backup of the data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What should be ensured about the hierarchy table before proceeding to create visuals?
It is exported to a new file
It is duplicated
It is not connected to the data model
It is connected to the data model
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of using a slicer in the visual?
To add more data
To filter data dynamically
To create a new hierarchy
To delete unnecessary columns
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the main feature of a dynamic hierarchy?
It creates a new data model
It enables hierarchical filtering
It automatically updates data
It allows multiple selections
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can a second hierarchy table be created?
By importing a new dataset
By exporting the existing table
By using a DAX expression
By manually entering data
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the relationship type used between the two hierarchy tables?
One-to-many
Many-to-many
None
One-to-one
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?