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…