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…
Using a Google Fusion Tables Network Graph to Visualize a Conformed Data Model
Documenting data models can be painstakingly boring, but having documentation available when building, modifying and using data models can save time and effort on an order of magnitude. Most documentation…
An Entire City Mapped in a Day at Mapbox
Have you ever browsed open data sets, and realized that open data is loaded with GIS data? When searching the web for new open data visualizations, I stumbled across Mapbox.…
Flowing Data Maps a Century of Earthquakes
If you have an interest in visualizing data, then you should be visiting the site Flowing Data on a regular basis. The author is Dr. Nathan Yau (PhD), and he provides fantastic examples…
CMS Medicare Provider Utilization and Payment Data Now Featured at Open Data Bits
The Centers for Medicare and Medicaid Services (CMS) has recently released Medicare Provider Utilization and Payment Data at the detail level of Physicians and Other Suppliers. This release of open data…
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…
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…
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…
San Francisco Police Department Reported Incidents Open Data
SFPD Reported Incidents Open Data in Power View The city of San Francisco has made a wealth of data available for public use via an open data website. One of…