Three posts last night!

February 18, 2014

For those of you who don’t like to scroll vertically, here’s a Table of Contents of everything posted in the last 24 hours.  Click each handy hyperlink for auto-navigation purposes:

  1. I’m Speaking Next Week in the Twin Cities – the MSBI User Group.  Topic “Fact or Fiction:  The ‘Free Lunch’ Promise of Power Pivot.”
  2. Bundled Offering of PowerPivotPro University and Chandoo courses closes this Friday – and make sure you check out the cool “Super Mario Power Pivot” images sent to me by a student.  He described himself as “leveling up” with my training and I’m going to steal that phrase for perpetual use.
  3. Inaugural Meeting of the Nashville Modern Excel User Group is THIS THURSDAY (Feb 20) – Be there, Music City. :)

Announcing Pivotstream Ltd: Expanding to Europe, Led by David Churchward!

November 1, 2012


Pivotstream Jumps Over the Pond, Opening Office and Data Center in Europe

Happy to Finally Share the Secret!

Boy, I have been dying to share this, but had to wait until it was official:  David Churchward has joined Pivotstream and will be running our operations in Europe.

At a high level, this means a few things:

  1. We will be opening a data center in Europe – European customers who have desired a Cloud PowerPivot site (or one of our Insight as a Service solutions) have often needed the data to physically remain in the European Union (for legal and privacy reasons).  This will no longer be an obstacle.
  2. We will be doing more work in the finance, accounting, and CRM spaces.  David is a MACHINE when it comes to this stuff, as evidenced by his posts on this blog.  This expands our Insight as a Service capabilities in this space, but also gives us the ability to “seed” the broader PowerPivot world with templates – more on this later.
  3. I’ll be able to bug David a lot more often and not feel guilty about distracting him from his “real” job – part of his job now is to be pestered by me!  (Hmm, I DO suppose that works both ways…)


Pivotstream Ltd. – Tentative Logo is Nothing Fancy, All Business

Reinforcement of the Excel Revolution

Regular readers of this blog are familiar with me getting on a soapbox and proclaiming that the future of Excel, and Excel Pros, is exceedingly bright.  PowerPivot changes everything, including our careers.

The fact that I’ve spent the past three years making my living completely off of PowerPivot is testament to that.  It helps the credibility of my message, a lot, that I can say this:  I don’t just talk the story of this revolution, I live it.  I work it.  And it pays the bills.

But now, here’s another public confirmation of it:  It’s a major investment, opening a data center and offices in Europe.  It’s not a step we would take lightly.  You should take this as further confirmation that the world is changing in your favor.  And similarly, David would not have left his Director job at Azzurri to do this otherwise.

Speaking of which…

Read the rest of this entry »

Mini-Post #2: Follow Pivotstream on LinkedIn/Facebook, win a $100 Gift Certificate

October 11, 2012

Like Pivotstream on Facebook  Follow Pivotstream on LinkedIn

The Pivotstream marketing folks have asked me to post this here – we’re trying to gain brand recognition in the Excel Pro community and they figure the blog is a good place to start.  I’m flattered.


Winner Gets a $100 Gift Cert from

Two (or Three) Simple Steps Before 5 PM US Eastern Time, Wed Oct 17th

  1. Visit Pivotstream on Facebook and click Like
  2. Visit Pivotstream on LinkedIn and click Follow Company
  3. If your name is the same on Facebook and LinkedIn, that’s all you have to do to be entered for the drawing
  4. If your name is NOT the same, please send an email to and let us know that you’re done

Deadline:  5 PM US Eastern Time, Wed Oct 17th

Drawing:  Thursday Oct 18th.  I will announce the winner here.

Mini Post: Speaking in NYC on Monday

October 3, 2012


I’m really excited to announce that I will be speaking at the Microsoft offices in Manhattan Monday evening next week!  Talk starts at 6 PM and we have the room until 8:30 PM, so there will be plenty of time for questions and informal discussion after I’m done.

imageWhat’s even cooler for me is that this group, MSBIgDataNYC, is run by Andrew Brust, CEO of Blue Badge Insights and the author of the Big Data Blog on ZDNet

I’ve been following Andrew’s work ever since I started the blog in 2009 and have had the pleasure of participating in a few of his events at conferences, but never on his home turf.  In fact, I don’t think I’ve ever spoken at ANY event in New York City.  I generally don’t get nervous about speaking engagements anymore, but I confess to a few butterflies of anticipation for this one Smile

I believe there are seats still available but move fast just in case:

Click Here to Reserve a Seat

And remember, you do NOT have to be a BI pro or Big Data specialist to attend!  If you’re an Excel practitioner, show up and hold your head high.  You will like what I have to say.

PowerPivotPro: The Book (Coming Soon)

September 11, 2012

***UPDATE:  Window Extended!

I think I can leave the “get your name in the book” offer open until the weekend.  See this post.

Where’s Rob?

You may have noticed a certain absence over the past couple weeks.  David Churchward has been on quite a run of guest posts, and that is no accident.  He’s been keeping things afloat here for me, as a HUGE favor, while I finish the book.

It was time

Yes, the book.  One that captures the essential lessons that I’ve informally recorded and scattered on the blog over the years in random order.  One that sequences all of those lessons properly, explains them more fully than the blog, and forces me to not cut corners.  One that captures the way I teach when I train people onsite.  Ideally, one that helps the Excel Pro in particular make the transition from Excel Pro to All-Out Data Monster.

I’ve been thinking about this forever.  Hey, it’s always sounded like a great idea.  But it’s one thing to think about it and another to actually do it.  I actually started over New Year’s this past January, but then shelved it as things got hectic at work.  Well…  August rolled around, things were STILL hectic at work, and then I noticed THIS on Amazon…  “rut roh Shaggy.”

WAIT!  If you want to pre-order, do it tomorrow, and I’ll put your name in the book.  See below for details.

WAIT!  If you want to pre-order, do it Wednesday, and I’ll put your name in the book Smile
(See below for details)

At the beginning of August, the release date was listed as September 1st.  It was quite the wakeup call Smile.

Plus, this is being published by Bill Jelen’s Holy Macro Press.  It’s a Mr. Excel title!  Bill has been fantastically helpful to me in this whole process, dating back to last calendar year.  Thou shalt not let down Mr. Excel!  So again, yeah, it was time.

I’ve been heads-down ever since, and the process is now happily in its final phases.  The book will be released Nov 10.

150 Pages?  Bah.

Yeah it’s listed at 150.  That was the estimate that I submitted nearly a year ago.  Then I dug in and quickly started realizing that I needed to exceed it. 

Read the rest of this entry »

Today’s Post Delayed

July 19, 2012


Today Post Delayed, NOT Cancelled, Due to Weather

Yesterday I left Baltimore BWI airport at 11 am heading back to Cleveland.  Like basically all of the East Coast air travelers yesterday afternoon though, I never made it home.

I spent the night in Queens, New York.

So today’s post probably won’t be done until tomorrow, realistically.

In the meantime, here were my attempts last night to make the best of the situation in my usual way – with off-kilter humor:

Read the rest of this entry »

Poll Results

March 24, 2012

Even though it is still open, the one-question poll results have stabilized.  In fact, the percentages were pretty stable even from the beginning.


When I first “opened” the blog more than two years ago, the readership was overwhelmingly “BI” plus a smattering of SharePoint folks.  There weren’t enough Excel folks aware of PowerPivot to really even register back then.

The growth of the Excel audience here from essentially zero to approximately 70% of the readership actually parallels, perfectly, the total growth in page views.

Makes sense.  If you are part of the Microsoft BI community, you heard the PowerPivot message early and often.  The Excel audience is MUCH harder to reach, and has had to discover PowerPivot via social/viral means.

Non-BI = Excel?

Yeah, is that a stretch?  I don’t think so, not at all.  If you are crunching numbers and you are not BI, what are you?  Excel, that’s what.  Or working/researching on behalf of an Excel audience.

What about “Other?”  Those answers were overwhelmingly Excel-focused, too.  Here’s a sample:


One Last Note

How did I perform the analysis?  Why, I exported to Excel of course Smile


…and then into PowerPivot.

What’s Your Background?

March 22, 2012

***UPDATE:  Results summary here.

Gonna do something a little different today.  Blog traffic has been spiking quite a bit and I want to confirm or dispel a theory.

So let’s keep it simple.  A one-question survey.  What’s your background?

Thursday Post Delayed Until Friday

February 23, 2012

Hi folks.  I’m on a plane right now, coming back from conducting another on-site, two-day training session.  Always an awesome experience – it’s seriously something that spoils me.  I like to joke that hanging out with the “early adopter set” for the past two years like I have can give the false impression that the entire world is actually REALLY smart.

Lots of fun quotes from these great folks.  Some that jump out at me:

“Our old version of this report was 22 sheets.  We just got it down to 2.”

“OK Rob, save that workbook right there.  That’s like, ALL of my work for the next two days.”  (Not said in a joking manner).

“Tell ya what, why don’t you just…  put that file on my thumbdrive before you leave.”  (Also not joking).

“The weather in Columbus, Ohio is not bad at all.”  (Ironically, not joking).

“Hey a few of us are going to the bar, wanna come?”

(And if my friends in San Diego are reading this…  no.  Not even close.  But May is just around the corner isn’t it?  I think it’s almost time I come visit again.)

I also got to meet one of our other clients in person on this trip – they very kindly took me to dinner at an awesome burger joint and bar.  Thanks AH and B!  Very nice and intelligent people – even more so in person than in email.

Anyway, it’s midnight and I’m still in the air (flight delayed) with a busy morning.  So I’m gonna give myself one day of respite and go live with a real post on Friday.

Next week, back to Tuesday/Thursday schedule.

Mini Post #2: Mr. XL Launches PowerPivot Forum

January 26, 2012


Click Image to Visit the Forum

The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on  I wasn’t sure what he would say, to be honest.  I mean, he didn’t have a dedicated forum for really anything else – there wasn’t one for VBA, wasn’t one for formulas, wasn’t one for charts.  Instead basically all of those are combined in one single forum.

I respect that approach, really.  If my question involves formulas, charts, and VBA, where would I put such a question?  If he’d segmented the forums like that, it may have fragmented the discussion and ultimately resulted in an ineffective forum.

So I was perfectly prepared for him to say “good idea Rob but I’d rather not introduce noise with a new forum.”  Grudgingly I would have been forced to accept that.  But I was hoping he’d bend the rules just a bit here and make an exception, since PowerPivot still IS very new to the Excel audience.

I was overthinking it.  He loved the idea.  And the forum is already off to a decent start.

So if you have a question, pop on over there and post it.  Also, feel free to answer questions as well – I’m pretty sure I’m going to fall behind soon.

Oh, and be kind to newcomers.  One of the benefits of this new forum is that the legions of Excel pros who frequent will undoubtedly notice all the activity and wonder what this whole “PowerPivot” thing is all about.

Here’s the link again:

Mini Post #1: List of all 300+ posts

January 26, 2012


“I have detailed files.”

A few quick mini-posts today.  First up, I was recently asked if there was a way to see the title of every post and its URL all in one place for reference.  And the answer is…  no, but there should be.

Next week I hope to add a page to the site that provides that sort of index.  In the meantime, here’s a really rough export of all 300+ post titles and URL’s.  It’s not perfect by any stretch but you may find it useful in the meantime.

It is, of course, in Excel format Smile

Click here to download the list of all
300+ posts and their URL’s

On Break for Holidays. Next Post January 2nd!

December 20, 2011


Back in January with Renewed Vigor and Two Posts Per Week!

Well folks it’s been 15 straight weeks of two posts per week (Tuesday and Thursday), sometimes with bonus posts.  Your PowerPivot bloggers are taking a bit of a break over the next two weeks and then resuming our twice-weekly program with a fresh and rested perspective.

In the meantime we may have a bonus post or two, but no guarantees until January 2nd Smile

Have a great holiday season everyone and we’ll see you in two weeks.