skip to Main Content


The Gangbusters Hounds Have Been Unleashed to Ramp Up the Floodgates and Blow the Lid Off the Kitchen Sink’s Ceiling

Folks, we needed every cliche in the book today – and then a few that aren’t in the book.  Demand for our services has exploded, and that means we need YOU, yes YOU, more than ever.

The Microsoft data platform has Power Pivot and Power BI.  Other vendors’ platforms…  don’t.  And the world is REALLY starting to understand that to be a very big deal.

For example, as I was writing this, on a Sunday, one of my neighbors (who I talk to about once every six months) pinged me on Facebook and asked if we could help his CFO with Power BI.  Fish are jumping into the boat – even when the boat is docked at the marina.  (I’m really on a roll with the cliches today.)

So…  do you… Savvy the DAX?  Hablas CALCULATE?

If you answered yes to either of those questions, it’s time to open a conversation with us.  See that new link in the header bar?  It went up last week, and some people have indeed been finding it, but please consider this my personal invitation to you…  to click it.



Never Dull, Always Appreciated – and Yes, I Dare Say a Bit Glamorous

There’s an excellent chance that we have the BEST JOBS IN DATA.  Not kidding – our newest hire keeps telling me “I can’t believe I am getting paid to do this.”

And I get it!  At PowerPivotPro…

  • You never get stuck doing the same thing for months (or even weeks) on end.  A variety of exciting new challenges keeps the mind engaged, and that’s every single day for us.
  • The clients are AMAZING.  Almost by definition, we are only working with the nimble organizations, the ones that are willing to embrace a new and better way.  I tell people all the time that I have a “positively-skewed view of humanity” because of our clients. 
  • The clients LOVE you.  We’re taking away their pain, giving them amazing results and capabilities, and doing it without stealing their wallet.  They want to hug their consultant, which is atypical in the consulting industry – particularly in the BI and analytics industries.
  • You are ALWAYS learning.  That same variety of challenges sharpens the brain as a side effect, but you also get access to the rest of our team – on Slack, Skype, and at company events like the MDIS conference in Seattle in June – and we are always bouncing questions off of each other, sharing nifty solutions, etc.
  • Your commute involves a hallway or two, maybe a set of stairs.  On the average day at PowerPivotPro, you are working from your home.  There’s no office to drive to, no rush hours to fight, no expensive and laborious business attire to maintain.  And the workday has quite a bit of flex in it, so if you need to take your kids to school or run an errand or two, you don’t have to sneak out or deal with raised eyebrows.  Yes, we DO travel to clients, too, but…
  • You pick up incentive bonuses for onsite client work.  You should plan to travel at least once per month, and typically, that’s a 2-day client engagement.  But if you travel more than 2 days per month, we offer an aggressive bonus ladder – think of it as real-time profit-sharing.  And we’re not talking chump change here – if you were so bold as to max these out, it’s an additional six figures per year (no, not a typo).

All “Growed Up”


imageThe other day, I was on our weekly web meeting with our leadership team, listening to everyone’s updates, when I interrupted and said “folks, I would NOT want to compete against THIS crew.”  And I meant it.  If you’re reading this, and you run a company that operates on the Old Way of BI, we’ve assembled a crew that is going to make your life very difficult in the coming years.  Good-naturedly, of course, and for the betterment of humanity, but yeah, we’re coming Smile

The idea for this company struck me all the way back in early 2010 – back when all I had was a blogging website hosted on  It’s been a long road to make it a reality – one paved with the usual difficulties for sure, but also with the assistance of some amazing people.

Seven years later, it’s a full-fledged reality:  An executive leadership team that warranted our first-ever planning retreat in Vegas this January.  Real health insurance.  A culture that has grown beyond my tight control – a living thing that makes me feel proud rather than wistful.  Those antiquated workplace posters of yesteryear that must be displayed prominently in the workplace (so we posted it to Slack).  Monthly company meetings (virtual).  Annual company meetings (in person, we do them at MDIS).  Revenues in 7 figures.  And ambitious plans to add that 8th figure, of course.

“Is the Interview Challenging?”

Of course it is! We can’t be a nationwide team of data ninjas if we’re not, you know…  ninjas.

But how good is good enough?  It’s very hard to tell, right?  I get it.  So here’s a quick little “thermometer” you can use to get a slightly clearer sense…

…a Screener Question!

Let’s say we have a DAX measure:

[Max Date]:= MAX(DatesTable[Date])

If, in another measure, I then use it the following way:

FILTER(ALL(DatesTable), DatesTable[Date]<=[Max Date])

But then, I try this instead:

FILTER(ALL(DatesTable), DatesTable[Date]<=MAX(DatesTable[Date]))

And they DON’T give me the same results, which is really weird right??

Off the top of your head, if you “get” this, and know why the two behave differently, I encourage you to apply.

If you don’t know why off the top of your head, you’re not likely to perform well on our interview yet – circle back with us when you ARE ready, because even I was in your shoes not too long ago!

imageParting Question:  Where are the Women?

Historically, about 80% of our applicants have been men.  Does that surprise you?  “Oh sure, no surprise,” you say.  “It’s a tech field, blah blah blah…”

WRONG.  The disproportionately-male demographics of the “tech” industry don’t remotely hold true in the world of data – at least not in our experience.  Quite the opposite actually.

The classes we teach are often more than 50% female, and a woman is the brightest student in each class at the same rate.  I love that, because it DOES fly in the face of the tech industry’s demographics.  I have theories about why “data” seems to cut across gender lines much more evenly than, say, Java programming does, and the short version is this:  when it comes to tech, on average, women may just have more sense than men.  “Tech for tech’s sake” is, in my opinion, a fool’s errand, and if my theory is correct, it’s a credit to women that they don’t fall for it.  Why and when did we ever decide that something as meaningless as Java programming should be held in high regard?  Why are we constantly trying to encourage women to follow the men down that silly rathole?  Maybe women have had it right all along.

It’s an admittedly optimistic theory, because the hostility that women encounter in the software industry is quite real, as is the discouragement they receive in school.  I have zero desire to downplay or whitewash that reality.  Whatever the reasons, I’m glad that it seems to be different in analytics.

A PivotTable, as one contrast to the pursuit of generic “programming,” answers a question.  It tells a story.  It saves tremendous amounts of time and manual labor.  It has tangible value – a human purpose, and we want to be around people who are drawn to THAT, whether male or female.  And in our experience, women are at least as clued in as men on this front.  Slightly more so, actually.

So ladies…  let’s hear from you.

Rob Collie

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 17 Comments
  1. [Matt explained the Screener question in his comment but it’s not about proving it to US, it’s about answering honestly for YOURSELF. We now resume the rest of Matt’s comment. And I’m glad it’s tempting Matt! -rob]

    But I already have a good job and not looking to change…but looks tempting.

    1. Oops. Sorry didn’t mean to spoil the answer for others. Didn’t think it would hurt.

      I do envy you guys a bit; working with Power Pivot/Power Query/Power BI is fun and i wish i had more time to do so with my current role. 3 years later after starting to work with it and i’m still amazed how extensible and flexible a reporting tool it is. Good luck.

  2. Power BI is definately changing. We’re now live, that only took 12 months (the data model was ready 9 months ago) of wrangling over “can we put data in the cloud”… “is it safe” and of course my favourite “Oh Power BI is only a beta product”.

    Great to see the platform grow and great to see you’re going from strength to strength. Congratulations Rob.

  3. Just to make it interesting

    FILTER(ALL(DatesTable), DatesTable[Date]<=Calculate([Max Date],DatesTable))
    and everything is fine again !

    1. Just to make it interesting++

      FILTER(ALL(DatesTable), DatesTable[Date] <= Calculate(Calculate([Max Date],DatesTable)))

      … and everything is in balance according to the original test ;-D

  4. Ha! This is funny.
    Have looked since Matts comment no longer exists and am racking my brains as to what’s going on!

    Can someone email me and put me out of my misery. [email protected]

    I am new to dax and am learning every day! Have bought Robs book to!

    Rob – are you looking for people in U.K. too?


  5. Not ready for this now, as I’m new to PowerPivot, but in a year or so…. I love that your customers love you. It must be fun spending your time helping other people achieve their business goals.

  6. From Singapore seeking rescue from stable accounting job.
    Believed i passed the screener but just going to leave this comment here because “Join Our Team!” is too intimidating.

  7. I am working with this stuff for years in my company (i am CFO),and i must admit that i love it.
    I would like to improve and work on real datasets, and maybe work Freelance later.
    For now, if you have real projects, i work for free on my free time.

Leave a Reply

Your email address will not be published. Required fields are marked *