Microsoft Power BI Data Analyst PL300 - Canada

Microsoft Power BI Data Analyst PL300 Course Outline

Module 1: Discover Data Analysis

• Overview of Data Analysis
• Roles in Data
• Tasks of a Data Analyst

Module 2: Get Started Building with Power BI

• Use Power BI
• Building Blocks of Power BI
• Tour and Use the Power BI Service

Module 3: 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

Module 4: 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

Module 5: Describe Power BI Desktop Models

• Star Schema Design
• Analytic Queries
• Configure Report Visuals

Module 6: Choose a Power BI Model Framework

• Describe Power BI Model Fundamentals
• Determine When to Develop an Import Model
• Determine When to Develop a Directquery Model
• Determine When to Develop a Composite Model
• Choose a Model Framework

Module 7: 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

Module 8: Write Dax Formulas for Power BI Desktop Models

• Write Dax Formulas
• Dax Data Types
• Work with Dax Functions
• Use Dax Operators
• Use Dax Variables

Module 9: 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

Module 10: Add Calculated Tables and Columns to Power BI Desktop Models

• Create Calculated Columns
• Learn About Row Context
• Choose a Technique to Add a Column

Module 11: Use Dax Time Intelligence Functions in Power BI Desktop Models

• Use Dax Time Intelligence Functions
• Additional Time Intelligence Calculations
• Exercise - Create Advanced Dax Calculations in Power BI Desktop

Module 12: Optimise a Model for Performance in Power Bi

• Introduction to Performance Optimisation
• Review Performance of Measures, Relationships, And Visuals
• Use Variables to Improve Performance and Troubleshooting
• Reduce Cardinality
• Optimise Directquery Models with Table Level Storage
• Create and Manage Aggregations

Module 13: Enforce Power BI Model Security

• Restrict Access to Power BI Model Data
• Restrict Access to Power BI Model Objects
• Apply Good Modeling Practices
• Exercise: Enforce Model Security

Module 14: Scope Report Design Requirements

• Identify the Audience
• Determine Report Types
• Define User Interface Requirements
• Define User Experience Requirements
• Explore Report Designs

Module 15: 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 Visualisations
• Work with Key Performance Indicators
• Exercise - Design a Report in Power Bi Desktop

Module 16: 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 17: 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
• Optimise Reports for Mobile Use
• Exercise - Enhance Power BI Reports

Module 18: 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 Specialised Visuals
• Exercise - Perform Advanced Analytics with Ai Visuals

Module 19: Create Paginated Reports

• Introduction to Paginated Reports
• Get Data
• Create a Paginated Report
• Work with Charts on the Report
• Publish the Report

Module 20: 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

Module 21: 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)

Module 22: 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
• Set Mobile View
• Exercise - Create a Power BI Dashboard

Module 23: Implement Row-Level Security

• Configure Row-Level Security with the Static Method
• Configure Row-Level Security with the Dynamic Method
• Exercise - Enforce Row-Level Security in Power BI