Seattle Real Time Fire 911 Calls API Data pulled into Excel for analysis using Microsoft BI tools Power Pivot, Power Query, & Power View
The above video walks through the process by which to use an API to pull data into Excel from a real time database of public information. Note that the database,…
Liquor Open Data from British Columbia’s DataBC Platform and BC Liquor Stores
Need a break from browsing accounting ledger open data? Take an hour to browse the BC Liquor Store Product Price list which is available on British Columbia's DataBC open data…
World Bank Forest and Agricultural Data Mashed Up to Visualize Trends
The World Bank provides open data about development in countries across the globe including data about agricultural land and forest area by country over time. Combining both of these data…
Mash Up Minneapolis and New York City Restaurant Inspection Data
The City of Minneapolis has made restaurant inspection data available to the public as open data. A useful example of how this data can be used and exposed to the…
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…
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…
Build Your Own Great Britain Road Safety Data Model
The United Kingdom has a robust, accessible, and useful open data portal. One of the data sets that has been made available to the public is Road Safety Data from…
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…