Wednesday, June 12, 2013

Chess Data in Tableau

Tableau has a public visual on The Best Chess Openings - a great viz by Ben Jones.

This made me curious as to what it might take to generate chess data for plotting in Tableau. It's non-trivial. I am still working on that script. In the meantime, here's a short game from the 1600's. Enjoy!

And here is Joe Mako's improved version, from his comment below:

Thursday, June 6, 2013

Filtering Measure Names via URL

I love learning something new. We stumbled across the fact that you can filter the special "measure names" dimension via URL. I am sure this is not supported by Tableau, but it appears to work great. A few things to worry about:

  1. It starts with &[:Measure%20Names] - take note of the colon in there!
  2. You need the internal name of the data source, not the display name - see example below

Here is an example URL:[:Measure%20Names]=[excel.41431.369623564817].[sum:Cost:qk]

"excel.41431.369623564817" is the name of my datasource. "Cost" is one of the measures. Enjoy!

Monday, June 3, 2013

Tableau and Multiple Trend Models

Following on some previous work where we calculated the basic linear regression model in Tableau manually using calculations and Table Calculations, we can extend this a bit to allow multiple regression models. In the example below, we start with the manual calculations for various average metrics from the IPEDS higher education data set, as compared to a primary metric “Total Gross Revenue”. From here we can enable color. And from there we can have Tableau automatically calculate a new regression model based upon the color. This means we end up with one primary linear regression model, and two sub-models for elements above and below the primary model. Hope you find this useful in some manner…