Give that Tableau Workbook a Makeover with "Find and Replace Gone Wild!"

/
Give that Tableau Workbook a Makeover with "Find and Replace Gone Wild!"

So here is the use case.  Lets say your corporate font just got changed from Arial to Segoe UI.  Or, you are just plain tired of having to format your Quick Filters, turn on and off your those pesky tooltip buttons, or want all your field labels to always be hot pink with glitter.  I am still waiting for the glitter feature in Tableau by the way.... hint hint.  You could spend a day changing  your workbooks, yawn!  If you are lucky you have a corporate Sugar Daddy who will buy you Power Tools, an amazing product, do that.  But if not, you can get similar results from DIY Find and Replace in your favorite text editor.  I use Notepad ++ on a PC or Sublime Text on a Mac

Read More

Create multiple custom map layers in Mapbox that you can toggle on and off in Tableau

/
Create multiple custom map layers in Mapbox that you can toggle on and off in Tableau

This adds onto the Mapbox customization for Tableau by showing you how to:

  • Import custom shapefiles
  • Edit them in QGIS (optional)
  • Style them in Mapbox
  • Add them to a Tableau .tms so you can toggle them on and off in many combinations to help your visual analysis.
Read More

Fast and Fabulous Custom Maps using Mapbox in Tableau

/
Fast and Fabulous Custom Maps using Mapbox in Tableau

So the last time I wanted a custom map, I ended up building my own WMS and spending months and $’s to get the map I wanted.  If you followed that advice - good for you. You and I can now drink at at Tableau conference and tell the young’ins about how we used to have to walk uphill in the snow, wearing only flip flops and a Magnum BI t-shirt, while being pelted with popsicles to get our maps. Then one day recently, I had a cocktail with Allan Walker (that insane mapping Zen dude) who pointed out that if you just opened up a .tms file in notepad, there just wasn’t all that much to it but a wee bit of xml. 

Read More

4th Grade Viz-tastic-ness

/
4th Grade Viz-tastic-ness

Last Friday, I had the pleasure of being a guest speaker in my 4th grader, Max's computer class, on the topic of Data Visualization.  They had just started to learn about creating spreadsheets in Excel, and so I used that as the basis for how to communicate effectively with data using Tableau. We started with a table of data in Excel, where we captured very basic data about Gender, Age, Birthday, Favorite Sports, Movies, Games, Foods, etc. and used this to discuss the following topics and build a dashboard all in 45 minutes!:

Read More

#DATA14 Presentation: How to Create a Viz that Stops Traffic

/
#DATA14 Presentation: How to Create a Viz that Stops Traffic

I had a wonderful time presenting at the 2014 Tableau Conference, along with Daniel Montgomery and Paul Banoub on "How to Create a Viz that stops Traffic.  The session was hosted by the amazing talented Jewel Loree.  Below is the presenation

Read More

Drought

/
Drought

This is a piece that was created for the Tableau  #data14 #vizasart contest  While traveling through California on Holiday last week, I was struck by the different levels of attention paid to the drought.   From the assumed political correctness of Northern California, to the angry “Congress created dust bowl” signs along the I5, to the humorous public service announcements in Southern California about “Breaking-up with your green lawn”, the drought was present all along the state.   I wanted to create an artistic piece based on precipitation data to convey the lack of rain and its effects.

Read More

30 Minutes… Bay Area Bike Share

/
30 Minutes… Bay Area Bike Share

This is an entry for the Bay Area Bike Share data challenge sponsored by Stamen Design.  Allan Walker and I decided to examine the announcement of the expansion of SF bike station locations to new neighborhoods and see how that would affect the ability to use the service as a viable commuting option for different locations in the city.  Please visit the mapping methodology tab to understand the geo-spacial calculations Allan used to create the routes and service area visualizations data and information used to create the viz.

Read More

This Story Starts with an Irresistible Map

/
This Story Starts with an Irresistible Map

I wanted a Stamen style map in my Viz!  No problem actually, as I could easily design it and export it as an image.  Then I could just use it as background image in Tableau after assigning some Lat, Long coordinates to it.  Viz done… booyah!

Wait, I can't drill into the map and zoom and stuff?

Captains Log… Feb. 6th.  Love the look of my knock off from China town.  I think Shrimp Boy may have had a hand in it even, but I want a real pink pony...

Read More

Design Your Data Viz Like a Product Designer

/
Design Your Data Viz Like a Product Designer

After presenting on “Using Design and Emotion to create a Viz with Impact” at TCC13, one of the most common feedback comments was, “I never realized how many iterations and how much time you put into your viz’s.”  Having studied Industrial Design, it seemed only natural to follow a “Product Design” process when creating data visualizations.  Isn’t a data viz a product that you hope people will “consume” because they find it of use and of value? People are bombarded all day long with emails, tweets, Facebook posts, etc.  Why should they spend the time to look at your data visualization?   Just like a product, your viz should be designed with a specific goal and context in mind, and should capture the consumer’s attention immediately and provide a value to them.

Read More

SNAP back to reality

/
SNAP back to reality

This viz was inspired by Ron Shaich, founder and CEO of Panera Bread, who participated in a seven-day SNAP Challenge - living on a food and beverage budget of $4.50 a day, the average benefits available to a beneficiary of the Supplemental Nutrition Assistance Program (food stamps). "I had no clue. My SNAP Challenge last week taught me that merely observing someone else's plight does not hold a candle to consciously altering your habits to better understand what it might be like to live someone else's life." The CNN article on his experience can be seen here . This viz invites to you take the "SNAP challenge" as well as provide some information on the SNAP program from 1986 - 2012.

Read More

Using Design and Emotion to Create a Data Visualization with Impact

/
Using Design and Emotion to Create a Data Visualization with Impact

This is the slideshow from my session at the Tableau 2013 Customer Conference.  This session will walk through the process of creating a data visualization based on product design principles and ideas, focusing on overall product goals and user context. A step by step walk through of the design process for two data products, "Twitter TV Set" and "Firework Injuries" will be used as examples to highlight the impact that design and emotion can add to a visualization.  

Read More

Firework Injuries

/
Firework Injuries

Using data from the Consumer Product Safety Commission, this visualization highlights all the injuries due to fireworks that happen, highlighting the 4th of July holiday period.  Click on any category to filter on it, and explore what injuries occur across dates, genders, and age groups.  Males seem to be more likely to get injured overall, and their injuries are to their hands and fingers.  Females, are more prone to head and neck injuries.  Sadly, wee ones are almost 10% of injuries, mostly over the 4th of July week.  Hover over any category and you can drill through to the gory details of the injuries (even the naughty bits). Please be safe this 4th of July and enjoy fireworks responsibly.

Read More

Tableau 2012 Iron Viz Championship - Tornado Alley

/
Tableau 2012 Iron Viz Championship - Tornado Alley

This viz was created for the Tableau 2012 Iron Viz competition in San Diego at their customer conference.  It was created in 20 minutes, while onstage, using a provided data set.  The viz shows the region called "Tornado Alley" and compares the number of tornadoes and fatalities to other regions. It was the winning viz!

Read More

Federal Budget and Presidential Popularity

/
Federal Budget and Presidential Popularity

This viz was created before the 2012 Election to showcase Federal Budget deficits and surpluses, as well as the % of GDP the budget represented, over time.  An additional view of presidential popularity was also provided along the same timeline.  No correlation is implied.  It is interesting to now the extreme volatility of popularity as well as the limited number of Presidents who enjoyed an increase over time.  The viz provides insight as to the effects of historical events, such as wars and economic fluctuations may affect popularity.

Read More

The Great Divide

/
The Great Divide

This viz was created based on the research of Thomas Piketty and Emmanuel Saez, "Income Inequality in the United States, 1913 - 1998". It shows the Income Share or Average income over time and by income group. It also provides an additional layer of user selected historical context data, such as GDP and CPI and the ability to change the "benchmark" year so changes relative to a specific time period such as wars, or deregulation can be highlighted. This viz was the winner of the Tableau 2012 Biz Viz contest.

Read More

Heatmap Checkout Abandonment Flow

/
Heatmap Checkout Abandonment Flow

This viz displays a visual walkthrough of the checkout process for a fictitious retailer. Rather then display a table or funnel of the data, this layout uses images of the checkout flow as background maps, shows visually where the abandonments occur. This allows the added insight of examining the UI along with the data adding richer insight into the flow.

Read More

Dynamic Report Templates

/
Dynamic Report Templates

This presentation was created for the Tableau 2012 user conference Tips and Tricks session. It walks through how to create a dashboard "application" for users that may want to have a simplified way to create basic reports, dashboards or charts, such as for PowerPoint presentations. The output is highly formatted and presentation ready, shielding the user from having to do any formatting or branding. The concept uses the sample data from a fictitious coffee merchant. The user has the ability to select the report attribute being reported on, the metric uses to monitor performance, filter criteria and the output chart or dashboard display. Use the tabs to walk through the presentation as well as a step by step "how to". The concept is called the "Chart-o-Matic".

Read More