It is that time of year again, even if you don’t participate in fantasy football you may have a co-worker or significant other who does. If you are at all familiar with the “sport” you will see that there is a lot of passion and skill involved. One of the most important parts of fantasy football is the draft at the start of the season. I thought it may be helpful to create a Power BI dashboard that could help some folks navigate their draft with ease.
The main reason to build out a dashboard for your Fantasy football draft is that when you calculate the scores you can factor in the scoring differences in your own league. For instance, some leagues play one point per reception, some play half a point, and some play no points at all for receptions. This difference in scoring rules can be the difference in selecting the correct running back or wide receiver at the right time.
Since I planned on making this as a Power BI blog, I attempted to make the entire dashboard exclusively in Power BI. Although I did use excel to download the data, I did only use Power BI which lead to a handful of issues (see end of post to copy and customize).
- "Select All" just above "All Postions" draft board to reset the draft boards
- Type names in the top right field under "Find Name to Filter Drafted List"
- Selected darkened names to remove players from the draft boards.
Power BI is a read only tool not meant for inputting data, which meant the dashboardwas hard to customize for other users. At the end I can show how you can easily copy this dashboard and make adjustments, though some basic Power BI knowledge may be necessary. I also attempted to use Microsoft’s sister product, “Power Apps” which is currently in Beta without much luck outside of their pre-built examples.
In exchange for inputting data you are able to use filters to show only the data you want to see. I contemplated making a Cartesian join of all the possible scoring methods but this was not easily done in Power BI and would have forced me to use SQL server management studio.
One of the more frustrating issues I ran into with Power BI for this example dashboard was the inability to filter filters, meaning to only show items in a filter that are relevant. For instance, filter "Player Name" by "Position" within a filter. Also reverse filtering, or the ability to show everything minus what I have selected in the filter, would be useful to remove drafted players from the list of possible players to draft.
Site Projections CBS Sports 8/12
Site Projections ESPN 8/14 (No Kicker Data)
Site Projections numberFire 8/12
Sean Koerner STATS 8/12
Site Projections FFToday 8/11
Site Projections FantasyData 8/13
My League Rules:
- Passing Yards: 1 point per 25 yards
- Passing Touchdowns: 4 points
- Interceptions Thrown: -2 points
- Rushing Yards: 1 point per 10 yards
- Rushing Touchdowns: 6 points
- 50+ Rushing Yard TD Bonus: 5 points
- Receptions: 0.5 points
- Receiving Yards: 1 point per 10 yards
- Receiving Touchdowns: 6 points
- 50+ Receiving Yard TD Bonus: 5 points
- Kickoff and Punt Return Touchdowns: 6 points
- Fumble Recovered for TD: 6 points
- Fumbles Lost: -2 points
- 2-Point Conversions: 2 points
- PAT Made: 1 point
- FG Made 0-19: 3 points
- FG Made 20-29: 3 points
- FG Made 30-39: 3 points
- FG Made 40-49: 4 points
- FG Made 50+: 5 points
- Use Fractional Pts Yes
- Use Negative Pts Yes
Copy & Customize
All the points that can be changed can be found in the fields generally prefixed with the words "Points Per." There are a few exceptions to this where the naming was different due to the fact that rules are set up to be easy to read instead of fractional points.
Examples of Non-"Points Per" that can be changed:
- Passing Yards Per Point (above in green)
- Receiving Yards Per Point
- Rushing Yards Per Point