Fantasy Baseball Analysis Tool (Tableau) by rjweise

analysis
sgp
tableau
Tags: #<Tag:0x00007f70074f6a40> #<Tag:0x00007f70074f6900> #<Tag:0x00007f70074f67c0>

#1

One of the great things about Ottoneu is that there is a whole community of players building custom tools for gameplay and strategy. This is the place to grab out the latest tools and updates, so check back often.

The Ottoneu Surplus Calculator
Ottoneu Public Folder
Calculating Custom Values for Ottoneu (Smart Fantasy Baseball)
Auction Values for Ottoneu Leagues (Chad Young)


#2

A Shortcut to Projecting Hitters in Ottoneu Points

There’s also a shortcut for projecting Pitchers in Ottoneu:


#3

Super Helpful Fantasy Baseball Links & Resources

For daily lineup setting:
https://www.fantasybaseballalerts.com/about
http://www.baseballpress.com

Stats:
http://www.fangraphs.com


News & Analysis:
http://www.mlbtraderumors.com


http://www.baseballprospectus.com

(More to come. If you have suggestions let us know)


#6

FANTASY BASEBALL ANALYSIS TOOL in Tableau Public

For those interested in and or working with Standing Gain Points (SGP: I built a dashboard in Tableau to do analysis of player progress over the season, based on actual stats at roughly month intervals, as well as Steamer Updated projections at those intervals. Last data update was August 22.

Any feedback would be appreciated. Have a look here: https://public.tableau.com/views/SGPCalculatorVersion9July142016/TAB1_SetUpRanking?:embed=y&:display_count=yes

I allows you to set all your personal league averages:

Look at the components of the SGP scores:

See how the best players per position have developed for every data snapshot:

Select up to 10 players from drop downs and compare their development. Ideal for comparing players for trades!

The current version runs best on desktop, but a version for iPhone 6S can be found here: https://public.tableau.com/profile/rj7974#!/vizhome/FANTASYBASEBALLANALYSISTOOLforiPhone_0/0_Main.
Please read the notes and metadata on Tab 4 to better understand the underlying data and calculations.


#8

This is really, really cool @rjweise. A job well done. I will make a note to retweet this and “promote” it again in January/February when I think the most number of people are looking for resources heading into the new season. This is excellent - thanks for sharing with the community. This is exactly what we hope to collect here in “Tools” over time.


#9

Hi everyone, please note I updated the above described tool with actual data as well as Steamer Updated projections from Fangraphs today (September 11, 2016).

Want to make some last minute changes to get a more value out of your closers? Go to the third tab and pick the players you want to compare:


#10

Do you primarily use Steamer ROS projections here @rjweise or do you also incorporate FanGraphs Depth Charts projections, for example?


#11

Hi @LuckyStrikes,
I actually use the Steamer(updated) which to my knowledge gives a full season projection based on the ongoing season actual results. The Steamer ROS gives projected data only for the remaining games, which would look ok if shown as a ratio when comparing to other ROS projections (taken at other time stamps and as such with more games) but not so much when comparing 1-1.

When I update the report I download the Batter - actual, Batter - Steamer Updated, Pitcher - actual, and Pitcher - Steamer Updated, run a couple of SQL statements in PostgreSQL to add the relevant columns to the main table, and then replace the data source in the Tableau report with the updated version. I am looking into adding the new data in Tableau itself but will likely stick with the existing process for the remainder of the 2016 season.

I do not use the Fangraphs Depth Charts at this point. Did you have any concerns about the data?

Thanks,
RJ


#12

Thanks. No concerns at all about the data. I have an idea that I will revisit in the off season with you, however. Again, thanks for putting this tool together. Terrific work.


#13

I just updated the dashboard (This dashboard calculates Standing Gain Points (SGP) based on variables entered by the user and MLB pitcher and batter statistics from the Fangraphs website) to include the data for the whole season.
Main dashboard
Dashboard optimized for iPhone 6S

You put input for this:

To get this:


And this:

and lots more!


#14

I think this is going to be a big, big hit later this off season (around January) when owners are looking for any edge they can to prep for their drafts.