PL-300 · Intermediate
Microsoft Power BI Data Analyst (PL-300)
Live online evening course — 4 cohorts available in 2026. Learn Power BI from a Microsoft Certified Trainer without leaving your day job.
8%
Self-paced completion rate
92%
Gyromitra Live graduation rate
Why Live Instructor-Led?
See how we compare to other PL-300 preparation options.
| Feature | Self-Paced (Udemy) | 3-Day Bootcamp | Gyromitra (8-Week Live)BEST VALUE |
|---|---|---|---|
| Live instructor Q&A | |||
| Evening schedule (keep your job) | |||
| 24 hours of instruction | Varies | 18–21 hrs | ✓ 24 hrs |
| Hands-on labs | Some | ||
| Session recordings | Pre-recorded only | Sometimes | ✓ All sessions |
| Practice exam questions | Sometimes | Sometimes | |
| Student community | Forum only | ✓ Private group | |
| Personalized feedback | Limited | ||
| Price | $15–60 USD | $697–3,895 | $595 CAD (~$435 USD) |
Invest in Your Career
Self-Paced Video Courses
$15 – $60
- Pre-recorded videos
- No instructor access
- No accountability
- ~8% completion rate
- No personalized feedback
Gyromitra Live Training
$595 CAD
- 24 hours live with MCT
- Real-time Q&A every session
- Hands-on labs with feedback
- 92% completion rate
- Practice questions & personalized study plan
- Session recordings
- Student community access
Other Live Bootcamps
$2,000 – $3,900 USD
- 3-5 day intensive
- Large class sizes (50+)
- No evening option
- No ongoing support
Go From Spreadsheet User to Certified Power BI Analyst
BEFORE
- Struggling with scattered data and manual Excel reports
- Unsure how to model data or write DAX formulas
- Intimidated by the PL-300 exam scope and format
- No clear study plan or structured preparation
AFTER
- Confidently building interactive dashboards from multiple data sources
- Writing production-ready DAX and designing clean star schemas
- Exam-ready with practice questions and a personalized study plan
- Connected to a peer community for ongoing support
Course Details
- Format: Live online via Zoom
- Schedule: Wednesdays, 6:00–9:00 PM ET
- Duration: 8 sessions (24 hours)
- Next cohort: Cohort 3: Jun 24 – Aug 12, 2026
- Class size: Limited to 20
What's Included
- 24 hours of live instruction with a Microsoft Certified Trainer
- Hands-on labs with real-world datasets
- Course materials delivered via Moodle LMS — access begins at registration
- Session recordings — review anytime
- Microsoft achievement code
- Certificate of completion
- Practice exam questions aligned to PL-300 format
- Access to private student community (Slack/Discord) for peer support & Q&A
Curriculum (8 modules)
Session 1 · Prepare the data (15–20% of exam)
Preparing Data
Learn how to connect Power BI to the data sources you'll encounter on the job and in the exam — from Excel files and SQL Server to SharePoint, APIs, and cloud services. Understand the architectural decisions that affect report performance.
- Connect to diverse data sources: SQL Server, Excel, CSV, web, SharePoint, and cloud connectors
- Evaluate and select storage modes: Import, DirectQuery, and Dual
- Configure data source credentials and privacy levels
- Identify when query folding occurs and why it matters for refresh speed
- Understand the difference between flat files and relational sources
- Use parameters to make queries dynamic and reusable
Tools: Power BI Desktop, Power Query Editor, M Language basics
Session 2 · Prepare the data (15–20% of exam)
Cleaning & Shaping Data
Raw data is rarely ready to use. In this session you master Power Query — the transformation engine inside Power BI — to clean, reshape, and combine data so your model is accurate and maintainable.
- Merge and append queries to combine data from multiple sources
- Unpivot, pivot, and split columns for proper tabular structure
- Handle nulls, errors, duplicates, and data type mismatches
- Create and manage query parameters for dynamic data sources
- Profile data to catch anomalies before loading into the model
- Apply best practices for query organization and documentation
Tools: Power Query Editor, M Language, Data Profiling tools
Session 3 · Model the data (30–35% of exam)
Data Modeling
Data modeling is the highest-weighted section of the PL-300 exam. This session builds your understanding of the star schema — the gold standard for Power BI models — and the relationship settings that control how filters flow between tables.
- Design and implement star schemas with fact and dimension tables
- Define table relationships: cardinality (1:*, *:*), cross-filter direction
- Build and configure date tables for time intelligence
- Handle role-playing dimensions (e.g., multiple date fields on one fact table)
- Use calculated columns vs. measures — and when to use which
- Apply model-level best practices for scalability and maintenance
Tools: Power BI Desktop Model View, DAX (intro), Date table patterns
Session 4 · Model the data (30–35% of exam)
DAX Deep Dive
DAX (Data Analysis Expressions) is the formula language of Power BI. This session demystifies the concepts that trip up most exam candidates: filter context, row context, and context transition. You'll write real measures and learn to debug them.
- Understand filter context, row context, and context transition
- Write CALCULATE to modify filter context
- Use FILTER, ALL, ALLEXCEPT, and RELATED in complex measures
- Build iterator functions: SUMX, AVERAGEX, MAXX, RANKX
- Create time intelligence measures: YTD, MTD, prior year comparisons, rolling averages
- Debug DAX using the Performance Analyzer and DAX Studio
Tools: DAX Studio, Power BI Performance Analyzer, CALCULATE, FILTER, time intelligence functions
Session 5 · Visualize and analyze the data (25–30% of exam)
Visualizations
Great data tells a story — but only if you choose the right visual. This session covers when to use each chart type, how to format visuals for clarity and accessibility, and the Power BI features that let you deliver insight rather than noise.
- Choose the right visual type for the data story and audience
- Apply conditional formatting, reference lines, and error bars
- Use the Analytics pane (trend lines, forecast, min/max)
- Build custom tooltips and report page tooltips
- Implement drillthrough pages and cross-report drillthrough
- Design accessible reports: alt text, tab order, high-contrast themes
Tools: Power BI Desktop Report View, Format pane, Analytics pane
Session 6 · Visualize and analyze the data (25–30% of exam)
Interactive Reports
Power BI's interactivity features turn static reports into self-service tools. You'll learn bookmarks, buttons, slicers, and navigation patterns that make reports intuitive for any user — including mobile users.
- Design multi-page report layouts with button-based navigation
- Implement slicers, sync slicers, and cross-filtering between visuals
- Use bookmarks, buttons, and the Selection pane for show/hide interactions
- Build mobile-optimized report layouts for Power BI Mobile
- Apply field parameters to let users switch measures and dimensions
- Control visual interactions to prevent unintended cross-filtering
Tools: Bookmarks pane, Selection pane, Mobile layout editor, Field parameters
Session 7 · Deploy and maintain assets (10–15% of exam)
Dashboards & Distribution
Publishing a report is only the beginning. This session covers the Power BI Service: workspaces, apps, scheduled refresh, Row-Level Security, and the governance features that enterprise teams rely on.
- Publish reports to the Power BI Service and manage workspaces
- Create Power BI apps and configure audience-based content distribution
- Pin visuals to dashboards and configure data alerts
- Set up scheduled refresh with and without an on-premises gateway
- Implement Row-Level Security (RLS) — static and dynamic
- Manage workspace roles and permissions for team collaboration
Tools: Power BI Service, Power BI Gateway, RLS in Power BI Desktop, Deployment pipelines (intro)
Session 8 · All exam domains
Exam Prep & Review
The final session is dedicated to getting you across the finish line. We walk through the exam format, tackle practice questions together, review the most commonly missed topics, and build a personalized study plan for your exam date.
- Understand the PL-300 exam format: question types, case studies, and scoring
- Work through exam-style scenario questions with instructor guidance
- Review the most commonly tested and most commonly missed topics
- Identify your personal knowledge gaps and build a targeted study plan
- Learn strategies for approaching case-study questions under time pressure
- Finish with a personalized study plan and booking timeline for your exam
Tools: Practice exam questions, Microsoft Learn, Exam Sandbox (where available)
Who This Course Is For
- Business analysts
- Data professionals
- IT professionals
- Career changers
Prerequisites
- Basic understanding of data and spreadsheets (Excel comfort helps)
Exam Domain Weights
What Microsoft tests on the PL-300 exam:
| Domain | Weight |
|---|---|
| Prepare the data | 15–20% |
| Model the data | 30–35% |
| Visualize and analyze the data | 25–30% |
| Deploy and maintain assets | 10–15% |
Your Instructor
Dr. Rosario Feghali
Microsoft Certified Trainer | PhD | PMP | CISM | CDMP Master | MBA
With 20+ years of teaching and consulting experience, Dr. Feghali has trained professionals at Bank of Canada, CBSA, CN Railway, SAS Institute, and across Canadian and US universities. He brings real-world enterprise BI projects directly into the classroom — you'll learn patterns that work in production, not just for the exam.
What Students Are Saying
"Even though I did not have any experience with Power BI prior to taking the class, I was able to pass the Power BI Data Analyst Associate exam. Thank you so much for your guidance and support. I found your course very beneficial and engaging, and I feel much more confident working with Power BI after taking it."
"As a former developer re-entering analytics, I needed clarity on certifications. This course delivered: practical prep toward the Power BI certification (PL-300) plus a thoughtful roadmap into data governance with CDMP. I left with skills, confidence, and a concrete plan for what to pursue next."
Free Guide
10x Faster Data Transformation with AI
Learn how to use Claude, ChatGPT, or Copilot to write Power Query M code in seconds — with a complete worked example using real government data.
Frequently Asked Questions
Some familiarity with spreadsheets or data helps, but the course is designed to take you from basics through to exam-ready. We cover concepts step by step with hands-on practice. Complete beginners are welcome.
Public Cohorts — Runs every 2 months
Scheduled cohorts with seats available:
| # | Dates | Status |
|---|---|---|
| 1 | Cohort 3: Jun 24 – Aug 12, 2026 | Open |
| 2 | Cohort 4: Aug 26 – Oct 14, 2026 | Open |
Wednesdays, 6:00–9:00 PM ET | 8 sessions (24 hours) | $595 CAD
Private Corporate Training
Need training for your team? We offer private sessions customized to your organization's data, goals, and schedule.
- Tailored curriculum using your real business data
- Flexible scheduling — weekdays, evenings, or compressed delivery
- Virtual or on-site in Canada
- Group pricing available
Register for the Course
Questions before registering?
Contact us