Get Data in Power BI
- Get Data from Files
- Get Data from Relational Data Sources
- Create Dynamic Reports with Parameters
- Get Data from a NoSQL Database
- Get Data from Online Services
- Select a Storage Mode
- Get Data from Azure Analysis Services
- Fix Performance Issues
- Resolve Data Import Errors
Exercise – Prepare Data in Power BI Desktop
- Check Your Knowledge
Clean, Transform, and Load Data in Power BI
- Shape the Initial Data
- Simplify the Data Structure
- Evaluate and Change Column Data Types
- Combine Multiple Tables into a Single Table
- Profile Data in Power BI
- Use Advanced Editor to Modify M Code
Exercise – Load Data in Power BI Desktop
- Check Your Knowledge
Design a Semantic Model in Power BI
- Work with Tables
- Create a Date Table
- Work with Dimensions
- Define Data Granularity
- Work with Relationships and Cardinality
- Resolve Modeling Challenges
Exercise – Model Data in Power BI Desktop
- Check Your Knowledge
Add Measures to Power BI Desktop Models
- Create Simple Measures
- Create Compound Measures
- Create Quick Measures
- Compare Calculated Columns with Measures
- Check Your Knowledge
Exercise – Create DAX Calculations in Power BI Desktop
Add Calculated Tables and Columns to Power BI Desktop Models
- Create Calculated Columns
- Learn about Row Context
- Choose a Technique to Add a Column
- Check Your Knowledge
Design Power BI Reports
- Design the Analytical Report Layout
- Design Visually Appealing Reports
- Report Objects
- Select Report Visuals
- Select Report Visuals to Suit the Report Layout
- Format and Configure Visualizations
- Work with Key Performance Indicators
Exercise – Design a Report in Power BI Desktop
- Check Your Knowledge
Configure Power BI Report Filters
- Introduction to Designing Reports for Filtering
- Apply Filters to the Report Structure
- Apply Filters with Slicers
- Design Reports with Advanced Filtering Techniques
- Consumption-Time Filtering
- Select Report Filter Techniques
- Case Study – Configure Report Filters Based on Feedback
- Check Your Knowledge
Create and Manage Workspaces in Power BI
- Distribute a Report or Dashboard
- Monitor Usage and Performance
- Recommend a Development Life Cycle Strategy
- Troubleshoot Data by Viewing Its Lineage
- Configure Data Protection
- Check Your Knowledge
Manage Semantic Models in Power BI
- Use a Power BI Gateway to Connect to On-Premises Data Sources
- Configure a Semantic Model Scheduled Refresh
- Configure Incremental Refresh Settings
- Manage and Promote Semantic Models
- Troubleshoot Service Connectivity
- Boost Performance with Query Caching (Premium)
- Check Your Knowledge