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

Tuesday and Thursday Posts on DAX, Power BI, Power Query, and Other Data Topics - FOREVER
Go Ahead.  Hold us to it.

A long, long time ago…

On September 5, 2011, I announced an ambitious initiative:  I committed to a blog post EVERY Tuesday and Thursday, indefinitely.  At the time I wasn’t sure if I could sustain it for more than a month or two, but a funny thing happened and I sustained it (with some help for sure) for about four solid years.  At that point, the pressures of running a full-on consulting company “overflowed the river banks” and our regularly-scheduled program petered out.  But those were some glorious years, and I credit that clockwork, “come-hell-or-high-water” schedule for a lot of the growth of this site (and subsequently, our company).

Loosely, this is Latin for "Every Tuesday and Thursday, There WILL be DAX!"We are bringing back that promise

Beginning this coming week, you will see posts go live here EVERY Tuesday and Thursday morning.  From now until the end of time.

You see, the same thing that distracted me from the schedule in the first place (having a company that depends on me) has also become a massive advantage.  We have many amazing people here on staff – people with with amazing stories and techniques they can share.  We have the ability to hire an editor to keep the quality bar high when I’m not available.  We have someone who can “whip” the schedule and make sure we hold true to our promise.  And yes, that whole process ALSO can hold ME more accountable, so that I myself post more frequently as well.

(Speaking of the advantages of being a robust consulting company, have you considered hiring us to implement some kick-ass analytics for your firm, and/or adopt an empowered, non-dependent, business-driven data culture?  No one does it better or more rapidly than we do.  Not even close.)

This morning we held the final kickoff meeting for this new process.  The team is in place.  We already have a healthy series of posts in the hopper awaiting finishing touches.  It’s go time.

So, while I hate comparing myself to Longshanks, and certainly don’t condone HIS policies, well, the first part of the quote is just too perfect, and it forced me to learn some rudimentary Latin which can’t be all that bad.

Why ANNOUNCE this?  Why not just DO it?

Two reasons.

1) I want YOU, dear readers, to be able to depend upon this.  I’ve been listening to podcasts lately and have really grown to love even just the “looking forward to the next one” feeling.  I want that feeling for OUR data community.

2) Once we commit, we can’t go back.  So I’ll leave you with one last movie quote…

We're Burning our Ships to Bring You Amazing Power BI Content on a Regular Schedule

See you Tuesday… Smile

  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. I can’t wait for the content. You’re website and book (along with the Italians, Webb, and Allington) has propelled my career from being a teller to being a finance manager now. But I think you need to throw in some “A Few Good Men” quotes in there. But Braveheart and Hunt for Red October are pretty strong.

    1. What a great example of how the Power tools can lead to incredible results. You completely changed the trajectory of your career – Way to go Andrew!!

  2. Super excited about this! I still find myself checking the blog at least once a week and being a little sad if there isn’t a new post.
    You and your team have a wealth of knowledge that needs to be shared.
    Now I have something to look forward to during my morning coffee twice a week!

  3. Excellent! My pace at advancing in all these tools is directly tied to the rate of blog posts from you, Ken Puls, and Matt Allington so keep ’em coming (grins)!

  4. I’m learning (very s-l-o-w-l-y), but you’ve proved to me that DAX, PowerPivots, Power Bi, and PowerQuery are THE tools to become a master of. I come to this site daily looking for new blog posts, and catch up on the older posts to help me learn more. I’m still dreaming of the day you’ll be recruiting staff in Europe (UK) and wish that one day I can join your team. Keep up the great work. I never thought that Excel could get me this excited after all these years!

  5. Congratulations, Rob, on succeeding through the growing pains. Your commitment to do what you once said you were going to do demonstrates the credibility your service is known for.
    The PowerPivot community has benefited from your contributions. Thank you and well done.

  6. This is great news. In 2001 I had never heard of Power Query/Pivot/BI or DAX so I can’t hold you to that commitment – but this is 2017 and I am thrilled to read this!

Leave a Comment or Question