Microsoft Power BI Data Analyst PL300 Course Outline
Module 1: Discover Data Analysis
- Introduction
- Overview of Data Analysis
- Roles in Data
- Tasks of a Data Analyst
Module 2: Get Started Building with Power BI
- Introduction
- Use Power BI
- Building Blocks of Power BI
- Tour and Use the Power BI Service
Module 3: Get Data in Power BI
- Introduction
- 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
Module 4: Clean, Transform and Load Data in Power BI
- Introduction
- 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
Module 5: Design a Data Model in Power BI
- Introduction
- Work with Tables
- Create a Date Table
- Work with Dimensions
- Define Data Granularity
- Work with Relationships and Cardinality
- Resolve Modelling Challenges
- Exercise - Model Data in Power BI Desktop
Module 6: Add Measures to Power BI Desktop Models
- Introduction
- Create Simple Measures
- Create Compound Measures
- Create Quick Measures
- Compare Calculated Columns with Measures
- Exercise - Create DAX Calculations in Power BI Desktop
Module 7: Add Calculated Tables and Columns to Power BI Desktop Models
- Introduction
- Create Calculated Columns
- Learn About Row Context
- Choose a Technique to Add a Column
Module 8: Use DAX Time Intelligence Functions in Power BI Desktop Models
- Introduction
- Use DAX Time Intelligence Functions
- Additional Time Intelligence Calculations
- Exercise - Create Advanced DAX Calculations in Power BI Desktop
Module 9: Optimise a Model for Performance in Power BI
- Introduction to Performance Optimization
- Review Performance of Measures, Relationships, and Visuals
- Use Variables to Improve Performance and Troubleshooting
- Reduce Cardinality
- Optimize Directquery Models with Table Level Storage
- Create and Manage Aggregations
Module 10: Design Power BI Reports
- Introduction
- 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
Module 11: 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
Module 12: Enhance Power BI Report Designs for the User Experience
- Design Reports to Show Details
- Design Reports to Highlight Values
- Design Reports that Behave Like Apps
- Work with Bookmarks
- Design Reports for Navigation
- Work with Visual Headers
- Design Reports with Built-In Assistance
- Tune Report Performance
- Optimize Reports for Mobile Use
- Exercise - Enhance Power BI Reports
Module 13: Perform Analytics in Power BI
- Introduction to Analytics
- Explore Statistical Summary
- Identify Outliers with Power BI Visuals
- Group and Bin Data for Analysis
- Apply Clustering Techniques
- Conduct Time Series Analysis
- Use the Analyse Feature
- Create What-If Parameters
- Use Specialized Visuals
- Exercise - Perform Advanced Analytics with AI Visuals
Module 14: Create and Manage Workspaces in Power BI
- Introduction
- Distribute a Report or Dashboard
- Monitor Usage and Performance
- Recommend a Development Life Cycle Strategy
- Troubleshoot Data by Viewing Its Lineage
- Configure Data Protection
Module 15: Manage Datasets in Power BI
- Introduction
- Use a Power BI Gateway to Connect to On-Premises Data Sources
- Configure a Dataset Scheduled Refresh
- Configure Incremental Refresh Settings
- Manage and Promote Datasets
- Troubleshoot Service Connectivity
- Boost Performance with Query Caching
Module 16: Create Dashboards in Power BI
- Introduction to Dashboards
- Configure Data Alerts
- Explore Data by Asking Questions
- Review Quick Insights
- Add a Dashboard Theme
- Pin a Live Report Page to a Dashboard
- Configure a Real-Time Dashboard
- Configure Data Classification
- Set Mobile View
- Exercise - Create A Power BI Dashboard
Module 17: Implement Row-Level Security
- Introduction
- Configure Row-Level Security with the Static Method
- Configure Row-Level Security with the Dynamic Method
- Exercise - Enforce Row-Level Security in Power BI