Data Driven Kickball with Tableau

Friday, July 12, 2013 - 15:15
I've been playing co-ed, intramural kickball for about 3 years in Chicago.  I believe it to be one of the purest forms of competition out there, blending the majesty, bravado, and strategy of sport with a laid-back, social atmosphere.  Early this spring, I began using Tableau to visualize my team's performance at the plate.  For the viz we'll look at today, I wanted to compare my teammates' on base percentage to their number of at-bats to address a few questions:
 
 
  • With enough at-bats, might player performance "regress to the mean" in kickball like it does in baseball?
  • If so, about how many at-bats should a player take before their talent can be fairly assessed?
  • Is it fair to compare the guys to the gals?
  • Which players show up to games most reliably?
  • How awesome do we look while wearing patriotic attire?
 
Before we take a look at the viz, some background information:
 
The Sport:  Kickball rules and strategy are almost identical to those of baseball, the main difference being that a large playground ball is rolled toward the plate for the batter to kick with all of their might.

The Data:  At the end of the each game I take a picture of the scoresheet.  Then, following a trip to the bar for beer, pizza and chicken wings I manually translate the scoresheet into a custom schema (Excel spreadsheet) with one record for every player At-Bat.  This schema holds information about Batters, Gender, Hit Types, number of outs and runners during the current at-bat, and even other information about time of day, location, weather conditions, and the weekly on-field beverage.  It should be mentioned here that designing and populating the schema was a non-trivial effort; this is a very important but often overlooked precursor to effective use of Tableau.
 
The Measures:  # of At-Bats along the x-axis and On-Base Percentage + Slugging Percentage (OPS) on the y-axis.  Since walks and hit-by-pitches are not really a part of kickball, the On-Base Percentage (OBP) is calculated by dividing the number of times a player safely reaches base by the number of At-Bats.  Slugging Percentage (SLG), a measure of how well a batter hits for power, is calculated by dividing the number of earned bases (1 for a single, 2 for a double, etc) by the number of At-Bats.  OPS is the sum of OBP and SLG, and is a reasonable measure of over-all performance at the plate.
 

The Visualization:  I quickly and easily connected Tableau to my custom Excel schema and created a Tableau Data Extract (.tde) file.  Each week as more data goes in, I simply refresh the extract and the charts adjust automatically.  If I rearrange the column order, rename fields, or add new ones Tableau automatically detects these changes and compensates on refresh.  

 

To make the chart, all I had to do was I create calculated fields for OBP, SLG, and OPS.  I then dragged OPS onto rows and At-Bats onto columns, whereupon the 'Show Me' card suggested that I use a scatter plot since I was comparing two measures.  After dropping Batter Name onto Label and Gender onto the Color I created a trend line, set the intercept to zero and elected to show the confidence bands.  Defaulting to a linear trend did not seem to correctly represent the data, so I switched to a logarithmic trend model with a single click.  Satisfied, I added annotations displaying the trend equation and the p-value for each gender.  Finally, for kicks I sized the data points by Runs Scored and added a background image from after our Tournament the other weekend.

Why Tableau Rules:  Within minutes of connecting Tableau to my data I was able to create a very communicative and rich visualization to share with my team.  Perhaps more rigorous statistical analysis is likely required to make real conclusions about the data but for the purposes of delivering a message about kickball performance this chart was more than adequate.

Originally, the goal of Tableau/Kickball marriage was to gather enough data to optimize our batting order from week to week.  We have succeeded there and recently placed 2nd in a city-wide tournament, but along the way, there has been another welcome side-effect.  My teammates now eagerly await the weekly release of Batting-Average Bubbles, RBI Leaf Plots, and Current Week vs All-Time OPS by Batter Double Bar Charts, and they are motivated to play well so as to improve their stats.  Not only has my team adopted a data-driven approach to kickball but we have thoroughly enjoyed the process, and we definitely have Tableau to thank.
 

Contact us today to find out how Inquidia can show you how to collect, integrate and enrich your data. We do data. You can, too.

Would you like to know more?

Sign up for our fascinating (albeit infrequent) emails. Get the latest news, tips, tricks and other cool info from Inquidia.