Tuesday, February 15, 2011

Team Geiger

There's a team over at Tableau, a bunch of young viz hooligans messing up the BI program. They got tired of being asked over and over again "how many chart types can Tableau make?"

Thus did they gather around the warm fires of the viz furnace, hammered away they did on the anvils of analysis - and when they were done, Lo, Verily, they put this book together to answer that question. Team Geiger rides again in 2011.

Monday, February 14, 2011

Pies and Bars

Folks, enough with the "pie chart vs. bar chart" thrash. Who cares? They both get the job done. Maybe you like roundy, curvy things; or, maybe you like straighty, lengthy things. It doesn't matter, please just deal with it, already... thanks for reading this rant. :)

Brazil Part II

a partial list of administrative areas from Brazil. I found the shapefile for this from http://www.ibge.gov.br/. I then converted it using shp2text.exe. I then ran it through MS Access which allowed me to add a unique key for Tableau polygon paths. The list of states is partial simply to reduce the row count.

UPDATE: Some folks asked for more details on how this is achieved. I have tried to write it up a bit more. The details are below the visual. I really don't know why this is such a tedious process... but it is. Hopefully my additional notes below will help.

There are a few different ways to get a shapefile into Tableau as "polygon" data.


Joe Mako has a great video located here:



The "shp2text to ms access to tableau" method. Download all three of these files to a directory:


Download shp2text.exe from here:


from a prompt, run this command:

shp2text.exe --spreadsheet 55mu500gc.sph > output.tab

This outputs the contents to a tab delimited file called "output.tab"

Now import this file into MS ACCESS - when importing, tell MS ACCESS to add a "primary key" - you will use this new column in Tableau for the Tableau "path ID". Also, during the import, make sure that you tell MS ACCESS that "the first row contains field names".

Once the data is inside of MS ACCESS, you can now connect to it with Tableau, and follow the general instructions for polygons found here:



If you have ArcGIS, you can follow these instructions instead, as they will save you some time:



Field Names of importance, specific to the Brazilian data set:

X-Coordinate: this is the longitude, set this to "longitude" in Tableau
Y-Coordinate: this is the latitude, set this to "latitude" in Tableau
ID2: this is the MS Access generated primary key, you will want to use this on the "path" shelf in Tableau.

Saturday, February 12, 2011

Brazil Part I

Eu quero viajar para o Brasil algum dia. Agora, eu estou interessado nas diversas regiões geográficas do país. Achei as informações mostradas abaixo de vários sites e fontes de dados. Eu usei o tradutor do Google para este número, e peço desculpa se o Português é terrível.

Thursday, February 3, 2011

Sliding Scales

I whipped up this little guy on the airplane home tonight; and now I need to figure out a way to hook in *any* kind of data via some... kind... of webby trick. I'm mulling this over - yet again! stay tuned.

Tuesday, February 1, 2011

Waterfall and Funnel Charts

See the "notes" tab for background info on these viz: