PowerPivotPro-School: Choose your Big Data topics!

by dennyglee Categories: Analysis Services · BigDataTags: · 3 Comments

Are you interested in learning more about PowerPivot from the pro?  The pro I mean is Rob Collie is the guy who designed PowerPivot and has been teaching, writing, and using PowerPivot since 2009.  Well, he has the PowerPivotPro School which has 12+ hours vide on advanced PowerPivot which is designed for Excel users.  If you want to join the course – do it now at: http://www.powerpivotpro.com/powerpivotpro-school/ as sign ups close August 16th, 2013! One of bonus module course that will be part of Rob’s comprehensive PowerPivot course is about Big Data presented by yours truly.  So help me choose which…

Rate this:

Power View Tip: Scatter Chart over Time on the X-Axis and Play Axis

by dennyglee Categories: Analysis Services · Reporting ServicesTags: · · 6 Comments

As you have seen in many Power View demos, you can run the Scatter Chart over time by placing date/time onto the Play Axis.  This is pretty cool and it allows you to see trends over time on multiple dimensions.  But how about if you want to see time also on the x-axis? For example, let’s take the Hive Mobile Sample data as noted in my post: Connecting Power View to Hadoop on Azure.  As noted in Office 2013 Power View, Bing Maps, Hive, and Hadoop on Azure … oh my!, you can quickly create Power View reports right out…

Rate this:

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

by dennyglee Categories: Analysis Services · BigDataTags: · · · 2 Comments

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…

Rate this:

A Primer on Hadoop (from the Microsoft SQL Community perspective)

by dennyglee Categories: BigDataTags: · · · · · 3 Comments

For a quick primer on Hadoop (from the perspective of the Microsoft SQL Community), as well as Microsoft Hadoop on Azure and Windows, check out the SlideShare.NET presentation below. Above the cloud: Big Data and BI View more PowerPoint from Denny Lee Note, as well, there is a great end-to-end Microsoft Hadoop on Azure and Windows presentation available at: Apache hadoop for windows server and windwos azure View more PowerPoint from Brad Sarsfield

Rate this:

BI and Big Data–the best of both worlds!

by dennyglee Categories: Analysis Services · BigData · PowerPivot · Random ThoughtsTags: · · · · 1 Comment

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 PowerPivot to Hadoop on Azure – Self Service BI to Big Data in the Cloud

by dennyglee Categories: BigData · Cloud · PowerPivot · SQLTags: · · 15 Comments

. “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

by dennyglee Categories: Analysis Services · PowerPivotTags: · 1 Comment

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: