My blog has moved to jimdehner.com
Thank you for all the support over the past 2 years - I recently updated my blog to make it easier to read, improve the rendering of images and tie back to video presentations that are associated with the content - Check it out at Jim's new blog -
Zero to Zen covers the 5 foundational concepts I needed to learn on the journey from spreadsheets to Tableau
Like many, I struggled when first introduced to Tableau 5 years ago. I don't come from a data scientist background. - Actually I'm and engineer, very analytic and expert level spread sheet skills but I just didn't get it at first.
Looking back there were 5 concepts that I needed to understand which were not at all like spreadsheets before I was comfortable working in Tableau. Over a 5 week series I shared those lessons learned - Below are brief summaries of each and links to the recordings and the workbook used in each session.
Hope you enjoy
Jim
Session 1 - Data Structure and Connections
Three types of connections, Joins, Unions and Blending and the limitations of each were covered. Also reviewed were several how to use cases include why it is sometimes necessary to use scaffolding to restructure the data set
Session recording can be found at: Session 1 Recording
The session workbook can be downloaded at: Session 1 Workbook
Session 2 - Order of Operation
Misuse of the Order of Operation is the usual cause when users get unexpected results in their analysis. It is the sequence that Tableau goes through to first create the data table for each worksheet ( That's right - each worksheet has its own individual data table that is a subset of the full data set uploaded into Tableau). Once the structure of the data table is established, values are loaded, calculations performed, and the visual presentation created. Frequent areas of error are misapplication of context filter, trying to filter across blended data sources, and attempting to "fix" table calculations for use on other sheets
Session recording can be found at: Session 2 Recording
The session workbook can be downloaded at: Session 2 Workbook
Session 3 - Simple Calculations and Date Functions
This first of 2 sessions on calculations covers the use of the Calculation Wizard, using aggregations to do simple math calculations, If - Then conditional statement and date functions. Dates are a special data type in Tableau which self sequence, sort and allow the use of the 4 types Date Functions - those which return dates, refer to dates, are used in date math, and the 2 special Today() and Now(). Use case show how dates are treated as discrete or continuous or can still be continuous yet presented as discrete
Session recording can be found at: Session 3 Recording
The session workbook can be downloaded at: Session 3 Workbook
Session 4 - LOD Expressions and Table Calculations
My favorite, LOD expressions provide versatility by allowing the user to create layers in the data set and then use the layer like any other measure in calculations, nested in other LOD's or in table calculations. Table calculations are last in the order of operation and are executed on the data table for the specific worksheet making the unique the sheet where they are applied. Use cases reviewed nesting LOD's in table calculations, nesting table calculations, totally Top N and Other and the use of Show Hide filters
Session recording can be found at: Session 4 Recording
The session workbook can be downloaded at: Session 4 Workbook
Session 5 - Filters, Sets and Parameters
Filters, sets and parameters are the user interface to the viz, allowing users to probe and drill into the data and gain meaning and understanding. Filters remove data and change the structure of the data table for the worksheet, sets retain all the data in the data table but categorized it into the In and the Out sets and finally parameters are the other way users can input a single, static value into Tableau. Over the series a number of seemingly fundamental concept were introduced or review yet in combination those basic idea can be used to create any more complex visualization -
Session recording can be found at: Session 5 Recording
The session workbook can be downloaded at: Session 5 Workbook
Feel free to download and use the recordings and workbook or any other material on my blog or Public Profile - that's why it is there
Jim