Microsoft Power BI Data Analyst PL300 - United Kingdom

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 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 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 Visualisations
• 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
• Optimise 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 Specialised 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