• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Joe Leider

Data Narration & Visualization | Investment, Economic & Political Commentary

  • Data visualization
  • Economics
  • Investing
  • Policy
  • Personal finance
  • Digital marketing

When to go interactive: data visualization of census business stats

January 16, 2015 by Leave a Comment

With most data visualizations, interactivity is wasted on your visitors – they take a look at the graph, get the gist, then move on. But there are times when you want interactivity. Mainly, this is when you want it to act as a reference. Below are some visualizations using census data. I transformed the raw data using Tableau calculated fields to give us a penetration metric by industry (naics description).

The first visual shows a by-state % penetration (number of businesses within an industry / number of total businesses). The interaction is a simple filter by industry. I use color to highlight the higher vs. lower penetration rates.

 

Learn About Tableau

 

This next visualization is a reverse of the first. Here we have % penetration by industry for the whole country, then filterable by state & city. The filters interact with each other, so selecting California first allows you to see only California cities in the second filter. In Cupertino, for example, the highest-penetrating naics is professional, scientific & tech services at 32% of all businesses.

Learn About Tableau

Below is another way to interact with a visualization. Instead of serving as a reference, this is more to drill down into a metric by first spotting an outlier. On the scatter plot, you see a trendline plotting % of businesses in information vs. % in educational services. There is a positive correlation between the two, but California is an outlier (more information businesses relative to educational). By clicking on the dot, you can easily see the % information services by metropolitan statistical area to see where the penetration skews the most.

 

Learn About Tableau

 

Below is another interactive scatter plot, this time showing the relationship between professional/scientific/technical business penetration vs. education. Clicking on the outlier, Colorado, you then see % professional/scientific/technical business % by metropolitan statistical area.

Learn About Tableau

In summary, there are times when you want interactivity in your data visualizations. Mainly it’s when you want a public visual to act as a reference. But also, you may want to quickly flip back and forth between different variables to discover patterns. Or drill into information as in the above scatterplots.

Filed Under: Data visualization

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Navigation

  • Home
  • About
  • Contact
  • Sign up for updates

Recent Posts

  • What is Faith in G-d?
  • Murder in Chicago: Finding the Ferguson Effect in 10 Graphs
  • Trump’s China Pivot: Brilliant or Disastrous?
  • Trump won because he had a plan and Hillary did not
  • The Great Trump Reflation?

Recent Comments

  • takdoa on School shootings data visualization: putting information into context
  • PS on Murder in Chicago: Finding the Ferguson Effect in 10 Graphs
  • PS on Austerity, monetarism & growth: between Krugman, Steil & Sumner
  • robin on House price-to-rent ratios in major US markets: a data visualization case study
  • Jason Anderson on 13 data narratives on crime in Chicago
© 2023 Joe Leider. All rights reserved.