Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

New PowerPivot & Azure DataMarket Experience

Posted by denglishbi on November 19, 2010

I finally got around to installing the latest version of the PowerPivot application.  The new build number is 10.50.1747.0 (previous RTM build was 10.50.1600.1).  Here is my install experience while having the RTM x64 version already installed on my laptop (go from left to right and then work your way down):

image image image
image image image
image image image

Pretty neat, no need to uninstall and reinstall – thanks Microsoft!

Ok, so now that we have rebooted lets take a look at this new functionality that was added…Azure DataMarket data connection.  To the clouds we go!

image image image
New icon in the external data connection portion of the PowerPivot Ribbon – lets load up that cart with some data… The option that is available in the ‘From Other Sources’ option The new Import Wizard for getting data from the clouds
image image image
What you see when you click on the ‘View available Azure DataMarket datasets’ link in previous screenshot Need to register for the service to get an Account Key setup – this is a FREE registration Registration agreement screen
image image image
Going to subscribe to get access the to the crime data feed Sweet, we are all set to go and the list of options is available for us for exploring the data Account information provides Account Key needed in PowerPivot to connect.  This screen will be displayed if you click on the Find button in the wizard above
image image image
If you go into your account, datasets, you will get the URL for accessing it in the details section of the dataset in the browser. Place this in the wizard Next screen, let’s try the preview now Oh no, didn’t work, what now?
image image image
Never fear, we have Marco Russo to save us!  Just add an extra slash onto the end of the URL string Now we can preview the data.  The Test Connection option would work either way, but need extra slash to get data. Let the import begin.
image image image
Download complete. New table in the PowerPivot Windows. Time to analyze data for violent crimes, MN is looking okay (#34).

How cool is this?  Really neat that we can tap into some external data and get this incorporated into our existing internal data for analysis.  Lots of data is available out on the Azure DataMarket to take a look at including weather information which is always useful.  This analysis I did was extremely raw and has tons of gaps since I find it hard to believe MN had zero violent crimes in 2006 and you have to factor in population sizes into this analysis (that information was included, just not part of my Pivot or metrics).

So what are you waiting for, go ahead and download the latest version of PowerPivot and tap into some new data feeds –> Download PowerPivot.

Head to the clouds for your data – http://datamarket.azure.com/

Please support the connect bug to get this escalated – PowerPivot fails using URL published on Azure DataMarket website

2 Responses to “New PowerPivot & Azure DataMarket Experience”

  1. greg kramer said

    thanks Dan!…hope to be doing this later this weekend!

  2. […] New PowerPivot & Azure DataMarket Experience […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: