skip to Main Content

Under time pressure today…

So I’ll just leave these here.  Yes, these images are all Power BI.  They are all clickable links to interactive pages.

Power BI Interactive Demo Using NFL Data: Passing Chart

Power BI Interactive Demo Using NFL Data: Sortable Stats

Power BI Interactive Demo Using NFL Data: 2019 v 2018 Comparison

Rather than my usual wall of text…

How about we just open this up to Q&A today?  Leave questions as comments and I will do my best to answer them all in a timely manner Smile

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 22 Comments
    1. In the 24 years I’ve been addicted, I have won zero money playing fantasy football. The handful of times I played for money, I didn’t do well.

      But I have won something far, far more valuable… the P3 Heisman.

    1. We’ve only got one data source at the moment, and that’s for QB. We might be calling for volunteers to help with the effort at some point though… 🙂

    1. Yeah, I have an upcoming article idea along the lines of “let’s stop talking about what we DO for a living, and instead talk about what we MAKE.”

      This NFL thing a poster child for that school of thought.

  1. Rob, if you start doing additional work for WR/RB/TE/DEF, I’d be willing to take a stab at volunteering. I’m somewhere in the amateur/intermediate range of Power BI knowledge, and feel like this would be a great challenge to take my skills to the next level…while also perhaps helping me dominate my league. I mean, duh.

  2. All of this serves as a tremendous inspiration to me and where I want to take CFL data visualization. (I’d be remiss in saying it’s not slightly intimidating, too!) Keep up the great work!!

  3. Rob: This is a really cool solution. As a training exercise, how do we look under the hood so see the table structure and the code or is that a state secret?

    1. Well the PBIX file itself IS a state secret, but one of the reasons we’re doing this is to give us things to blog about.

      So for instance, the new “Matchup Evaluator” that went live today… as simple as it looks there were a couple of intermediate-level wrinkles in making it work.

      Also, the passing chart itself I blogged two years ago: https://powerpivotpro.com/2017/11/jittered-scatter-charts-power-bi-via-dax-power-query/

      (Of course since then we’ve upgraded the graphics and turned the field horizontal).

  4. Really well built report, major props to you.
    I love the use of bar charts in a table visual as displayed in the second and third sheet.

    How would you have dealt with value ranges that are less tightly bound between a fixed 0 and 100% or x and x+y yards? For instance, fat tailed data points between 1$ and $5,000,000?

    1. Well I *could* set the data bar threshold to be fixed values to deal with outliers, rather than “max and min values” that are the default.

      Or I could do some fanciness in my measure and turn each measure into, say, a percentile.

      A few different ways to attack it, but they all share the same property: the outliers will look very similar to the “normal” max/min values.

  5. This is an outstanding dashboard. Visually appealing and easy to navigate. I’m probably just missing it, but is there a way to clear all filters at once?

    1. Thank you! For the moment… it’s refresh your browser.

      But you drive a hard bargain. OK, we’ll look into adding Ye Olde Clear Filters Button.

  6. This is great. I particularly love the field visualisation, it really allows you to view

    The two things I’d love to see come from two different NFL-related passions; as a Madden player, it’d be great to try and categorise the defensive plays further than simple blitz/no blitz (is that simply 5 man rush+ is a blitz?) to include man/zone/hybrids – I’m assuming that could well be a limitation of the data source, though. And as a fantasy player, it’d be cool to see how this looks as all QBs vs teams, to try and identify which kinds of QBs can be successful week to week.

    1. Glad u like it! You’re correct – we don’t have the data on man/zone/hybrid, but we DO have number of blitzers, and we ARE calling it a blitz on 5+

      We simplified it because we figured no one would care at that level of detail. We were wrong 🙂

  7. That was quick. Thanks for filter annihilator. I will definitely be using this as my example of what Power BI can do for the uninitiated.

  8. AWESOME JOB!! In showing this to a few coworkers who love football but not power bi, I literally saw the moment each one of them caught what i have been telling them for a year. Very inspiring! Thanks! Now i just maybe able to convince them to go to your Pittsburgh classes!

Leave a Comment or Question