Big Data Analysis

It is not uncommon to see government databases over a billion rows. That volume of data would take casual Excel user days to wade through, much less understand or share. In many cases it would be altogether impossible.
Bilytica solution takes the tedium out of government data by providing an easy-to-use drag and drop interface that anyone can master. 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.

Public Data – Ease of Access

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.
With Bilytica 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 sees all the data in table format. Use the arrow over a box icon to export the view in a PDF or other format.

Ease of Sharing

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 Bilytica solutions 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

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 Bilytica solution, 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. Without our solution, time and data constraints would have otherwise relegated this amazing data to a spreadsheet.

Census Data

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. 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.
With this app-style visualization, you can choose two counties in Maine, and compare them across trends in education, income and employment. The colorful charts and graphs created are based on U.S. Census data and data from the Bureau of Economic Analysis.