Government

Government Reporting

Government data is complex and enormous- so are the challenges facing those who work with it. With our solutions, you can query millions of rows of data in seconds, drag-and-drop to visualize any dataset, and even publish your analysis to the public to meet transparency reporting requirements. Governments and public-private organizations are using our solutions to.

  • Present enormous countrywide datasets clearly and allow drill-down to local areas.
  • Provide online access to public data without programming.
  • Visualize parks, services, accidents, pollution, etc. using the built-in mapping capability.
  • Achieve the functionality of online Flash visualizations without the development cost.

 

Massive Data

Present large and complex datasets effectively

It is not uncommon to see government databases over a billion rows. That volume of data would take a casual Excel user days to wade through, much less understand or share. In many cases it would be altogether impossible.

Our solutions take the tedium out of government data by providing an easy-to-use drag and drop interface that anyone can master. And the data engine, a local data store optimized for analytics, lets you work with tens or hundreds of millions of records at interactive speed.

This visualization was made from a million-row national health database in less than an hour. It allows users to get a detailed view of the nationwide obesity epidemic and the factors that influence it. You can drill down to your own state. Select Washington using the drop down filter on the top right and notice that some counties in the southwest corner of the state are tinged deeply red. Click on the darkest of those dots (Pacific County).

The scatter plots below the map will show you that this high obesity rate may be related to an extremely high smoking rate and a low level of physical activity county wide. All of this interactivity works to simplify the massive database to a view that anyone can understand.

Transparency

Publish public data to the web to achieve transparency goals

Making public data accessible to citizens is a struggle for every government organization. Unfortunately, it’s easy to waste precious time and resources on custom systems that fail to deliver.

Luckily, we allow even a single person to efficiently visualize and publish data online. And not just as a flat file or as a table, but as a live, interactive visualization. Citizens can explore the analysis and download the underlying data.

Naturally, citizens are curious about what stimulus money is being spent in their area and why. This application allows users to evaluate the efficiency of the stimulus (calculated as the number of jobs created per dollar spent) by simply selecting a state in the top left view.

Visualization

Quickly showcase wide varieties of public data without programming

Data is a critical component of many national conversations, but telling stories with data is not easy. Viewers quickly lose interest in data-intensive stories when not told well, and often struggle to find information that is relevant to them. Flash and other online visualization tools require weeks of programming and are expensive.

Using our solutions, you can quickly create interesting interactive visualizations that simplify public data into easily digestible and beautiful applications and if needed, a cross-tab or tabular view is only one click away.

This visualization shows the proposed budget for fiscal year 2013. Click on a budget area to see the breakdown. View the second tab see all the data in table format. Use the arrow over a box icon to export the view in a PDF or other format.

Shaing

Distribute information to a small group or to millions

Until now, interactive visualizations have been the domain of nationwide media properties with the budget, time and resources for Flash. Sanjay Bhatt at the Seattle Times does not have any of those things, but with some Department Of Transportation data and Tableau he made this interactive visualization about biking accidents. The larger dots represent intersections with more biking accidents. Viewers can zoom into their own neighborhood using the tools below the visualization, or select points of interest for comparison.

The ability to easily and cheaply scale from local to global issues is one of the things that distinguishes us from other solutions. As you can imagine, this mapping tool could be used to display any number of relevant city datasets, from parks and services, to crime and traffic.

Ad-Hoc Analysis

Provide valuable insight in minutes

Open Government projects are meant to empower advocacy groups and citizens. Unfortunately, most government datasets are so dense and difficult to work with that even a talented data worker is more overloaded than empowered. It’s like having a ream of paper, but no pen. With our solutions, non-profits, journalists and government workers can connect to interesting datasets and start finding stories and solving problems in minutes.

This visualization uses a nationwide public pension fund dataset to expose a massive budget shortfall in nearly every state. Users can interact with the viz by clicking on their state in the map, filtering the list below. Similarly, clicking on an item in the list highlights the state it is associated with.