Course Catalog
Design and manage analytics solutions using Power BI (PL-300)
Code: PL-300
Duration: 3 Day
$2095 USD

OVERVIEW

The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

LEARN MORE

Elite Total Access Collection for Microsoft
Access this course and over 50 other instructor-led training courses for only $2,999.

 

WATCH NOW

Microsoft Azure Certification Video

DELIVERY FORMAT

This course is available in the following formats:

Virtual Classroom

Duration: 3 Day
Classroom

Duration: 3 Day

CLASS SCHEDULE

Delivery Format: Virtual Classroom
Date: Sep 28 2026 - Sep 30 2026 | 09:00 - 17:00 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Oct 14 2026 - Oct 16 2026 | 09:00 - 17:00 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Nov 09 2026 - Nov 11 2026 | 09:00 - 17:00 EST
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Dec 14 2026 - Dec 16 2026 | 09:00 - 17:00 EST
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Jan 04 2027 - Jan 06 2027 | 08:30 - 16:30 EST
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Feb 15 2027 - Feb 17 2027 | 08:30 - 16:30 EST
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Mar 15 2027 - Mar 17 2027 | 08:30 - 16:30 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Apr 19 2027 - Apr 21 2027 | 08:30 - 16:30 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: May 10 2027 - May 12 2027 | 08:30 - 16:30 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Jun 07 2027 - Jun 09 2027 | 08:30 - 16:30 EDT
Location: Online
Course Length: 3 Day

$ 2095

Delivery Format: Virtual Classroom
Date: Jul 06 2027 - Jul 08 2027 | 08:30 - 16:30 EDT
Location: Online
Course Length: 3 Day

$ 2095

GOALS
OUTLINE

Module 1 : Get started with Microsoft data analytics- Discover data analysis

  • Get started building with Power BI
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with Copilot in Power BI

Module 2 : Prepare data for analysis with Power BI-Get data in Power BI

  • Clean, transform, and load data in Power BI
  • Choose a Power BI model framework

Module 3 : Model data with Power BI

  • Configure a semantic model
  • Write DAX formulas for semantic models
  • Create DAX calculations in semantic models
  • Modify DAX filter context in semantic models
  • Use DAX time intelligence functions in semantic models
  • Create visual calculations in Power BI Desktop
  • Optimize a model for performance in Power BI

Module 4 : Design effective reports in Power BI

  • Scope report design requirements
  • Design Power BI reports
  • Enhance Power BI report designs for the user experience
  • Perform analytics in Power BI

Module 5 : Manage and secure Power BI

  • Manage workspaces in Power BI service
  • Manage semantic models in Power BI
  • Choose a content distribution method
  • Create dashboards in Power BI
  • Secure data access in Power BI

Module 1 : Get started with Microsoft data analytics- Discover data analysis

  • Get started building with Power BI
  • Introduction to end-to-end analytics using Microsoft Fabric
  • Get started with Copilot in Power BI

Module 2 : Prepare data for analysis with Power BI-Get data in Power BI

  • Clean, transform, and load data in Power BI
  • Choose a Power BI model framework

Module 3 : Model data with Power BI

  • Configure a semantic model
  • Write DAX formulas for semantic models
  • Create DAX calculations in semantic models
  • Modify DAX filter context in semantic models
  • Use DAX time intelligence functions in semantic models
  • Create visual calculations in Power BI Desktop
  • Optimize a model for performance in Power BI

Module 4 : Design effective reports in Power BI

  • Scope report design requirements
  • Design Power BI reports
  • Enhance Power BI report designs for the user experience
  • Perform analytics in Power BI

Module 5 : Manage and secure Power BI

  • Manage workspaces in Power BI service
  • Manage semantic models in Power BI
  • Choose a content distribution method
  • Create dashboards in Power BI
  • Secure data access in Power BI
LABS

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

Lab : Loading Data in Power BI Desktop

  • Loading Data

Lab : Data Modeling in Power BI Desktop

  • Create Model Relationships
  • Configure Tables and column properties
  • Create hierarchies

Lab : Introduction to DAX in Power BI Desktop

  • Create calculated tables
  • Create calculated columns
  • Create measures

Lab : Advanced DAX in Power BI Desktop

  • Use the CALCULATE() function to manipulate filter context
  • Use Time Intelligence functions

Lab : Enhancing reports with interaction and formatting in Power BI Desktop

  • Create and configure Sync Slicers
  • Create a drillthrough page
  • Apply conditional formatting
  • Create and use Bookmarks

Lab : Designing a report in Power BI Desktop

  • Design a report
  • Configure visual fields and format properties

Lab : Creating a Dashboard in Power BI Service

  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Use Q&A to create a dashboard tile

Lab : Data Analysis in Power BI Desktop

  • Create animated scatter charts
  • Use the visual to forecast values

Lab : Enforce Row-Level Security

  • Configure many-to-many relationships
  • Enforce row-level security

Lab : Preparing Data in Power BI Desktop

  • Prepare Data

Lab : Loading Data in Power BI Desktop

  • Loading Data

Lab : Data Modeling in Power BI Desktop

  • Create Model Relationships
  • Configure Tables and column properties
  • Create hierarchies

Lab : Introduction to DAX in Power BI Desktop

  • Create calculated tables
  • Create calculated columns
  • Create measures

Lab : Advanced DAX in Power BI Desktop

  • Use the CALCULATE() function to manipulate filter context
  • Use Time Intelligence functions

Lab : Enhancing reports with interaction and formatting in Power BI Desktop

  • Create and configure Sync Slicers
  • Create a drillthrough page
  • Apply conditional formatting
  • Create and use Bookmarks

Lab : Designing a report in Power BI Desktop

  • Design a report
  • Configure visual fields and format properties

Lab : Creating a Dashboard in Power BI Service

  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Use Q&A to create a dashboard tile

Lab : Data Analysis in Power BI Desktop

  • Create animated scatter charts
  • Use the visual to forecast values

Lab : Enforce Row-Level Security

  • Configure many-to-many relationships
  • Enforce row-level security
WHO SHOULD ATTEND

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

PREREQUISITES

None