In my previous post, I used Data Explorer to grab the list of upcoming events from the SQL Saturday website. Excel has had the ability to grab data from HTML pages for awhile, but using Data Explorer provided a richer set of options, and allowed me to apply a series of transforms to get the … Continued
Access the Windows Azure Marketplace from Data Explorer
One of the data sources that Data Explorer supports is the Windows Azure Marketplace. The marketplace (formerly known as “data market”) has a number of free and paid data sets that you can subscribe to. In this post I’ll walkthrough the steps of pulling data from the marketplace. On the DATA EXPLORER tab in Excel, … Continued

