skip to Main Content

Just got back from a super intense week at the SharePoint conference in Vegas, where I worked the PowerPivot booth, met a ton of interesting people, and decided that after a weekend of rest, I was going to dive into “that blogging thing.”

I was blown away by what I saw at the conference.  I’ll explain more in an upcoming post, but suffice it to say that even I was surprised (and I work on the PowerPivot team). 

So why blog?  A few reasons. 

1) Quite simply:  PowerPivot, and SharePoint-based BI in general, is going to be huge.  Most of you don’t know me yet, but I am rarely quick to endorse or embrace technology.  Most tech is “guilty until proven innocent” in my eyes :P  So when I’m jazzed about something and thrilled to be a part of it, well, that’s an event in my life.  I’m excited about it, and want to share that with others.

2) I’d love to establish an informal place where people can ask questions about PowerPivot and other SharePoint BI-related technologies. There really isn’t such a place yet, and I think we need one.  A place where we can swap ideas, tips and tricks, and play one of my favorite games, “wouldn’t it be cool if…”

3) Enthusiasts are where it’s at.  In all my years at Microsoft, my favorite thing so far has been meeting Excel power users.  Their enthusiasm and energy for the product, and their excitement at meeting another person who “gets it,” well, I just love that vibe.  I want more of that :)  This is a great way for me to meet more of you gridheads (you know who you are).  But the SharePoint community – wow, the conference opened my eyes.  You folks are amazing, and I’m very happy that you’re integral to the PowerPivot world.  And the hardcore BI enthusiasts – I know you’re lurking out there, too.  Who knows what new reindeer games will we invent while mixing those three communities?  And hopefully this will inspire a new breed of PowerPivot enthusiast, that we will all enjoy interacting with for years to come.  Because fundamentally, life is all about people.  I hope you agree.

In another upcoming post, I will explain my rough plans for the blog for the first month or so.  We’ll take it from there.  If you’d like to know a little bit more about me (most of it on the lighter side), please check out “Who is PowerPivotPro?” above.

But for now… Hello Everybody 🙂

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 9 Comments
  1. Hi Rob,

    Could you please advise me to see my YTD sales value by my country / Category

    because I have created my measure by using Month but it I couldn’t able to extend by Country / Category

    Current Calculation:

    =TOTALYTD(SUM([DLV.QTY]),Table1[GM DATE],ALL(Table1),”12/31/2015″)



  2. This model created using a previous version of the PowerPivot add-in.
    You need to update this data with PowerPivot for excel 2013.
    How I can convert this file in excel 2010 to excel 2013 file

  3. OK, I won’t doubt you anymore. I just read your section “One click that will change your life” related to the OLAP Tools > Convert to formulas. Simply put, that section was appropriately titled! I have been trying to figure out how to do that for a couple of months. I had a specific issue I had to solve today, so that incentivized me to pull out your book that has been in my “to read” pile for a few months. I clicked the button, and issue solved! THANK YOU!

Leave a Comment or Question