Pull openFDA API Data into a Pivot Table using Microsoft Excel
The United States Food and Drug Administration has launched a new open data site called openFDA. The site is currently in Beta testing, and provides API access to over 3…
Understanding and Using Scatter Charts – One of the Most Powerful Data Visualization Tools
Bar charts, line charts, and pie charts are the staple data visualization tools that most people use to present and consume data. If you've ever explored the chart types in…
Combine Chicago Crime Data with Census Data for New Insights
The City of Chicago provides access to crime data through their open data portal. Another data set at their portal, which originates from an entirely different source, is for census…
Video Tutorial to Unpivot Data Columns to Rows Using Excel with Power Query
Quite often, data sets will store similar or identical attributes in columns instead of rows. When mashing up data or analyzing data using business intelligence tools, keeping data in rows…
Chicago Socioeconomic Indicator Data Added to Our Library
The above bubble chart graphs Chicago socioeconomic factors by Community Area. You can see that as Per Capita Income rises the Hardship Index decreases, the percentage of households below poverty…
Film Locations in San Francisco Added to our Mashup Library
There are many interesting data sets to be found in San Francisco's open data portal, but Film Locations in San Francisco was an unexpected surprise. We recently used this data…
Tutorial Video Uses an OData Feed to Pull Data into Excel using Power Query and Power Pivot
Many open data sets are made available via OData feeds. An OData feed is a standardized protocol for data consumption. Learn more about OData feeds at this link. The video embedded…
Instructional Video to Mashup Chicago and San Francisco Crime and Police Open Data
Open Data Bits has created the above video to provide value in a few different ways: This video gives instructions for using the Open Data Bits library to create your…
City of Chicago Crime Data Now Featured at Open Data Bits
The City of Chicago has an official open data portal providing public access to city government data. A data set with details about Crimes in the city of Chicago from 2001…
Connecticut Department of Economic and Community Development Portfolio Open Data Feature
The State of Connecticut has recently launched an open data portal providing public access to open data. The site is powered by Socrata, which in my experience provides a very solid…