Relationships, Pivots, and DAX: The Payoff of Power BI Data Modeling, Part Two

Kristi Cantor

Kristi Cantor

Kristi Cantor is a business intelligence, analytics, and AI practitioner with hands-on experience in Power BI, business intelligence strategy, data analytics, and practical AI adoption. At P3 Adaptive, she works extensively with modern AI tools and emerging business applications, helping explore how technologies like Microsoft Copilot, generative AI, and analytics automation reshape decision-making. As Digital Content Manager, she combines real-world technical experience with strategic communication to create authoritative content on Power BI, Microsoft Fabric, AI strategy, business intelligence, and modern data platforms.

(Continuing the series on the Great Football Project…)

OK, remember in the previous step, we saw how a relationship between Plays and CleanPlayers suddenly let me use a single PivotTable to slice Plays data by ANY column in CleanPlayers (and there was much rejoicing).  But wait, there’s more!

And this time, I’m gonna try my hand at a video post.  Here goes…

Would love feedback on this method vs. text-and-images.  Strong preference for one or the other?  Hybrid?

Is the video resolution sufficient for everyone?  Windows Movie Maker was giving me any size video I wanted, as long as it was 30 MB 😛  Might need another tool 🙂

Update:  OMG that resolution is terribad.  Gonna try again in the morning with a different toolset, it was better on my desktop even at 30 MB.

So I’m taking the vid down for now.

Kristi Cantor

Kristi Cantor is a business intelligence, analytics, and AI practitioner with hands-on experience in Power BI, business intelligence strategy, data analytics, and practical AI adoption. At P3 Adaptive, she works extensively with modern AI tools and emerging business applications, helping explore how technologies like Microsoft Copilot, generative AI, and analytics automation reshape decision-making. As Digital Content Manager, she combines real-world technical experience with strategic communication to create authoritative content on Power BI, Microsoft Fabric, AI strategy, business intelligence, and modern data platforms.

Read more on our blog

Get in touch with a P3 team member

  • This field is for validation purposes and should be left unchanged.
  • This field is hidden when viewing the form
  • This field is hidden when viewing the form

Stay in the know.

This field is for validation purposes and should be left unchanged.

Related Content

What Are The Best AI Features To Use In Power BI

Power BI’s AI capabilities can go underused when teams don’t know which

Read the Blog

Power BI Development & Custom Dashboard Services

Off-the-shelf dashboards often fall short of what a business actually needs to

Read the Blog

When Is It Time To Outsource Power BI Dashboard Building vs. Doing It Yourself?

Deciding whether to build your own Power BI dashboards or bring in

Read the Blog

What Should I Include In A BI Dashboard?

Building a BI dashboard without a clear plan often leads to cluttered

Read the Blog