Microsoft Power BI Intermediate (Level 2)
Microsoft Power BI Intermediate (Level 2) builds on foundational skills with the tools and techniques that produce robust, scalable analytics. Participants gain hands-on experience writing intermediate DAX, modeling complex relationships across multiple data sources, designing professional reports, and working with the Power BI service and Copilot AI features to collaborate and deliver insights more efficiently.
Hands-On Training Taught by Experts
Live, Online, Instructor-Led
Skills you can use immediately
This course includes
- Live, instructor-led training delivered online or in person
- Hands-on labs aligned to real workplace data and business tasks
- All course materials, templates, and Power BI data files included
- Instruction designed to support job readiness and workplace productivity
- Optional customization for group training, departments, or workforce initiatives
Microsoft Power BI Intermediate (Level 2) is an instructor-led professional development workshop designed for workforce development programs, employer-sponsored training, and group learning environments. The course focuses on intermediate Power BI skills employees need to build complex data models, write more powerful DAX calculations, and design polished multi-page reports using data from multiple sources.
Participants learn through hands-on labs and guided instruction that emphasize analytical depth, model design, and real-world application rather than software theory. This training is ideal for organizations seeking to upskill staff, improve reporting quality, or build on foundational Power BI skills with more powerful modeling and collaboration tools.
What You’ll Learn at a Glance
- Work within the Power BI service to manage workspaces, schedule refreshes, and distribute reports
- Write intermediate DAX functions including CALCULATE, FILTER, time intelligence functions, and iterators
- Build and manage complex data models with multiple related tables and role-playing dimensions
- Design reports using multiple data sources including databases, cloud services, and web-based data
- Create calculated columns, calculated tables, and reusable measure groups
- Apply conditional formatting, bookmarks, and report navigation for polished report design
- Use Copilot in Power BI to generate DAX queries and explore data using natural language prompts
- Set up data alerts, subscriptions, and dashboards for ongoing monitoring
Prerequisites
Completion of Microsoft Power BI Beginners (Level 1) or equivalent experience with Power BI Desktop, basic DAX, Power Query, and report building.
Tuition
Price may vary based on group size.
Completion of Microsoft Power BI Beginners (Level 1) or equivalent experience with Power BI Desktop, basic DAX, Power Query, and report building.
This course includes
- Live, instructor-led training delivered online or in person
- Hands-on labs aligned to real workplace data and business tasks
- All course materials, templates, and Power BI data files included
- Instruction designed to support job readiness and workplace productivity
- Optional customization for group training, departments, or workforce initiatives