Fantasy Baseball Draft Interactive Dashboard by David Cohen

An interactive Tableau dashboard built to support the draft process for a fantasy baseball league my close friends and I have been running for 15 years and give all league participants historical data related to current projections for the latest league year!

Given my friends and I have been playing this game for such a long time and that the platform (ESPN) we use is quite bad at tracking historical data, I thought building a way to compare the projections of specific players that are generated by journalists and baseball teams to the historical data we have available would be an useful way to help all other members of our league be more informed - as our league is fairly competitive and data-driven.

The process of building this tool requires building a collated data set (in Excel, usually) from a variety of publically available data sources (primarily websites that provide projections for the performance of baseball players - such as Baseball Reference and Fangraphs) with our privately maintained records of historical data (for give or take 500 players in Major League Baseball)

After collating all sources, I then build custom formulas to define the relative "tiers" and ordinal ranking of all players (based on weighting both projections and historical performance for each player), and build custom visualizations (via Tableau) to indicate a player's availability for our draft (given our rules allow players to keep a previous season's team members to a degree), injury status and general projection for the season relative to their positional peers as well as the rest of the league.

This tool is also sortable and interactive, so as players are drafted during our draft - they can be excluded from the tool and the vizzes included are updated accordingly. Additionally, a number of filters are included for league members to be able to slice and dice the data as needed.

Lastly, I built a comparison tool in the secondary tab to help players compare the capabilities of specific players in a sort-of apples to apples way (and the tabs connect such that if you select a player in tab 1, it carries over that comparison to tab 2) for simplicity's sake.