Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Graduate School USA

PL-300: Microsoft Power BI Data Analyst Course

via Graduate School USA

Overview

Learn to become a Microsoft Power BI Data Analyst through this comprehensive course covering the PL-300 certification path. Master the fundamentals of data analytics and Power BI, starting with data acquisition techniques and performance optimization strategies. Develop skills in cleaning, transforming, and loading data while learning to shape datasets, profile data quality, and enhance data structures for optimal analysis. Build robust data models by understanding modeling principles, working with tables, creating dimensions and hierarchies, establishing relationships, and configuring table and column properties. Gain proficiency in DAX (Data Analysis Expressions) to create calculated tables, columns, and measures while mastering the CALCULATE() function for filter context manipulation and implementing Time Intelligence functions for temporal analysis. Optimize model performance through data model enhancement techniques and DirectQuery optimization strategies. Create compelling reports by designing layouts, enhancing visualizations, configuring sync slicers, building drillthrough pages, applying conditional formatting, and utilizing bookmarks for interactive navigation. Develop dynamic dashboards with real-time capabilities, learn to pin visuals effectively, and leverage Q&A functionality for natural language queries. Explore advanced analytics features including AI-powered visuals, animated scatter charts, and forecasting capabilities to identify patterns and trends in your data. Master workspace creation and management for collaborative environments while learning to share and manage assets effectively. Handle files and datasets using parameters and dataset management techniques, and implement robust security measures including row-level security configuration and many-to-many relationship enforcement to protect sensitive information.

Syllabus

Module 1 Get Started with Microsoft Data Analytics

  • Data Analytics and Microsoft
  • Getting Started with Power BI

Module 2 Getting Data in Power BI

  • Data Analytics and Microsoft
  • Optimize Performance
  • Resolve Data Errors

Module 3 Cleaning, Transforming, and Loading Data in Power BI

  • Shaping the Data
  • Profiling the Data
  • Enhance the data structure

Module 4 Design a Data Model in Power BI

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies
  • Create Model Relationships
  • Configure Tables and Column Properties
  • Create hierarchies

Module 5 Create Model Calculations using DAX in Power BI

  • Introduction to DAX
  • Real-time dashboards
  • Advanced DAX
  • Create calculated tables
  • Create calculated columns
  • Create measures
  • Use the CALCULATE() function to manipulate filter context
  • Use Time Intelligence functions

Module 6 Optimize Model Performance in Power BI

  • Optimize the data model for performance
  • Optimize DirectQuery Models

Module 7 Create Reports in Power BI

  • Design a report
  • Enhance the report
  • Create and configure Sync Slicers
  • Create a drillthrough page
  • Apply conditional formatting
  • Create and use Bookmarks
  • Design a report
  • Configure visual fields and format properties

Module 8 Create Dashboards in Power BI

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard
  • Create a Dashboard
  • Pin visuals to a Dashboard
  • Use Q&A to create a dashboard tile

Module 9 Identify Patterns and Trends in Power BI

  • Advanced Analytics
  • Data Insights through AI visuals
  • Create animated scatter charts
  • Use the visual to forecast values

Module 10 Create and Manage Workspaces in Power BI

  • Creating Workspaces
  • Sharing and Managing Assets

Module 11 Manage Files and Datasets in Power BI

  • Parameters
  • Datasets

Module 12 Row-level Security in Power BI

  • Security in Power BI
  • Configure many-to-many relationships
  • Enforce row-level security

Taught by

Bruce Gay, Steve Pesklo, and Joe Mlakar

Reviews

Start your review of PL-300: Microsoft Power BI Data Analyst Course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.