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?!