Skip to main content
Ace Skills Consulting
Microsoft logoIntermediatePopular

PL-300: Power BI Data Analyst

Turn raw business data into clear, trusted Power BI reports and prepare for the PL-300 Power BI Data Analyst exam.

  • 24 hours of live, hands-on sessions
  • One business dataset taken from raw files to published report
  • Power Query, star schema modelling and DAX in depth
  • Report design, security and sharing in the Power BI service
  • Mapped to the four PL-300 skill areas
Aligned to Microsoft exam PL-300
Duration
3 Days | 24 Hrs
Next batch
Batches on request
Delivery
Live Online · Onsite · Corporate
Level
Intermediate
Exam
PL-300
Language
English

Why learn PL-300 with Ace Skills

  • Models that give one answer

    Star schema design and clean measures mean every page and every user sees the same, correct numbers.

  • DAX that makes sense

    Filter context and evaluation are explained visually before you write measures, so you understand why a formula works.

  • Built on realistic data

    You work with messy sales and finance files similar to those found in Indian and Gulf businesses, not perfect samples.

  • Exam and job ready

    The course follows the PL-300 outline while producing a portfolio-quality report you can show to employers.

Course overview

Power BI is easy to start and surprisingly easy to get wrong. Reports become slow, numbers disagree between pages and measures break when someone adds a filter. Most of these problems come from weak data preparation and modelling, not from visuals. This three-day course teaches the habits that prevent them, using one realistic business dataset from start to finish.

Day one covers getting and preparing data with Power Query: connecting to files, databases and online sources, profiling and cleaning data, and shaping it into well-structured tables. Day two is dedicated to modelling — star schema design, relationships, DAX measures, time intelligence and performance — because a good model makes every later report simpler.

Day three focuses on visualising, analysing and sharing: report layout and accessibility, interactions, drill-through and bookmarks, AI visuals, then publishing to the Power BI service, building apps, configuring refresh and applying row-level security. The day ends with exam preparation and practice questions.

You finish with a complete, published report and model that you built yourself, plus a checklist for reviewing reports at work.

The course is aligned to the PL-300 exam. Power BI updates monthly and Microsoft revises the exam outline periodically, so check the current skills measured on Microsoft Learn before booking.

Key features

  • One business scenario from raw data to published app
  • Power Query data cleaning and profiling labs
  • Star schema modelling and relationship design
  • DAX measures, variables and time intelligence
  • Report design with accessibility in mind
  • Row-level security, refresh and sharing in the service
  • 30 days of post-training doubt support

Who should attend

  • Business and data analysts
  • Excel power users moving to Power BI
  • Finance, sales and operations reporting teams
  • MIS executives and reporting managers
  • Developers building dashboards for business users

Prerequisites

  • Comfortable working with Excel, including formulas and pivot tables
  • Basic understanding of tables and relationships
  • A Windows laptop with Power BI Desktop installed

Curriculum

3 Days · 24 Hours · 10 Modules · 8 Labs

  1. Connecting to data

    • Files, folders, databases and web sources
    • Import vs DirectQuery
    • Parameters and data source settings
    • Dataflows and shared semantic models
    • Lab: Connect to sales files and a SQL database · 40 min

    Profiling and cleaning

    • Column quality, distribution and profile
    • Fixing data types and errors
    • Replacing values and handling nulls
    • Splitting, merging and extracting columns
    • Lab: Profile and clean a messy sales dataset · 50 min

    Shaping data

    • Merge and append queries
    • Pivot and unpivot
    • Creating fact and dimension tables
    • Query folding and performance
    • Lab: Shape raw data into fact and dimension tables · 50 min

  2. Model design

    • Star schema principles
    • Relationships, cardinality and filter direction
    • Date tables
    • Role-playing dimensions
    • Lab: Build a star schema with a date table · 45 min

    DAX fundamentals

    • Calculated columns vs measures
    • Row and filter context
    • CALCULATE and filter modifiers
    • Variables and iterators
    • Lab: Write core sales and margin measures · 55 min

    Advanced DAX and performance

    • Time intelligence
    • Calculation groups overview
    • Performance analyser
    • Reducing model size
    • Lab: Add year-to-date and prior-year comparisons · 40 min

  3. Report design

    • Choosing the right visual
    • Layout, themes and accessibility
    • Interactions, drill-through and tooltips
    • Bookmarks and buttons
    • Lab: Design an executive sales report with drill-through · 55 min

    Analysis features

    • Key influencers and decomposition tree
    • Anomaly detection and forecasting
    • Q&A and Copilot overview

    Managing and securing in the service

    • Workspaces and roles
    • Apps and sharing
    • Scheduled refresh and gateways
    • Row-level security
    • Sensitivity labels
    • Lab: Publish, apply row-level security and build an app · 45 min

    Exam readiness

    • Exam structure and case studies
    • Practice questions with review
Download full syllabus (PDF)

Skills you will gain

  • Power BI Desktop
  • Power Query
  • Data cleaning
  • Star schema
  • Data modelling
  • DAX
  • Time intelligence
  • Report design
  • Row-level security
  • Power BI service
  • Data refresh

Tools & technologies

  • Power BI Desktop
  • Power BI service
  • Power Query
  • Microsoft Excel
  • On-premises data gateway
  • DAX Studio

Certification exam

Exam details
Exam nameMicrosoft Certified: Power BI Data Analyst Associate
Exam codePL-300
Duration100 minutes
Passing score700 / 1000 (scaled)
Voucher includedNo — book directly with the vendor
Question formatMultiple choice, Multiple response, Drag and drop, Case study
DeliveryOnline proctored or Test centre
Validity & renewal1 year (free online renewal assessment)

Skill areas measured

  1. Prepare the data
  2. Model the data
  3. Visualize and analyze the data
  4. Manage and secure Power BI

Exam details are pending verification. Vendors change exams; confirm on the official vendor page before booking. Official exam page (opens in a new tab)

Schedule & Pricing

Live Online

Individual

Price on request

  • 24 hours of live, trainer-led sessions
  • 8 hands-on labs
  • Ace Skills course completion certificate

Onsite

At your office or our centre

Pricing depends on location, group size and dates.

  • Delivered at your premises or an Ace centre
  • Same curriculum and labs as live online
  • Dates planned around your team

Corporate / Team

Private batch for your organisation

A private batch with content adapted to your environment and goals.

  • Customised curriculum
  • Private batch, online or onsite
  • Progress and assessment reports
  • GST invoice and PO-based billing

No public batches scheduled — Talk to an Advisor for a private batch.

Projects & labs you will build

  • Day 1 · 50 min

    Shape raw data into fact and dimension tables

  • Day 3 · 55 min

    Design an executive sales report with drill-through

Your certificate

Certificate of Completion — Ace Skills Consulting

Awarded on completing the course. It records the course title and training hours, and you can share it on your LinkedIn profile.

The Microsoft certification itself is awarded by Microsoft when you pass exam PL-300.

Frequently asked questions

Do I need programming experience?

No. Strong Excel skills are enough. DAX is taught from the basics during the course.

Can I use a Mac?

Power BI Desktop runs only on Windows. Mac users can join using a Windows virtual machine or a cloud desktop.

Will I need a Power BI licence?

Power BI Desktop is free. For the service labs, details of the lab tenant are shared before the course.

What happens if Microsoft updates the PL-300 exam?

We map the curriculum to the current published skills outline and revise it when Microsoft changes the exam. Always check the latest outline on Microsoft Learn before booking.

Do you run weekend batches?

Yes. Weekend batches cover the same 24 hours across consecutive Saturdays and Sundays, with timings in IST that also suit learners in the Gulf.

Can you run a private batch for our team?

Yes. We run private online or onsite batches for corporate teams, and we can weight the labs towards your own business reports. Request a corporate quote with your team size and preferred dates.

Related courses

Explore more

All Microsoft Data, 365 & Security courses Microsoft certifications

Microsoft, Azure, Microsoft 365, Power BI and Microsoft Entra are trademarks of the Microsoft group of companies.

Train your team on PL-300

Private batches online or at your office in India and the GCC, with a curriculum adapted to your environment.