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

Kristi Cantor

(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.

Read more on our blog

Get in touch with a P3 team member

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

Stay in the know.

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

Related Content

How Do I Create a KPI Dashboard in Power BI?

In this post, we’ll guide you through how to set up a

Read the Blog

How To Utilize Power BI For Advanced QuickBooks Data Analytics

Power BI integrated with QuickBooks… It’s like having a crystal ball for

Read the Blog

Power BI Import vs. DirectQuery: Everything You Need to Know

A BI consultant knows the deal; bring them in and they’ll help

Read the Blog

Top Business Intelligence Tools for 2025: Which One is Right For Your Company?

The top five analytics tools for 2025? Tableau, Power BI, SAS, KNIME,

Read the Blog