Table of Contents
Introduction
Module 1: Prepare the Data
Lesson 1: Get or connect to data
1.1 Identify and connect to data sources or a shared semantic model
1.2 Change data source settings, including credentials and privacy levels
1.3 Choose between DirectQuery and Import
1.4 Create and modify parameters
Lesson 2: Profile and clean the data
2.1 Evaluate data, including data statistics and column properties
2.2 Resolve inconsistencies, unexpected or null values, and data quality issues
2.3 Resolve data import errors
Lesson 3: Transform and load the data
3.1 Select appropriate column data types
3.2 Create and transform columns
3.3 Group and aggregate rows
3.4 Pivot, unpivot, and transpose data
3.5 Convert semi-structured data to a table
3.6 Create fact tables and dimension tables
3.7 Identify when to use reference or duplicate queries and the resulting impact
3.8 Merge and append queries
3.9 Identify and create appropriate keys for relationships
3.10 Configure data loading for queries
Module 2: Model the Data
Lesson 4: Design and implement a data model
4.1 Configure table and column properties
4.2 Implement role-playing dimensions
4.3 Define a relationship's cardinality and cross-filter direction
4.4 Create a common date table
4.5 Identify use cases for calculated columns and calculated tables
Lesson 5: Create model calculations by using DAX
5.1 Create single aggregation measures
5.2 Use the CALCULATE function
5.3 Implement time intelligence measures
5.4 Use basic statistical functions
5.5 Create semi-additive measures
5.6 Create a measure by using quick measures
5.7 Create calculated tables or columns
5.8 Create calculation groups
Lesson 6: Optimize model performance
6.1 Improve performance by identifying and removing unnecessary rows and columns
6.2 Identify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query view
6.3 Improve performance by reducing granularity
Module 3: Visualize and Analyze the Data
Lesson 7: Create reports
7.1 Select an appropriate visual
7.2 Format and configure visuals
7.3 Apply and customize a theme
7.4 Apply conditional formatting
7.5 Apply slicing and filtering
7.6 Configure the report page
7.7 Choose when to use a paginated report
7.8 Create visual calculations by using DAX
Lesson 8: Enhance reports for usability and storytelling
8.1 Configure bookmarks
8.2 Create custom tooltips
8.3 Edit and configure interactions between visuals
8.4 Configure navigation for a report
8.5 Apply sorting to visuals
8.6 Configure sync slicers
8.7 Group and layer visuals by using the Selection pane
8.8 Configure drill through navigation
8.9 Configure export settings
8.10 Design reports for mobile devices
8.11 Enable personalized visuals in a report
8.12 Design and configure Power BI reports for accessibility
8.13 Configure automatic page refresh
Lesson 9: Identify patterns and trends
9.1 Use the Analyze feature in Power BI
9.2 Use grouping, binning, and clustering
9.3 Use AI visuals
9.4 Use reference lines, error bars, and forecasting
9.5 Detect outliers and anomalies
Module 4: Manage and Secure Power BI
Lesson 10: Create and manage workspaces and assets
10.1 Create and configure a workspace
10.2 Configure and update a workspace app
10.3 Publish, import, or update items in a workspace
10.4 Create dashboards
10.5 Choose a distribution method
10.6 Configure subscriptions and data alerts
10.7 Promote or certify Power BI content
10.8 Identify when a gateway is required
10.9 Configure a semantic model scheduled refresh
Lesson 11: Secure and govern Power BI items
11.1 Assign workspace roles
11.2 Configure item-level access
11.3 Configure access to semantic models
11.4 Implement row-level security roles
11.5 Configure row-level security group membership
11.6 Apply sensitivity labels
Summary
