PowerPivotPro is Coming to Houston

April 17 - 19, 2018


**Use the discount code “3ORMORE” when signing up 3 or more people.

APRIL 17 - 18

Foundations: Power Pivot & Power BI

Instructor: Austin Senseman

Super charge your analytics and reporting skills with Microsoft’s dynamic duo. Designed to handle huge volumes of data, these tools will transform the way you work. Two Days in our class and you are EMPOWERED!


  • Not just the “hard” skills, but also the “soft” stuff (when and why to use it, how to get the best results for your organization, etc.)
  • Learn Microsoft’s secret weapon behind Power Pivot & Power BI: DAX
  • You don’t need to be an IT professional – most of our students come from an Excel background
PowerPivotPro Training Classes - Houston
PowerPivotPro Training Classes - Houston

APRIL 17 - 18

Level Up Series: Advanced DAX

Instructor: Ryan Sullivan

Foundations taught us how to remove repetitive, manual work and make impactful insights. Advanced DAX is about making it rain money by better informing decisions!


  • Taught completely in Power BI Desktop
  • If Foundations is a 101 course, hands-on work experience with DAX is 201, and Advanced DAX is 301.
  • This class will teach you how DAX really works, how to build complex reports that are still digestible, and how to use that information to drive your business.


Level Up Series: Power Query for Excel & Power BI

Instructor: Ryan Bergstrom

Copy-paste? Dragging formulas down? SAME THING EVERY WEEK?… No more. Teach your computer how to build your reports for you. Set and forget!


  • This class will teach you how to connect to all of your data (no matter where it lives), shape it so DAX can run automagically, and have your computer remember the steps so you never have to do it again.
  • You don’t need to be an IT professional – most of our students come from an Excel background
  • Taught simultaneously in Excel and Power BI
PowerPivotPro Training Classes - Houston
PowerPivotPro Logo


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 WordPress.com.  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.

  Subscribe to PowerPivotPro!


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 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 Comment or Question