Has Power Pivot Changed Your Life? I Want to Know!

August 19, 2014

This face obviously represents happy.

We Want to Hear Your Cool Stories!

Unprompted Confirmation

In last week’s post I explained why I now “kick off” my training sessions with the bold promise of “Power Pivot will change not only your career, but also your LIFE.”  (Please go back and read that, briefly, if you have not – because this post won’t make as much sense otherwise).

Well, a funny thing has been happening lately – I’ve been getting emails from people saying that it HAS changed their life.  Literally in those words.

Are these people just being nice to me, confirming my bold statement?

Nope, because none of them has heard me say it before – these are people I have never met in person!

In fact, this pattern of emails was the reason why I got started writing last week’s post.  I actually intended to JUST write THIS post, the “has it changed your life” post, but along the way I realized I needed to add the background, so this got split into part two.

Please Share Your Stories!

If you are feeling like this, please leave a commentIf you’ve experienced life change as a result of Power Pivot, please leave a comment at the end of this post!

Or if you’re a bit shy about that, drop me an email.  My address isn’t hard to find or guess.

Take it Away, Rob’s Inbox!

imageThese are real emails from real readers, slightly edited to maintain their privacy.  In all cases, I am bolding the “life changing” portion of the quote:

Read the rest of this entry »


Vending Machine or Kitchen: Two Kinds of Self-Service

August 12, 2014

Preface:  Breaking the Consulting “Rulebook”

Power Pivot Allows Us to Set a Much Higher Bar - and Then Clear It

This may seem bold:  Starting about six months ago, whenever I find myself in a room with spreadsheet/business/database people, one of the first things I tell them is that Power Pivot won’t just change their work, it will change their LIVES.  That’s right – I tell them, with a straight face, that this business technology will actually make them happier.

That violates one of the unwritten rules of consulting, which is to underpromise and overdeliver – set expectations low enough that no one ever has reason to complain or be disappointed.

I understand why it’s traditionally a good practice to “set the bar low.”  I get it.  I truly do.

“Consumer with Choices” vs. “Empowered Producer” is a BIG Difference

But Power Pivot is different.  Yes, in the truly breakthrough, transformational sense – you knew I was going to say that.  But different in another critical sense as well – it requires (and incents!) the analyst types on the Business side to participate to a degree unlike with any other BI tool.

No matter how they are marketed, every other BI tool I have ever seen treats the business user as a glorified Consumer.  Yes, Business Objects and Cognos for sure, but I’m also looking at you, Tableau and Qlikview and Spotfire.

Read the rest of this entry »


Next Week’s Sold Out Class: One Spot Re-Opens

July 25, 2014

 
Hi folks.  Next week’s 2-day class (Wed-Thu, 7/30-7/31) taught by me (Rob) has been sold out for awhile now, but we had a last minute cancelation.

So if you live in the Cleveland area, or feel like some last-minute travel, drop us a note at empower@powerpivotpro.com

If you ARE considering the trip, you won’t be the only one traveling in, btw.  Of next week’s class, 16 of 17 students are coming from out of town.  Maybe you want to be lucky number 17 of 18.

We’re also doing a social outing/dinner for the class on Wednesday night.  The famous Matt Allington will be joining us from Down Under.

Note that we’re doing another class in August as well, so if you’re not inclined to join us on short notice, there’s another option as well.


July 30-31 Cleveland Class: Now With Special Guest!

June 3, 2014

 
image

Yeah, the Crazy Aussie Himself Will Be Attending:
Former Coca-Cola BI Director, Matt Allington!

July 30-31 – Cleveland, Ohio. 

Conquer Data AND Meet Living Proof of Legitimacy.

Last time I taught one of these, I was flattered that half the class came in from out of state – Indiana and Pennsylvania, I believe.

Well, the famous Matt Allington, who left his BI Director Job at Coca-Cola to join the Power Pivot Revolution, is taking that to the next level, and flying in from Australia.

Class Info

Two full days, $1249 per student. 

  1. Download the PDF agenda HERE.
  2. Reserve your spot HERE.

Convince Your Boss?

We hear this a lot:  “I’d love to attend, just not sure how to sell it to the boss man/lady.”

You could always say, “well, a BI Director at Coke has bet his career on it, for $1249 we can have that power too.”

Failing that, drop us a note and we’ll help you with a tailored value proposition: 

empower@powerpivotpro.com


Simple, Amazing, and Happy: A Story About Data

May 29, 2014

Last week’s two-part series on The Three Big Lies and The World Doesn’t Know Its Own Numbers got me thinking about how all of this is connected.  It’s all one big story, and I need to stitch it together.

I actually told a big part of that story in one of my sessions at the PASS BA CON earlier this month, and people seemed to genuinely both enjoy and benefit from it.  Because of that (and because I spent over 100 hours prepping that talk!), I’ve been meaning to re-record that talk for YouTube.

So I thought, hey, let’s cross the streams.  I’ll make a series of short videos that tell the entire story – including, but not limited to, what I shared at PASS.

Today I present the Introduction to the story.  Anyone who’s used Power Pivot for awhile will “recognize” the transformation I’m hinting at in this Intro, but if you’re just starting down the road, I hope you find it exciting.  Because you have some amazing discoveries just around the corner.

Please tell me what you think of this video – either here or on YouTube – because I’ll factor that into the series.  The more I know, the better I can tell the story.

(Note that we will be switching PowerPivotPro.com over to a new server this weekend, so comments might be disabled here starting Friday night).


The 3 Big Lies of Data. (And Power Pivot vs. Power View, Power Query, Q&A, etc.)

May 20, 2014

 
How Power Pivot, Power View, and the Other Power BI Tools Relate to Each Other

Power Pivot is the Engine that Turns Data Into Information!
But We Can’t Understand This Properly Without Examining the Three Big Lies of Data

Goal:  Answer Four Frequently-Asked Questions

So many things to say this week. Let’s jump in.  Here are the questions I ultimately aim to answer, which are questions I get basically everywhere I go:

  1. How do all of the Power BI Components relate to each other?  Power Pivot, Power Query, Power View, Power Map, Q and A, etc. = Power Confusion for some folks.  I get it.
  2. Has Power Pivot become less important, now that we have all of these other new “Power *” tools?
  3. Which tool should I learn first in the Power BI family?
  4. Should I consider abandoning this stuff altogether in favor of <hot new technology X>?  Tableau, Hadoop, R, etc.

In order to answer these, first we must confront some insidious lies that we are told every day.

Examining:  The Three Big Lies of Data

We want data tools vendors to lie to usThe world of data, today, is clouded by Three Big Lies.  These lies originate with all of the tools vendors – Oracle, IBM, Tableau, etc., and yes, Microsoft too is very much playing along.

Even though the Vendors are the Purveyors of these lies, they are NOT “at fault” for them.  Because the world actually WANTS to be told these lies.  BADLY wants to be told them, in fact.  And because the audience is so receptive to these lies, the vendors naturally learn to tell them, and tell them well. 

Vendors who DON’T learn to tell these lies?  Well, those vendors don’t win many customers.  And then those vendors disappear. 

So while the lies COME from the vendors, the PROBLEM, really, is with US – the people who BUY the tools.

Read the rest of this entry »


Mini-Post: 2-Day Class in Cleveland, July 30-31

May 1, 2014

 
teacher power pivot

Yes, I Look Precisely Like This in Person Smile with tongue out
(But No, I Don’t Have One of Those Little Teacher Batons)

The last time we did this was a blast.  So we thought we’d do it again, this time with more advanced notice.  I met some truly amazing people – even the lunch breaks were just a lot of fun.  And, as amazing people are inclined to do, they are now off doing amazing things with their data.

Half the class actually traveled in from out of town last time, which is an inversion of my normal dynamic of flying out to a client’s headquarters.  It’s a very cool feeling to wake up at my house, get in the car, and go teach Power Pivot all day.

It makes it all feel very mainstream, which is of course becoming more true every day.  The first time I taught Power Pivot professionally was 3.5 years ago out in California, and for what felt like a long time after that, ALL of my clients seemed to be “out West.”

That I can now teach classes without leaving town is, in itself, a sign of the times.  Just fantastic.  And I hope to see a few of you there.

This time I think we will also schedule a “social event” of sorts at the end of the first day.  Even if it’s just grabbing a beer or something similarly simple, it’s something I wish we’d done the first time, especially for the out of towners.  Purely optional and informal.  But fun.

Syllabus, pricing, and registration information here


Mini-Post: Agenda “Slides” from One of my PASS Talks Next Week in San Jose, CA

April 30, 2014

 

Power Pivot Talk on Self Service BI Revolution

One of my Intro “Slides” for Next Week
(“Slides” in quotes because the live version is animated)

I’ve mentioned before that I am speaking at the 2nd annual PASS Business Analytics Conference, aka BACON, and I’ve also mentioned that I’m scheduled to present three separate sessions:

  1. A full-day pre-conference session – a Power Pivot Jumpstart, if you will.
  2. A joint presentation with Mike Miskell of Kaman Industrial Technologies, where we talk about their tremendous Enterprise-wide scorecarding success with Power Pivot.
  3. A “solo, standard” session on My Seven Principles for the Data Revolution (listed as Six in the program, but Now With 16.7% More Principles!)

In Case You Like BA-CON on a Whim…

I think there’s approximately a 0% chance anyone is going to decide “hey, I’m gonna fly to San Jose next week on short notice,” but just in case, remember to use the discount code BASB5O.

Those of you who are already signed up?  Well, I will see you next week Smile

Power Pivot Talk on Self Service BI Revolution

This “Crypto-Cute” Agenda Slide Will Be Explained to Attendees Next Week
(Also Animated.  Hmm, Maybe I Will Do a YouTube Version in the Future)


A New Kind of Secret Formula: BI Director Leaves Coca-Cola to Become Power Pivot Professional

April 24, 2014

Matt Allington

This Man Just Walked Away from His 25-Year Career at Coca-Cola
to Become a Power Pivot Professional.
(And the Short List of Rob’s Favorite People Grows by One)

I Am Not Making This Up

Seriously, this is the Truth.  Matt Allington, pictured above, was until recently the BI Director for the entire Asia-Pacific region at Coca-Cola.

And he recently turned in his resignation – to join OUR ranks.  He sees the same sort of promise here that I first glimpsed in early 2010 – that “New and Better Way” thing.

From Coca-Cola to PowerPivotThis isn’t just an “Excel Pro.”  No, this is someone who has “been around the block” with data tools of all shapes and sizes.  A savvy and respected leader from the BI profession – and not from a small company.

I’m torn on how to describe my reaction.  On one hand, of course, I am not surprised.  When you truly believe in something (as I DO with this Power Pivot stuff), you’re never really shocked when someone else agrees with you.  If you are, you didn’t really believe all that deeply or honestly right?

But at the same time?  HOLY SHIT EVERYONE, the BI Director for Coca-Cola Asia Pacific just jumped ship for the Power Pivot revolution!!!!  Anyone know how many synonyms there are for “awesome?”  Cuz I think I’m going to use every one of them.

An Unexpected Client Development

Back in September, I got an email from a guy named Matt who wanted some quick help with Power Pivot.  Then I noticed Coca-Cola.com as his email address, and THEN I noticed his title.  Hey, I was flattered to help.

Read the rest of this entry »


Occupy BACON: Let’s Do This. (Sessions & Discount)

March 18, 2014

 
image

It’s Possible that Maybe I Added Something to Their Banner Image :)
(Click Image to Visit Site)

Year One Was Great, So I’m Speaking Again – San Jose CA, May 7-9

I really enjoyed the inaugural PASS Business Analytics Conference, aka PASS BACON, last year.  Before that, I’d never been to a conference that was even remotely aimed at “my kind of people.”  That all changed for me last year.  I think we have found our home.

THIS is the kind of conference we need – one that’s accessible without heavy technology expertise.  One where Business Impact take center stage, and the only pre-requisite is that you enjoy working with data.  (And it helps if you don’t flinch at the word “Microsoft.”)

Which suits us Excel folks to a tee, doesn’t it?  They might as well put us on the front page.  But an explicit mention of Excel would scare off those other people – the non-Excel people (that we outnumber 100 to 1).  Honestly I think we should just take this thing over.  You know, like…  Occupy BACON.  (Brief pause while I replace the previously-bland title of this post with precisely that).

Putting my time where my mouth is, this year I am “doubling down” and presenting two sessions – a full-day “pre-con” and a “regular” session – see below for details.  AND I’m in discussions about presenting a third session as well, stay tuned on that.

We like dominating the "BACON Challenge"Last Year’s Referral Champion Wants to Repeat!

A little bird told us that last year, more people signed up for PASS BACON using the PowerPivotPro discount code than any other discount code.

Pretty cool, eh?  Anyway, there’s a discount code again this year, but I’ve been slow to share it.  Let’s pretend we did that to give all those “non-Excel” websites a head start, given that whole “100 to 1 outnumber” thing (in reality I have just been swamped).

Read the rest of this entry »


2-Day Public Class in Cleveland April 9-10

March 6, 2014

 
If you’re in the Ohio/Midwest area, I would love to meet you in person and help you on your Journey Through the Land of Data.

Only 18 seats in the class, so it will be “intimate.”  Lots of interaction, fun, and obviously…  mind-blowingly powerful techniques.  You know the drill – act fast and reserve your seat today, etc etc. Smile

Syllabus, pricing, and registration information here

(Apologies, no “real” post today – but only because I am so “slammed” with real work.  There are guest posts in the pipeline where if I just could have gotten free for a few minutes…)


Closing Midnight Tonight (US Pacific Time): PowerPivotPro University / Chandoo Bundles

February 21, 2014

Final Reminder!

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.

Click Image to Register

And again, here’s the Q&A posted last week.  Happy learning!