Office 2013 Power View, Bing Maps, Hive, and Hadoop on Azure … on my!

With all the excitement surrounding Office 2013 (here’s a nice Engadget Review) and energized by Andrew Brust’s tweets (@andrewbrust) and post Office 2013 brings BI, Big Data to Windows 8 tablets, I thought I would expand on my  posts:

For us involved in BI, the excitement surrounding Office 2013 is because Power View is now embedded directly in Excel.  But in addition to that, now I can include maps!  Yay!

So to make my Power View to Hive / Hadoop on Azure even more compelling, I downloaded Office 2013, installed the Hive ODBC driver, connected to Hadoop on Azure (instructions on how to do this are in the above bulleted blog posts)and charged ahead with Power View within Excel 2013.

image

Seriously cool, now I can click on the bars within my Power View report and it changes the bubbles in the maps depicting (in this case) the number of Apple devices (blue bar on the left chart) throughout the world (light blue bubbles indicate no devices in that part).  The source of this data is from my Hadoop on Azure cluster, eh?!

Have fun and start downloading, eh?!

2 Comments

  1. Dorgold

    Hi Denny,

    How did you connect the HiveODBC to the excel data model? Whenever i try to do it it says that the connection can’t be add to the model. (As is the case whitn any ODBC connection).
    So if i just leave it as a data connectionm i can only open PivotTables on it, but no PowerView.
    How did you make that possible?

    1. Interesting – the HiveODBCx64.msi driver includes both the driver itself and the Excel Hive Add-In. Did you validate that both Excel and Hive Add-In are x64?

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s