Part 1: Introduction and Power Query

1. Introducing Power BI

• Explore the Different Roles in Data
• Identify the Tasks Performed by a Data Analyst
• Describe the Power BI Products and Services
• Introducing Power BI Desktop

2. Loading Data

• Load Data from Text and Excel Files
• Load Data from Relational Databases
• Import, DirectQuery, and Connect Live Modes
• Composite Mode
• Load Data from OneDrive and SharePoint
• Load Data from Microsoft Dataverse
• Load Data from the Internet
• Connect to a Published Dataset
• Connect to a Dataflow

3. Transforming Data

• Profile Data
• Cleanse Data
• Shape Datasets
• Transform Datasets
• Query Folding
• Merge and Append Data
• Fuzzy Lookups
• Structure and Manage Queries
• View Query Dependencies
• Power Query Parameters
• Power BI Template Files
• Introduction to the M Language
• Create a User Defined Function with M
• Get the Time of the Last Data Refresh

Part 2: Data Modelling and DAX

4. Data Modelling

• Basic Data Modelling Concepts
• Fact and Dimension Tables
• Configure Table and Column Properties
• Categorise Data
• Sorting Columns
• Organise Content with Display Folders
• Create and Manage Relationships
• Understand Filter Propagation
•  

5. The DAX Expression Language

• Introduction to DAX
• Extend the Data Model with Calculated Columns
• Add Measures to the Data Model
• Implicit v Explicit Measures
• Quick Measures
• Manipulate the Filter Context with CALCULATE
• Create Calculated Tables
• Use Variables
• Create a Date Table
• Analyse Data over Time (Time Intelligence)
• Optimise the Storage Model
• Optimise DirectQuery Models
• Create and Manage Aggregations

Part 3: Reports and Visuals

6. Visualising Data

• Implement and Format Table and Matrix Visuals
• Rename Fields in Visuals
• Show Items with no Data
• Conditionally Format Visual Content
• Use Card Visuals
• Implement and Format Charts
• Report Themes
• Use the Small Multiples Chart Option
• Sparklines
• Use Tooltips
• Implement Reports as Tooltips
• Implement and Use Hierarchies
• Group and Bin Data
• Continuous v Categorical Axis
• Custom Grouping
• Automatically Find Clusters of Data
• Animate Scatter Charts
• Use the Analytics Pane
• Forecasting & Anomaly Detection
• Use the Analyse Feature
• Tree Maps
• Gauges and KPIs
• Implement Maps
• Resolve Location Errors in Maps
• Implement Slicers
• Visual, Page, and Report Level Filters
• Synchronise Slicers across Pages
• Cross-Filtering and Cross-Highlighting
• Analyse the Performance of Visuals

Part 4: Enhancing and Publishing Reports

7. Enhancing the User Experience

• Analyse Data with Decomposition Trees
• Analyse Data with Key Influencers
• Drillthrough Reports
• What-If Parameters
• Field Parameters
• Implement Bookmarks
• Implement Buttons
• Text Boxes, Shapes, and Images
• Page & Bookmark Navigation
• Show and Hide Content
• Implement and Manage Q&A
• Smart Narrative
• Custom Visuals and Slicers
• Scorecards & Power BI Metrics (aka Goals)
• Mobile Report Layout

8. The Power BI Web Service

• Introduction to the Power BI Web Service
• Publish Reports to the Power BI Web Service
• Manage and Organise Content in Workspaces
• Create and Manage Dashboards
• Dashboard Themes
• Set up Data Alerts
• Share Content and Workspaces
• Create and Distribute Apps
• Promote & Certify Content
• Sensitivity Labels
• Secure Data with Row Level Security (RLS)
• Object Level Security
• Refresh Datasets
• Understand Data Gateways
• Change Detection
• Incremental Refresh
• Quick Insights
• Analyse in Excel
• Export Reports
• Support for Paginated Reports in Power BI