PowerPivotPro is Coming to Boston

May 15 - 17, 2018


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

MAY 15 - 16

Foundations: Power Pivot & Power BI

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
Boston Public Training Classes - PowerPivotPro
Boston Public Training Classes - PowerPivotPro

MAY 15 - 16

Level Up Series: Advanced DAX

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.

MAY 17

Level Up Series: Power Query for Excel & Power BI

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
Boston Public Training Classes - PowerPivotPro
PowerPivotPro Logo


Getting that “Goldilocks” Blend of Human and Tech Requires a Special Touch

***Update Oct 23:  Applications are Now Closed

Folks we got an overwhelming response to this opportunity – both in quantity and quality.  Several dozen AMAZING human beings have applied (including seven TODAY), and sorting through all of that top-notch humanity is a task that must be treated with respect.

For that reason, I’m closing the job to new applicants.  If for some reason we don’t find the right person in this wave (HIGHLY unlikely given the look of it), or if we find we need additional editor/writer types (more likely), I will re-open it.  But for the moment, to be respectful of everyone’s time and energy (including mine), we’re gonna close it down.

I Wanna Teach You to Be “Me.”

SEVENTEEN.  That’s the number of articles/posts that are currently sitting in Draft status behind the scenes here at PowerPivotPro, waiting for their chance to go live and educate/invigorate the community.

Seventeen is ALSO the number of articles sitting on my plate for review and editing.  This is not a coincidence.

SEVEN:  that’s how many authors we currently have (other than myself) who are chomping at the bit to get their aforementioned articles flipped “live,” and ALSO chomping at the bit to write MORE awesome stuff.

INCREASING:  that is the direction that this is all headed.  I’m never gonna get caught up on those seventeen articles, much less keep up with an ACCELERATING pace.

So, I wanna grab YOU.  Maybe you consider yourself a diamond in the rough, an aspiring techno-human-communicator who just needs a “shot” to show the world what you can do.  Or maybe you’re already a paid professional communicator in some regard, like a published author, or part-time editor, but that is SO NOT REQUIRED.  Remember, *I* had never written anything publicly until starting this site.

I want to teach someone how to enforce my standards, essentially, and then pay them to be the Editor/Reviewer of all the other articles we want to go live.

Click here if you’re already like, “HECK YEAH ME ME ME!!!”

“What does this job entail, exactly?”

It’s a brand-new, paid, part-time position.  You can do this job from anywhere in the USA or Canada.  It’s all remote – email, phone, GoToMeeting, Skype, etc.

It does NOT have to be done during 9 to 5 hours.  It would be NICE if you can occasionally send an email to keep things moving during the day, or occasionally chat about something, and we WILL give stronger consideration to people with more flexible arrangements, BUT being the “right” person for the job is more important than time of day availability.

The job starts out working directly with me:  first I’ll “knowledge transfer” (from my brain to yours) a bunch of what I believe to be important.  You get to ask me questions, we clarify, etc.  Then you and I will look at a draft article together, I will give you my feedback on it, and you will then work with the author of said article to tighten it up before it goes live.

In the early going, my expectation is that you and I will then touch base AGAIN after that first round of edits with the author.  I’m definitely OK with a second round of edits, especially in the early going.

Over time though, as you gain confidence, the goal is to have me become less and less involved, and eventually you will be acting with full autonomy.

The sorts of changes that we typically make to an article:

  • Is it clear?  Is it explained thoughtfully enough from the readers’ perspective or does it assume too much, skip important steps, etc.?
  • Similarly, does it convey WHY the reader should care – either about the entire article, or about a specific section?
  • Is the article pleasant to look at?  Are there sufficient images to break up the “wall of text” appearance?
  • If we’re embedding a dashboard or other file, does it follow our normal template?
  • Is there a completely different approach to this article that would be SO MUCH BETTER than we just can’t help changing gears and going that direction?
  • Are the i’s dotted and the t’s crossed?  EX: are Category and Keywords set?  Are there standard blog elements that are missing?

In some cases you will be able to make required edits yourself, directly.  In other cases, you will need to get the original author to make the edits (this is quite common when we need additional screenshots, or a formula needs to be better-explained – but I, the editor, don’t really understand it well enough myself to write said explanation heh heh)

Is there an interview?  What are the requirements?

Yep, there’s an interview, but it’s gonna be FUN.  And it’s with me – mostly written of course, since that’s the primary skill, but nothing too heavy.

I don’t want to be too terribly specific about prior experience etc. – primarily, you need to have “it,” and prior experience is only loosely coordinated with “it.”

Here are some must-haves however:

  • You have to be good at writing, and enjoy it.
  • You have to be good with people, and understand that “information broadcasting” and “getting people to understand” are NOT the same thing.
  • You have to use our toolset, at least lightly.  Meaning, you know what DAX is, and have probably written a CALCULATE in the past month, but you do NOT have to be a DAX Jedi.
  • You have to be smiling right now while reading this.  A quirky zest for life is a sign of compatibility Smile

Click Here to Apply 🙂

  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 5 Comments

  1. Hi, would you only be considering applicants from the USA or Canada, it is not listed in your ‘Must-Haves’ but it seems implied earlier on in your article. I’m based in London but have a degree of flexibility and would be interested in applying for this role!


  2. I’m impressed by your blog posts, but don’t always understand them. I hope PPP can take a step back, realize that big dumb Swedes like me are just beginning to grasp the basics, and take a more crawl/walk/run approach to posts.

    Shout out to Chandoo who regularly uses this approach.

    1. Here’s the basic idea and how you can use it right now today.
    2. Here’s some more advanced stuff that makes it even more powerful.
    3. And if you really get it, then please try this huge trick that will save you mountains of effort and time.

    You know, it took me six months to figure out I could reuse measures in a calculate statement?

    I’m hopeful this is received as useful and constructive criticism. Folks like me need folks like you. 🙂



      1. No worries.

        I’m serious that folks like me need folks like you. Less so for me now, but how many times have I known it’s possible to do with DAX, and yet due to lack of documentation, revert to lengthy clumsy in-cell Excel formulas?

        But simple concepts like “write one formula and use it 100 ways” are difficult to conceive of for self-taught excel junkies just getting their feet wet with DAX.

        Microsoft gave the world a gift, but not enough effort has been placed on helping big dumb Swedes like me learn the basics of … well… data architecture.

        Thanks for all you do. I really appreciate it.



Leave a Comment or Question