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,…
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…
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…
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…
Video: What is Open Data Bits?
Open Data Bits is a new initiative to provide guidance and a methodology for using and mashing up open data. The video embedded above gives a brief overview of our…
Video: Enthusiasm for Open Data is Growing in Japan
The embedded video from the Open Knowledge Foundation of Japan is evidence that enthusiasm for open data is growing internationally.
Video: Reasons to Use the Open Data Protocol
A brief yet thorough video that gives an overview of the need for Open Data Protocol.
Video: Rufus Pollock Presents Open Data Past, Present, and Future
This presentation by Rufus Pollock at the 2012 Lift Conference is a great summary of the history, current state, and future potential of open data.