Microsoft Power BI PL-300 Program Curriculum

Comprehensive, industry-focused training designed to make you job-ready in Power BI & Data Analytics

Program Duration: 40 Hours

Power BI Fundamentals

• Introduction to Business Intelligence (BI)
• Stages of BI & Importance
• Power BI Overview & Components
• Architecture & Building Blocks
• Power BI Desktop Setup & Workflow
• Report Creation Process

Data Sources & Integration

• Excel, CSV Data Import
• SQL Server / MySQL Integration
• API & Cloud Data Sources

Report Development & Visualization

• Creating Interactive Reports
• Charts: Bar, Line, Pie, Donut, Area
• Advanced Visuals: Gauge, Ribbon, KPI
• Formatting, Branding & UI Design
• Filters, Slicers & Interactions

Data Transformation (Power Query)

• Data Cleaning & Formatting
• Merge, Append, Group By
• Pivot / Unpivot, Split Columns
• Custom & Conditional Columns
• Data Profiling & Best Practices

Advanced Data Visualization

• Drill Down, Drill Through
• Bookmarks & Navigation
• Custom Visuals & Tooltips
• Maps & Geographical Analysis
• Performance Analyzer

Data Modeling

• Relationships & Cardinality
• Star & Snowflake Schema
• Model Optimization Techniques

DAX (Data Analysis Expressions)

• DAX Basics & Syntax
• Measures, Calculated Columns
• CALCULATE & Advanced Functions
• Time Intelligence (YTD, MTD, QTD)
• Advanced DAX Patterns

Performance Optimization

• DAX Studio & Query Optimization
• Efficient Measure Design
• Storage vs Formula Engine

Power BI Service & Deployment

• Power BI Service Overview
• Publishing Reports
• Workspace Management
• Roles & Deployment Pipelines

Advanced Tools & Integration

• Tabular Editor & DAX Tools
• Python Integration
• AI & Copilot in Power BI