Employment and Payroll Data Example from Tableau Public

In an effort to explore the possibilities for using visual data analysis software to make public data transparent, exploratory, and understandable, we are testing the use of Tableau Software. One excellent and award-winning source of examples of public data is the Data Center of the Hamilton County Regional Planning Commission (HCRPC) web site. The resources there include data from local and national sourdes, including county departments; state governments in Ohio, Kentucky, and Indiana; and many federal agencies like the US Bureau of the Census and the Department of Labor (Bureau of Labor Statistics). The breadth of subjects include physical and policy planning, population change, school performance, economic indicators, and much more.

The following example takes data from the County Business Patterns, that was published in the County Business Patterns 2006-2007 .pdf by the HCRPC.

The map in the upper left quadrant of the faceted analytic display (Stephen Few, Dashboard Confusion Revisited, March 2007) shows the number of employees encoded as the  size of each bubble, and the number of employees per establishment (color) for each county within the CMSA. Hovering over any bubble reveals the overall average number of employees per establishment along with the name of the county and the URL for the official county presence on the internet. Clicking on any bubble in the map causes the associated data in each of the other panels of the display to highlight.

Powered by Tableau