# Fantasy Baseball Analysis Tool (Tableau) by rjweise

**URL:** https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33
**Category:** Baseball Tools
**Tags:** analysis, sgp, tableau
**Created:** [April 10, 2016, 1:01am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33 "2016-04-10T01:01:29Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [April 10, 2016, 1:01am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/1 "2016-04-10T01:01:29Z")

</div>

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.

> <https://twitter.com/rotographs/status/689861879498444800>

[The Ottoneu Surplus Calculator](http://www.fangraphs.com/fantasy/ottoneu-surplus-calculator/)  
[Ottoneu Public Folder](https://drive.google.com/folderview?id=0B0fEKZ6sGtJkRlFqQUFQTDNwc1k&usp=sharing)  
[Calculating Custom Values for Ottoneu (Smart Fantasy Baseball)](http://www.smartfantasybaseball.com/2015/02/how-to-calculate-rankings-for-a-points-league-part-6-replacement-level-and-position-scarcity/)  
[Auction Values for Ottoneu Leagues (Chad Young)](http://www.fangraphs.com/fantasy/auction-values-for-ottoneu-leagues/)

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [April 16, 2016, 4:15am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/2 "2016-04-16T04:15:20Z")

</div>

**A Shortcut to Projecting Hitters in Ottoneu Points**

> **[A Shortcut to Projecting Hitters in Ottoneu](https://ottoneutraderumors.wordpress.com/2015/12/22/a-shortcut-to-projecting-hitters-in-ottoneu/)**
>
> One of the better features of Ottoneu fantasy baseball is the linear weights-based scoring system for FGPTS and SABR.  These advanced, non-roto scoring options are well tuned to sabermetric-minded …

There’s also a [shortcut](http://www.fangraphs.com/fantasy/a-shortcut-for-projecting-pitchers-ros/) for projecting Pitchers in Ottoneu:

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [April 16, 2016, 5:23am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/3 "2016-04-16T05:23:12Z")

</div>

## Super Helpful Fantasy Baseball Links & Resources

**For daily lineup setting:**  
[https://www.fantasybaseballalerts.com/about](https://www.fantasybaseballalerts.com/about)  
[http://www.baseballpress.com](http://www.baseballpress.com)

> **[MLB Depth Charts](https://www.rosterresource.com/mlb-depth-charts/)**
>
> Updated MLB rosters, depth charts and player information, including current Power Rankings and how acquired by current team.   •Click HERE …

**Stats:**  
[http://www.fangraphs.com](http://www.fangraphs.com)

> **[MLB Stats, Scores, History, & Records | Baseball-Reference.com](https://www.baseball-reference.com/)**
>
> Complete source for baseball history including complete major league player, team, and league stats, awards, records, leaders, rookies and scores.

  

> **[Which stats matter most for daily fantasy?](https://www.si.com/fantasy/2016/03/28/daily-fantasy-baseball-preview-stats)**
>
> The alphabet soup of WAR, xFIP, wOBA and BABIP might be confusing, but some of them are wonderfully predictive and incredibly important for the DFS player, while others can be ignored. We’ll spell out which are...

**News & Analysis:**  
[http://www.mlbtraderumors.com](http://www.mlbtraderumors.com)

> **[Baseball Home - FantasyRundown.com](http://fantasyrundown.com/baseball-home/)**
>
> googletag.cmd.push(function() { googletag.defineSlot('/7103/SMG\_FantasyRundown/728x90\_1a/sports/fantasy/football.general', , 'usmg\_ad\_SMG\_FantasyRundown\_728x90\_

  
[http://www.baseballprospectus.com](http://www.baseballprospectus.com)

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

---

<div class="post-metadata">

### Author: ![rjweise](https://community.ottoneu.com/user_avatar/community.ottoneu.com/rjweise/32/133_2.png) [@rjweise](https://community.ottoneu.com/u/rjweise)
#### Post date: [August 27, 2016, 2:12am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/6 "2016-08-27T02:12:53Z")

</div>

**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](https://public.tableau.com/views/SGPCalculatorVersion9July142016/TAB1_SetUpRanking?:embed=y&:display_count=yes)

I allows you to set all your personal league averages:

 ![](https://community.ottoneu.com/uploads/default/original/1X/e71eca14439de0c845c4dcc49a97a116220c311d.png)

Look at the components of the SGP scores:

 ![](https://community.ottoneu.com/uploads/default/original/1X/7ec27e8387f7457ab057590645fc4868d7126ed3.png)

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

 ![](https://community.ottoneu.com/uploads/default/original/1X/dda9ed52a73077f82e580b4652a718cc3a94cbe0.png)

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

 ![](https://community.ottoneu.com/uploads/default/original/1X/4301623bf81d4b12675eab68937ac4e4717a8124.png)

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

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [August 28, 2016, 12:58pm UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/8 "2016-08-28T12:58:14Z")

</div>

> [@rjweise](#):
>
> 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](https://public.tableau.com/views/SGPCalculatorVersion9July142016/TAB1_SetUpRanking?:embed=y&:display_count=yes)

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.

---

<div class="post-metadata">

### Author: ![rjweise](https://community.ottoneu.com/user_avatar/community.ottoneu.com/rjweise/32/133_2.png) [@rjweise](https://community.ottoneu.com/u/rjweise)
#### Post date: [September 12, 2016, 3:41am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/9 "2016-09-12T03:41:58Z")

</div>

Hi everyone, please note I updated [the above described tool](https://t.co/2rKHDJz0io) 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:

 ![](https://community.ottoneu.com/uploads/default/original/1X/33215be45cbd2ec2337c7c7b7cbfdf71a4280f23.png)

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [September 12, 2016, 10:19am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/10 "2016-09-12T10:19:11Z")

</div>

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

---

<div class="post-metadata">

### Author: ![rjweise](https://community.ottoneu.com/user_avatar/community.ottoneu.com/rjweise/32/133_2.png) [@rjweise](https://community.ottoneu.com/u/rjweise)
#### Post date: [September 12, 2016, 2:20pm UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/11 "2016-09-12T14:20:19Z")

</div>

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

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [September 13, 2016, 2:11am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/12 "2016-09-13T02:11:02Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![rjweise](https://community.ottoneu.com/user_avatar/community.ottoneu.com/rjweise/32/133_2.png) [@rjweise](https://community.ottoneu.com/u/rjweise)
#### Post date: [October 7, 2016, 4:06am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/13 "2016-10-07T04:06:44Z")

</div>

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](https://public.tableau.com/profile/rj7974#!/vizhome/SGPCalculatorVersion9July142016/TAB1_SetUpRanking)  
[Dashboard optimized for iPhone 6S](https://public.tableau.com/profile/rj7974#!/vizhome/FANTASYBASEBALLANALYSISTOOLforiPhone_0/0_Main)

You put input for this:

 ![](https://community.ottoneu.com/uploads/default/original/1X/d08e24caebeea0708f97597a0a616b2400547726.png)

To get this:

 ![](https://community.ottoneu.com/uploads/default/original/1X/a898b9b155b2e90f1225c0c324c8996b697c52bc.png)  
And this:

 ![](https://community.ottoneu.com/uploads/default/original/1X/d4643e3a64b1343e914eed776112ee169add4758.png)

and lots more!

---

<div class="post-metadata">

### Author: ![LuckyStrikes](https://community.ottoneu.com/user_avatar/community.ottoneu.com/luckystrikes/32/341_2.png) [@LuckyStrikes](https://community.ottoneu.com/u/LuckyStrikes)
#### Post date: [October 7, 2016, 10:51am UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/14 "2016-10-07T10:51:26Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![rydermichaelis](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/r/c89c15/32.png) [@rydermichaelis](https://community.ottoneu.com/u/rydermichaelis)
#### Post date: [August 22, 2026, 8:28pm UTC](https://community.ottoneu.com/t/fantasy-baseball-analysis-tool-tableau-by-rjweise/33/15 "2026-08-22T20:28:46Z")

</div>

This is a great collection of tools. I like seeing how much of the Ottoneu community has built around turning the raw league data into something more useful for decision-making.

One thing I’ve found useful when working with baseball analysis is keeping the underlying statistics consistent before using them for higher-level fantasy analysis. Simple metrics such as ERA, WHIP, FIP, OPS, OBP and SLG can be useful checkpoints before moving into projections, rankings or auction values.

I’ve also put together a small set of baseball-stat calculators for quickly checking those basic calculations:

> **[ERA Calculator - Earned Run Average Calculator](https://eracalculators.com/)**
>
> ERA calculator for baseball and softball pitchers. Calculate earned run average instantly for 7-inning, 9-inning, or 6-inning games.

It’s more focused on the underlying baseball statistics than fantasy valuation, but it can be handy when you want to verify a calculation or sanity-check a number before using it in a larger analysis.

The distinction between calculating the raw stat correctly and deciding how much that stat should be worth in a fantasy format is pretty interesting.
