Course Overview

Course Curriculum

Course Content

  • PL-300 Microsoft Power BI Certification Training with Exam
    Preview
    • Lesson 01: Course Introduction
      Preview
      • 1.01 Welcome to Power BI Course
        00:23
      • 1.02 Skills Covered
        01:19
      • 1.03 Business Intelligence and Data Analytics High level Overview
        05:53
      • 1.04 Introduction to Power BI
        02:04
      • 1.05 Different Power BI Offerings
        02:44
      • 1.06 Installing Power BI
        02:44
    • Lesson 02: Get Data From Different Data Sources
      Preview
      • 2.01 Identify and Connect to a Data Source
        01:55
      • 2.02 Change Data Source Settings
        00:41
      • 2.03 Select a Shared Dataset
        01:23
      • 2.04 Select a Storage Mode
        01:08
      • 2.05 Choose an Appropriate Query Type
        02:04
      • 2.06 Use Microsoft Dataverse
        01:22
      • 2.07 Use Parameters
        02:13
      • 2.08 Use or Create a PBIDS file
        01:18
    • Lesson 03: Profile The Data
      • 3.01 Identify Data Anomalies
        01:29
      • 3.02 Examine Data Structures
        01:29
      • 3.03 Interrogate Column Properties
        01:42
      • 3.04 Interrogate Data Statistics
        02:40
    • Lesson 04: Clean Transform and Load the Data
      Preview
      • 4.01 Resolve Inconsistencies Unexpected or Null Values and Data Quality Issues
        03:51
      • 4.02 Apply User friendly Value Replacements
        02:10
      • 4.03 Evaluate and Transform Column Data Types
        02:19
      • 4.04 Apply Data Shape Transformations to Table Structures
        02:57
      • 4.05 Combine Queries
        01:13
      • 4.06 Apply User friendly Naming Conventions to Columns and Queries
        01:51
      • 4.07 Leverage Advanced Editor to Modify Power Query M code
        01:43
    • Lesson 05: Design a Data Model
      • 5.01 Define the Tables
        03:01
      • 5.02 Configure Table and Column Properties
        03:22
      • 5.03 Flatten out a Parent child Hierarchy
        03:33
      • 5.04 Define Role playing Dimensions
        01:34
      • 5.05 Create a Common Date Table
        01:51
    • Lesson 06: Develop a Data Model
      Preview
      • 6.01 Apply Cross filter Direction and Security Filtering
        02:36
      • 6.02 Create Calculated Tables
        01:35
      • 6.03 Create Calculated Columns
        01:16
      • 6.04 Implement Row level Security Roles
        01:50
      • 6.05 Set up the Q and A Feature
        02:10
    • Lesson 07: Optimize Model Performance
      Preview
      • 7.01 Remove Unnecessary Rows and Columns
        01:01
      • 7.02 Identify Poorly Performing Measures Relationships and Visuals
        03:00
      • 7.03 Improve Cardinality Levels
        02:40
      • 7.04 Optimize DirectQuery Models
        01:26
      • 7.05 Create and Manage Aggregations
        01:56
      • 7.06 Use Query Diagnostics
        02:34
    • Lesson 08: Create Reports
      Preview
      • 8.01 Add Visualization Items to Reports
        00:36
      • 8.02 Choose an Appropriate Visualization Type
        04:34
      • 8.03 Format and Configure Visualizations
        02:49
      • 8.04 Apply Slicing and Filtering
        02:26
      • 8.05 Add an R or Python Visual
        01:58
    • Lesson 09: Create Dashboards
      Preview
      • 9.01 Set Mobile View
        01:24
      • 9.02 Manage Tiles on a Dashboard
        03:26
      • 9.03 Configure Data Alerts
        02:17
      • 9.04 Use the Q and A Feature
        01:27
      • 9.05 Add a Dashboard Theme
        01:59
      • 9.06 Pin a Live Report Page to a Dashboard
        01:21
    • Lesson 10: Enhance Reports to Expose Insights
      Preview
      • 10.01 Perform Top N Analysis
        01:05
      • 10.02 Explore Statistical Summary
        01:31
      • 10.03 Use the Q and A Visual
        01:28
      • 10.04 Add a Quick Insights Result to a Report
        02:20
      • 10.05 Use the Play Axis Feature of a Visualization
        00:48
      • 10.06 Personalize Visuals
        01:33
    • Lesson 11: Perform Advanced Analysis
      Preview
      • 11.01 Identify Outliers
        01:17
      • 11.02 Conduct Time Series Analysis
        00:41
      • 11.03 Use Groupings and Binnings
        01:59
      • 11.04 Use the Key Influencers to Explore Dimensional Variances
        00:58
      • 11.05 Use the Decomposition Tree Visual to Break Down a Measure
        01:16
      • 11.06 Apply AI Insights
        01:27
    • Lesson 12: Manage Semantic Models
      Preview
      • 12.01 Configure a Dataset Scheduled Refresh
        01:59
      • 12.02 Configure Row level Security Group Membership
        01:54
      • 12.03 Configure Incremental Refresh Settings
        03:03
      • 12.04 Promote or Certify Power BI Datasets
        01:50

Why Join this Program

  • Develop skills for real career growthCutting-edge curriculum designed in guidance with industry and academia to develop job-ready skills
  • Learn from experts active in their field, not out-of-touch trainersLeading practitioners who bring current best practices and case studies to sessions that fit into your work schedule.
  • Learn by working on real-world problemsCapstone projects involving real world data sets with virtual labs for hands-on learning
  • Structured guidance ensuring learning never stops24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts

Recommended Learning Materials for Upskilling

Explore free webinars, tutorials, career guides, and practical reads to go deeper

  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.
  • *All trademarks are the property of their respective owners and their inclusion does not imply endorsement or affiliation.
  • Career Impact Results vary based on experience and numerous factors.