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:
- Connecting Power View to Hadoop on Azure
- Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud
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.
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?!
About dennyglee
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?
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?