Microsoft Power BI Intermediate (Level 2)
One dashboard, six data sources, and DAX you have to trust.
The first dashboard works. The second one has to combine three systems that name the same customer differently, and the calculation that was right in isolation returns something strange once someone applies a filter.
This workshop is that step. Participants learn to model across sources that disagree, and to write DAX with an understanding of filter context, which is the concept that separates people who trust their numbers from people who hope.
Analytics and reporting leaders use this where Power BI has taken hold and the models are getting real. HR and learning and development leaders use it where someone self-taught the basics and has hit a wall they cannot name. Participants work on their own models.
Content, datasets, and examples are built around your actual work before delivery. Most groups train live online, and on-site in-person delivery is available by request. This workshop is available by request only, with a three participant minimum, and sits alongside our other data analytics and data literacy workshops.
This course includes
- Live, instructor led workshop delivered across four sessions
- Modeling work across multiple sources using your real data
- DAX taught through filter context rather than as recipes
- Performance diagnosis and Power BI service management
- Digital learning materials and take home reference guides
- Certificate of completion for every participant
Description
The first sessions are modeling at difficulty. Participants combine sources that disagree about the same entity, handle the many-to-many relationship properly rather than working around it, build the date table that almost every real model needs, and learn why a star schema is worth the effort even when it feels like extra work.
The middle is DAX and filter context, which is the heart of the workshop. Participants learn why a measure returns different results in different places, how filters actually flow, and how to write calculations that behave the way they intended rather than the way they guessed. Time intelligence gets proper attention, because comparing to last year is what everyone actually wants.
The final sessions cover the service and performance. Participants learn to share and manage content, set up refresh that works reliably, and diagnose why a report has become slow. They leave with their own model improved and a clear view of what to fix next.
What You'll Learn at a Glance
- Model across multiple sources that disagree about the same entity
- Handle many-to-many relationships properly rather than working around them
- Build the date table nearly every real model needs
- Understand filter context and why a measure changes by location
- Write time intelligence calculations that compare periods correctly
- Diagnose why a report has become slow
- Share, manage, and refresh content in the Power BI service
Details
Duration
Prerequisites
Participants should be comfortable connecting to data, building a basic model, and creating reports in Power BI. Those without that foundation should start with Microsoft Power BI Beginners (Level 1).
Your Microsoft Office Training Goals, Customized to You
DWC provides expert Microsoft Office training aligned to your organization’s needs, your funding requirements, and your participants’ skill levels. With customization at every level, from content to scheduling to delivery format, DWC builds Microsoft Office training programs that produce measurable outcomes.
20,000+ Participants Trained | 90% Completion Rate | 1,500+ Organizations Served
Tuition
Microsoft Power BI Intermediate (Level 2) is available by request only, scheduled around your team.
- $649 per participant, with a three participant minimum
- Private training: request a custom quote. One on one sessions and teams below the three participant minimum are priced case by case
- Larger groups: request a custom quote. We price larger cohorts case by case based on group size, schedule, and delivery format
Request a quote and we will build pricing around your team.