Power BI Pro Skills: Advanced Analytics, Optimization & Governance
Cohort-based Course
Master advanced modeling, performance, governance, and Fabric in 10 live sessions—get hands-on practice and strengthen PL-300/DP-600 prep.
Power BI Pro Skills: Advanced Analytics, Optimization & Governance
Cohort-based Course
Master advanced modeling, performance, governance, and Fabric in 10 live sessions—get hands-on practice and strengthen PL-300/DP-600 prep.
Course overview
Describe the transformation students will have in your course
Arrive with basics and inconsistent results; leave as the person who can model messy data into a clean star schema, author reliable measures, and make slow, error-prone reports fast, accurate, and governed. Across 10 live, hands-on sessions you’ll practice real enterprise workflows—Power Query on messy sources, storage-mode/aggregation decisions, deployment pipelines, dynamic RLS, monitoring, and Fabric integration—using reusable checklists and troubleshooting drills. You’ll finish with a portfolio-ready capstone scored on model quality, calculation logic, UX/storytelling, and performance—plus the confidence and patterns to lead production rollouts and strengthen PL-300/DP-600 readiness.
Who is this course for
01
Data & BI analysts leveling to enterprise-grade modeling & performance
02
Team leads/managers who need governance, RLS, and deployment confidence
03
Excel power users moving to Power BI/Fabric with hands-on practice
Prerequisites
Skill baseline
Can build basic reports in Power BI Desktop (import data, simple visuals, a few basic measures). Comfortable with Excel tabl
Software
Windows 10/11 laptop with the latest Power BI Desktop; permission to install/update. Chrome/Edge.
Data & security
We provide all lab files; no corporate data needed. If your org blocks installs, use a personal device.
What you’ll get out of this course
Design star-schema models for messy data; validate relationships and granularity.
Give students an idea of how they can expect to grow throughout your course. Include specificity and precise results so students can benchmark exactly what they’ll learn.
Write/debug advanced DAX: context, CALCULATE, iterators, time intelligence.
Give students an idea of how they can expect to grow throughout your course. Include specificity and precise results so students can benchmark exactly what they’ll learn.
Tune performance: storage modes, aggregations, model size, query reduction, measurement.
Give students an idea of how they can expect to grow throughout your course. Include specificity and precise results so students can benchmark exactly what they’ll learn.
Implement governance: dynamic RLS, permissions, sensitivity labels, refresh/gateway policies.
Give students an idea of how they can expect to grow throughout your course. Include specificity and precise results so students can benchmark exactly what they’ll learn.
Ship a capstone: accessible, stakeholder-ready report demonstrating model, DAX, UX, and performance.
What’s included
Live sessions
Learn directly from Rosario Feghali in a real-time, interactive format.
Recordings
Go back to course content and recordings whenever you need to during the duration of the course.
Community of peers
Stay accountable and share insights with like-minded professionals.
Certificate of completion
Share your new skills with your employer or on LinkedIn.
Maven Guarantee
This course is backed by the Maven Guarantee. Students are eligible for a full refund up until the halfway point of the course.
Course syllabus
Week 1
Oct
15
Session 1 Modeling that Scales
Week 2
Oct
20
Session 2 DAX Mental Models I
Oct
22
Session 3 Time Intelligence
Week 3
Oct
27
Session 4 DAX Mental Models II
Oct
29
Session 5 Performance & Storage Modes
Week 4
Nov
3
Session 6 Service Ops & Pipelines
Nov
5
Session 7 Security & Governance
Week 5
Nov
10
Session 8 Power Query in the Wild
Post-course
Nov
12
Session 9 Fabric/OneLake & Dataflows
Nov
17
Session 10 Capstone Demos
What people are saying
Oksana
Cindy
Meet your instructor
Rosario Feghali
Rosario Feghali
Rosario Feghali, PhD (Telecom) and MBA (Finance & IS), is an IM/IT management consultant and instructor with 20+ years of experience delivering enterprise analytics, BI, and security initiatives. He has taught extensively across Canada and the U.S.—including Microsoft Power BI (DAT 350) and BI/fabric-related courses at the University of Calgary—along with programs at Northeastern University, Conestoga College, and Lambton College. A certified Microsoft Certified Trainer (MCT), Project Management Professional (PMP), Certified Business Intelligence Professional (CBIP), and DAMA Certified Data Management Professional (CDMP, Master), he also holds Microsoft’s Power BI Data Analyst certification. His academic work appears in IEEE publications.
Be the first to know about upcoming cohorts
Power BI Pro Skills: Advanced Analytics, Optimization & Governance
Course schedule
4-6 hours per week
Tuesdays & Thursdays
1:00pm - 2:00pm EST
If your events are recurring and at the same time, it might be easiest to use a single line item to communicate your course schedule to students
May 7, 2022
Feel free to type out dates as your title as a way to communicate information about specific live sessions or other events.
Weekly projects
2 hours per week
Schedule items can also be used to convey commitments outside of specific time slots (like weekly projects or daily office hours).
Learning is better with cohorts
Active hands-on learning
This course builds on live workshops and hands-on projects
Interactive and project-based
You’ll be interacting with other learners through breakout rooms and project teams
Learn with a cohort of peers
Join a community of like-minded people who want to learn and grow alongside you
Frequently Asked Questions
Be the first to know about upcoming cohorts