Power BI Data Analyst (PL-300)

Transform raw data into compelling business insights with Power BI.

4 DaysIntermediateMicrosoft Certified: Power BI Data Analyst Associate (PL-300)

Course Curriculum

Module 1Getting Data
  • Connecting to SQL, Excel, and web sources
  • Power Query Editor transformations
  • Data profiling and quality checks
  • Parameters and dataflows
Module 2Data Modeling
  • Star schema design principles
  • Relationships and cardinality
  • Calculated columns vs measures
  • Row-level security
Module 3DAX Fundamentals
  • DAX syntax and evaluation context
  • Time intelligence functions
  • CALCULATE, FILTER, and RELATED
  • Advanced aggregation patterns
Module 4Designing Reports
  • Visual types and best practices
  • Slicers, bookmarks, and drill-through
  • Custom tooltips and conditional formatting
  • Accessibility and design standards
Module 5Power BI Service & Deployment
  • Workspaces and apps
  • Scheduled refresh and gateways
  • Row-level security in the Service
  • Sharing, embedding, and licensing

Prerequisites

  • Basic understanding of relational databases
  • Familiarity with Excel or any BI tool
  • No prior Power BI experience required

Who Should Attend

  • Business analysts and report developers
  • Data analysts moving to Power BI
  • Finance and operations professionals
  • Candidates preparing for PL-300 exam

Interested in Power BI Data Analyst (PL-300)?

Our training advisors will help you choose the right batch format, dates, and pricing for your team or individual goals.