What is Power Pivot’s #1 Competitor?

January 21, 2014

 
Tableau Versus Excel.  Not Tableau versus Power Pivot.  That is telling, ye?

This Picture is a Hint.  An Admittedly Annoying Hint That Hounds me on Facebook.

“OK, way to make it super-obvious, Rob.  It’s Tableau, right?”

Actually, no.  It’s not Tableau.  And the Tableau advertisement above basically proves my point.

By far, the biggest “competitor” to Power Pivot is…  Excel itself. 

In other words, lack of awareness that Power Pivot even EXISTS is still the biggest “competitor” to Power Pivot today.

The Tableau marketing department is smart.  They know that “normal” Excel is their chief competitor.  And they know that “normal” Excel has some frustrating weaknesses when it comes to data analysis.

So they go right for the throat.  I salute and admire their savvy.  Which brings me to a movie quote.

Read the rest of this entry »


Power Pivot IS Enterprise BI: GNET’s Neelesh Raheja

December 5, 2013

Following Up on the Industrial-Strength Reality of our Favorite Toolset

8 Days is Average Time it Take for IT to Add a Column to a Report

A GNET Slide That I Plan to Steal.

Last week’s post about Power Pivot jobs at GNET really drew a lot of interest.  I was thrilled to see so many resumes come in.  A number of people were/are even willing to relocate across the country!  We swamped “poor” Neelesh, heh heh.  Good stuff folks.

But I also got a lot of questions – about their methodology, how to prepare oneself to play the “BIM” role in that system, how to get your own organization to see the promise of this approach, etc.

So I thought I’d interview Neelesh for the blog.  He accepted, and here we are Smile

Bill Hader wore a PowerPivotPro visor in "Hot Rod???"  SWEET!

Confirmation like this almost makes me jealous

True story:  In college, I (Rob) majored in Computer Science, Math, and Philosophy.  Trust me, that sounds more impressive than it was – I “gamed” the university system quite well and took a lighter course load overall than any of my friends.  (I graduated Magna Cum Lazy.)

So I wrote a lot of Philosophy papers while my more responsible peers were learning to program in C++.  Which was fine, because I was a lot better at Philosophy papers than I was at programming.

In a few of those papers, I thought I “invented” a new concept that was groundbreaking.  Something that would shake the world of Philosophy to its very core.  Old men in tweed suits were going to carry me around on their shoulders chanting my name.  But then, back in reality, I discovered, a few weeks later, that some well-known philosopher had written about precisely that same thing decades ago.  Happened more than once.

Read the rest of this entry »


My Power Pivot Journey: Personal > Team > Organizational BI

September 3, 2013

Guest Post by Avichal Singh

Intro from Rob:  an exciting guest post for sure…  a Power Pivot “adoption story” from inside Microsoft itself!  Over my years in Redmond, I met MANY Excel pros who were working at MS as analysts in the financial and accounting units.  Today, card-carrying Excel Pro Avichal Singh shares the progression of one such team, and how he helped “grow” the usage of Power Pivot all the way to the border of “traditional BI.”  It’s a fascinating glimpse at potential futures – both for Excel pros and their organizations.

Take it away, Avichal…

Intro

by Avichal Singh www.linkedin.com/in/avichalsingh/

If you have seen any of the promotional material for SQL Server/PowerPivot, it’s likely you have come across the slide which speaks to the spectrum of Personal BI, Team BI and Organizational BI. My journey started at personal BI, and I didn’t quite know then, how far it would take me.

clip_image001[4]
Source: Analysis Services & PowerPivot Blog

Read the rest of this entry »


My Conversion to PowerPivot: Guest Post By Geoff McNeely

July 4, 2013

 
image

Intro from Rob:  I may be hopped up on painkillers at the moment, but when a story needs to be told as badly as this one does, I can still spot it.  This is precisely the kind of transformation I see as the future for determined Excel Pros.  Let’s call it The Journey.  And it’s always good to hear from folks who are already on that journey, and proving that it’s a reality.  So I’m gonna get out of the way – mostly! – and let Geoff tell us his tale.

Hi there folks. I’m Geoff McNeely (@geoster on Twitter, or find me on LinkedIn) and I’ve guzzled the Kool-Aid. I’ve been using PowerPivot for several months now, I have Rob’s book, and I gave my first peer presentation on PowerPivot in May. Go ahead and call me an evangelist. I’m a believer!

So when Rob gave me the opportunity to write a guest post it was like one of those moments…you know, like will I go crawl under a rock and forget I ever aspired to write anything, or will I engage and make it happen?

I’m gonna go with “Engage, Maverick!”

clip_image002_thumb

Read the rest of this entry »


The Ideal PowerPivot Professional: How to Hire, Grow, or Become One

June 6, 2013

 
image

…But Don’t Expect Us to Wear Suits OK?

Got a great question in email yesterday from a potential training/consulting client.  Paraphrasing:

“…what’s the best way for our company to get the required PowerPivot/Financial analysis skills? Should we be hiring for them, developing them in-house or outsourcing them to other organizations?”

As I was replying to the email I realized this was a good topic to discuss publicly.  How should your organization find the right PowerPivot people?

The answer to this question, of course, is also quite relevant to the budding PowerPivot professional – the “Supply side” of the equation if you will – and therefore the majority of people reading this.  But I am going to approach the question from the employer side – the Demand side – because I think that’s the best way to answer the question for both parties.

Read the rest of this entry »


Friday Bonus: PowerPivot Discovers a New Form of Communication in the Animal World, Makes Headlines in Science!

March 8, 2013

 
image

A Sampling of Headlines From the Past 24 Hours Smile

Remember the Sniffing Project?

If you were reading this blog a year ago, you may remember the “peak detection,” “fuzzy overlapping timeframes,” and “converting from peaks to frequencies” posts.

Among other things, that series gave us one of my favorite pivots of all time:

image

Those posts stemmed from my work with my neighbor, Dr. Daniel Wesson (I like to call us “Datasmith and Wesson” when we collaborate, btw).

He was hot on the trail of something AMAZING, but I wasn’t able to share the results until now:

He’s discovered a new form of communication between animals.  (Well, the communication method isn’t new to the animals themselves, but science wasn’t aware of it.)  And the world’s news and science sites are abuzz with it.  You could say they are….  hyperventilating?  (Said in best Dr. Evil voice, with pinky finger raised).

Read the rest of this entry »


PowerPivot Beats IBM/Cognos: Textbook Example of ROI (and Going Beyond “Informal BI”)

June 21, 2012

 
My Favorite PowerPivot Case Study to Date

We recently completed our second joint case study with Microsoft, describing the work we did with one of our Cloud PowerPivot clients, Building Materials Distributors.

This was a fun project to watch.  And that’s mostly what I did, was watch.  Because the good folks at BMD did the work – all we did was give them the environment in which they could do it.

A Quick Read, and Good Justification!

It’s basically a one-page case study and a very quick read.  I don’t want to just duplicate it here, so I highly encourage you to go read it real quick, then come back here for the points I want to emphasize.

Click here to view the case study

imageI know, you don’t want to go read some boring case study.  Clicking links to other sites (especially “official” sites) really kinda sucks in general, I know that.  It’s more fun, frankly, to read sites where the author is allowed to use the word “sucks.”

But I think this one will come in handy for PowerPivot Pros who are advocating broader adoption at their companies.  You may know in your bones that PowerPivot will revolutionize the way your organization operates, but convincing others (especially non-Excel pros) can be tricky.  And let’s face it, blog posts on a site that uses the word “sucks” and features pictures of Samuel Jackson aren’t the most convincing evidence are they?

But big money savings, quick deployments times, and successful examples of PowerPivot “defeating” much more complex and expensive solutions, all packaged up in an official case study – that counts.

The Points I Want to Emphasize

Quickly and succinctly, here are the four things I would like to call out…

Read the rest of this entry »