Prepare the dataPublished weight 25–30%
100 exam-scoped practice questions in the app
Explore Prepare topics
- Get or connect to data
- Profile and clean the data
- Transform and load the data
- Tests choosing Import, DirectQuery, or DirectLake and building clean fact and dimension tables in Power Query.
- Candidates use Duplicate when a query needs to stay linked to its source through Reference instead.
- Trace a chained query back to its source before choosing Reference or Duplicate on that step.
Model the dataPublished weight 25–30%
101 exam-scoped practice questions in the app
Explore Model topics
- Design and implement a data model
- Create model calculations by using DAX
- Optimize model performance
- Filter context, time intelligence, and picking a calculated column against a measure are what this domain checks.
- A calculated column gets reached for even when the scenario needs a measure evaluated at query time instead.
- Ask whether the value should be fixed per row or recalculated for whatever the visual filters.
Visualize and analyze the dataPublished weight 25–30%
118 exam-scoped practice questions in the app
Explore Visualize topics
- Create reports
- Enhance reports for usability and storytelling
- Identify patterns and trends
- Tests picking the right visual, navigation feature, or AI visual for a described reporting need.
- Candidates default to a familiar chart type even when the scenario calls for a different visual.
- Match the described trend, outlier, or driver to the AI visual built for that specific job.
Manage and secure Power BIPublished weight 15–20%
79 exam-scoped practice questions in the app
Explore Manage topics
- Create and manage workspaces and assets
- Secure and govern Power BI items
- Workspace roles, deployment pipelines, and choosing row-level versus object-level security correctly are the focus here.
- Under-revision here leaves row-level and object-level security tangled together in governance scenarios.
- Remember row-level security filters rows, while object-level security hides a whole table or column.