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,…
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…
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…
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…
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…
Consumer Financial Protection Bureau Complaint Database Now Featured at Open Data Bits
The Consumer Financial Protection Bureau of the United States educates consumers about financial options, enforces federal consumer financial laws, and conducts studies to "better understand consumers, financial services providers, and…
WhiteHouse.gov Office of Management and Budget Data Visualization
Office of Management and Budget open data from visualized in Excel 2013 The United States Office of Management and Budget (OMB) has provided budgetary open data for public use that is accessible…
San Francisco Graffiti Reports and SFPD Reported Incidents Data Mashup
San Francisco Graffiti and Police Incidents Data Mashup The open data sets previously featured at Open Data Bits were both from the city of San Francisco, and they both contained…
Canada 2012 HIV/AIDS Attitudinal Tracking Survey Open Data
The 2014 Canadian Open Data Summit is taking place in Vancouver today, February 21. In the spirit of the convention, an open data set from the Canadian government will be…