Question 1 of 30
A retail company is analyzing its sales data to create a hierarchy for better reporting in Power BI. The company wants to establish a hierarchy that includes the following levels: Country, State, City, and Store. Given the sales data structure, which of the following approaches would best facilitate the creation of this hierarchy in Power BI, ensuring that users can drill down from the highest level of Country to the most granular level of Store?
Create a separate table for each level of the hierarchy and establish relationships between them based on unique identifiers.
Use a single flat table that contains all levels of the hierarchy without any relationships.
Implement a calculated column that concatenates all levels into a single string for reporting purposes.
Create a hierarchy using only the Store level and aggregate the data at the Country level for visualization.

Preparing for Microsoft PL-300 Microsoft Power BI Data Analyst? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free