Government data is complex and enormous- so are the challenges facing those who work with it. With Tableau Desktop, you can query millions of rows of data in seconds, drag-and-drop to visualize any dataset, and even publish your analysis to Tableau Public to meet transparency reporting requirements.
Governments and public-private organizations are using Tableau to :
- Present enormous countrywide datasets clearly and allow drill-down to local areas.
- Provide online access to public data without programming.
- Use Tableau's built-in mapping capability to visualize parks, services, accidents, pollution, and more.
- Achieve the functionality of online Flash visualizations without the development cost.
Whether you are law enforcement, a resident, or a potential resident, understandings changes in crime rates in a particular neighborhood is important.
This example shows how occurrence rates of 27 different crimes have changed from 2011 to 2012 in neighborhoods across Victoria, Australia. The color-coded change rates of change range from “Much Better” or “Unchanged,” to “Worse” and “Much Worse.”
The top left map shows a detailed view of the Melbourne metro area locations while the right-hand map focuses on the less population-dense regional areas outside of city limits. The bottom bar chart shows the year-to-year crime occurrence change for each crime by neighborhood. Hover over the horizontal line on any particular bar for the exact number of instances of that crime that were committed in 2011.
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, or struggle to find information that is relevant to them. And telling stories well is hard: Flash and other online visualization tools require weeks of programming and are expensive. Tableau lets you create interesting interactive visualizations that help people understand public data. Create beautiful applications that let people find their own stories: their own school or district, or their issue of interest.
This visualization shows the U.S. federal deficit projection between 2011 and 2022. The first example shows an overview of projected deficit growth and projected revenue and spending; the second example provides detailed breakdowns of the projected revenue sources and spending categories.
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. Tableau takes the tedium out of government data by providing an easy-to-use drag and drop interface that anyone can master. And Tableau's 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.
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.
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.
The ability to easily and cheaply scale from local to global issues is one of the things that distinguishes Tableau 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.
State and local governments collect lots of data, and they’re searching for new ways to create visibility into that data for residents and businesses. With Tableau, it’s easy for governments to create beautiful and intuitive ways to explore that data, empowering the everyday user to make informed decisions from state and local government data, employment data, census data, demographic data and more.
Without investing hundreds of expensive analyst and developer man-hours, governments can create transparency in their data, creating app-style tools that encourage exploration of data and answer specific questions.
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 Tableau, 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.