SQL Server Analysis Services to Hive

Over the last few months, we’ve chatted about how Hadoop and BI are better together – it’s a common theme that Dave Mariani (@dmariani) and I have spoke together about in our session How Klout changed the landscape of social media with Hadoop and BI. While this all sounds great, the typical question is “How do I do it”?  I am proud to say that after months of intense writing – all of this is due to the amazing work by Kay Unkroth who regularly blogs on the official Analysis Services and PowerPivot Team blog – we now have the…

Rate this:

BI and Big Data–the best of both worlds!

As part of the excitement of the Strata Conference this week, Microsoft has been talking about Big Data and Hadoop.  It started off with Dave Campbell’s question: Do we have the tools we need to navigate the New World of Data?.  And some of the tooling call outs specific to Microsoft include references to PowerPivot, Power View, and the Hadoop JavaScript framework (Hadoop JavaScript– Microsoft’s VB shift for Big Data). As noticed by GigaOM’s article Microsoft’s Hadoop play is shaping up, and it includes Excel; the great call out is: to make Hadoop data analyzable via both a JavaScript framework…

Rate this:

Connecting Power View to Hadoop on Azure–An #awesomesauce way to view Big Data in the Cloud

The post Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud provided the step-by-step details on how to connect PowerPivot to your Hadoop on Azure cluster.   And while this is really powerful, one of the great features as part of SQL Server 2012 is Power View (formerly known as Project Crescent).  With Power ‘View, the SQL Server BI stack extends the concept of Self Service BI (PowerPivot) to Self service Reporting. Above is a screenshot of the Power View Mobile Hive Sample that is built on top of the PowerPivot workbook created in…

Rate this:

Connecting PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud

. “I caught a fish thiiiiis biiig” — On stage with Ted Kummert during the PASS 2011 Keynote on Big Data (thanks to Karen Lopez @datachick for the pic) . . During the PASS 2011 Keynote (back in October 2011), I had the honor to demo Hadoop on Windows / Azure.   One of the key showcases during that presentation was to show how to connect PowerPivot to Hadoop on Windows.  In this post, I show the steps on how to connect PowerPivot to Hadoop on Azure. Pre-requisites PowerPivot for Excel (as of this post, using SQL Server 2012 RC1 version)…

Rate this:

Using SQL Server PowerPivot for Excel to Analyze SAP Data

Sorry! I’ve been offline and haven’t blogged or responded to comments for quite some time and frankly I don’t have any good excuses: I fell asleep My dog ate my WordPress login account info (never mind that I don’t have a dog yet) I was working (yeah, right) I used the TARDIS to back in time to the Byzantine empire and became a Roman soldier…oh wait, that’s me confusing the awesome Doctor Who episode “The Pandorica Opens” with reality again Okay, no more excuses and back to work!  I’ll catch up on the comments eventually too! So it’s the new…

Rate this: