Market Intelligence Group

Hamilton County, Ohio, Auditor Emerson “Dusty” Rhodes provides daily, monthly, and annual excerpts of property transfer data to the public on his web site. This visualization is based on 11 quarters of this data, from January, 2007, through September, 2009. The data shown here are for residential property transfers where the property class is “510″, Single Family Residence. Click on the image below for an interactive look at the data.

Recently, Tableau Software staffer Ross Perez published a visual investigation of graffiti incidents in NYC over the past year. The data was summarized at the Police Precinct level. The following discussion takes the investigation a bit further by exploring the use of several tools to do an investigation at the rooftop/address level, while keeping the Precinct Level focus.

Hamlton County, Oho’s Regional Planning Commission is an award winning public planning agency, in part due to its prolific public data sharing efforts. A recent report it published documents building permit activity …
(read more)

The following visualization demonstates some simple and powerful capabilities of Tableau 5.1. It was published on Tableau’s blog using the new free Tableau Public application, by Ross Perez. His entire blog entry is available here. Click on the image below for the interactive version

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 Veterans’ Health Administration health system is known for the consistent and high-level of care it is able to provide to American military veterans. Like any exemplary organization, it routinely monitors its performance in order to maintain very high standards for health outomes and patient satisfaction. Summary data on many of these recent efforts is available on Data.gov. Much of this information is summarized measures by VHA facility, which are organized in what the VHA calls VISNs. Each VISN may have one or more facilities under its umbrella. Click the image below for a look at inpatient satisfaction using Tableau 5.1.

Geography is a major part of business intelligence. As the folks at Environmental Systems Research Institute put it, “Geography Matters”. In our work, “where” is often the first question. Who, what, why, how, and how much quickly follow, but “where” is usually central, along with the corollary, “how far?”. For example,

where [...]