Prepare the data (15–20%)

Get data from different data sources

• Identify and connect to a data source
• Change data source settings
• Select a shared dataset or create a local dataset
• Select a storage mode
• Use Microsoft Dataverse
• Change the value in a parameter
• Connect to a data flow

Clean, transform, and load the data

• Profile the data
• Resolve inconsistencies, unexpected or null values, and data quality issues
• Identify and create appropriate keys for joins
• Evaluate and transform column data types
• Shape and transform tables
• Combine queries
• Apply user-friendly naming conventions to columns and queries
• Configure data loading
• Resolve data import errors

Model the data (30–35%)

Design a data model

• Define the tables
• Configure table and column properties
• Design and implement role-playing dimensions
• Define a relationship’s cardinality and cross-filter direction
• Design a data model that uses a star schema
• Create a common date table

Develop a data model

• Create calculated tables
• Create hierarchies
• Create calculated columns
• Implement row-level security roles
• Use the Q&A feature

Create model calculations by using DAX

• Create basic measures by using DAX
• Use CALCULATE to manipulate filters
• Implement Time Intelligence using DAX
• Replace implicit measures with explicit measures
• Use basic statistical functions
• Create semi-additive measures
• Use quick measures

Optimize model performance

• Remove unnecessary rows and columns
• Identify poorly performing measures, relationships, and visuals
• Reduce cardinality levels to improve performance

Visualize and analyze the data (25–30%)

Create reports

• Add visualization items to reports
• Choose an appropriate visualization type
• Format and configure visualizations
• Use a custom visual
• Apply and customize a theme
• Configure conditional formatting
• Apply slicing and filtering
• Configure the report page
• Use the Analyze in Excel feature
• Choose when to use a paginated report

Create dashboards

• Manage tiles on a dashboard
• Configure mobile view
• Use the Q&A feature
• Add a Quick Insights result to a dashboard
• Apply a dashboard theme
• Pin a live report page to a dashboard

Enhance reports for usability and storytelling

• Configure bookmarks
• Create custom tooltips
• Edit and configure interactions between visuals
• Configure navigation for a report
• Apply sorting
• Configure Sync Slicers
• Group and layer visuals by using the selection pane
• Drilldown into data using interactive visuals
• Export report data
• Design reports for mobile devices

Identify patterns and trends

• Use the Analyze feature in Power BI
• Identify outliers
• Choose between continuous and categorical axes
• Use groupings, binnings, and clustering
• Use AI visuals
• Use the Forecast feature
• Create reference lines by using the Analytics pane

Deploy and maintain assets (20–25%)

Manage files and datasets

• Identify when a gateway is required
• Configure a dataset scheduled refresh
• Configure row-level security group membership
• Provide access to datasets
• Manage global options for files

Manage workspaces

• Create and configure a workspace
• Assign workspace roles
• Configure and update a workspace app
• Publish, import, or update assets in a workspace
• Apply sensitivity labels to workspace content
• Configure subscriptions and data alerts
• Promote or certify Power BI content

Let’s work together.