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 first thing you need to know about the "PowerPivot" Data Model is that there are TWO primary places where you can find it:

Excel PowerPivot

Power BI Desktop

And while those two may LOOK different on the surface, they are very much the SAME under the hood

Excel PowerPivot

Power BI Desktop

When you learn one, you’re learning them BOTH

The differences between the two are purely cosmetic.

Anything you build in an Excel Data Model can be converted to a Power BI Desktop Data Model with just a few clicks – because they use the same engines and languages!  (Some of the visuals might not translate over, but those are quick to recreate.  It’s the brains of your models that are important, and those transfer effortlessly.)

OK, how is PowerBI.com different from Power BI Desktop?
What Is Power Pivot Power Bi 7

CREATE with Power BI Desktop

Power BI Desktop is where you CREATE models and dashboards.

What Is Power Pivot Power Bi 6

SHARE with PowerBI.com

PowerBI.com is where you PUBLISH and SHARE share those models and dashboards.  Then, others can view and interact with those dashboards in their browsers and, even better, on their mobile devices.

Can I also publish Excel Reports to PowerBI.com?

The answer is the SAME for Excel Reports vs. Power BI Reports– you BUILD either in their respective desktop app (Excel or Power BI Desktop), and then you can PUBLISH them to PowerBI.com.  Excel reports get published to a section called Workbooks, and Power BI Desktop reports get published to a section called Reports.

But with Excel reports, you also have the option of “on premises” SharePoint as your publishing platform, so if you’re not ready for the cloud, this might be the right path for you.

More Reading

This is about right for a high-level summary, but if you’ve still got questions, here are a few additional pages/resources that you may find helpful.

And you can always simply proceed to getting the software…

UP NEXT: Get the Software

What is PowerPivot?
Explains why Excel PowerPivot is such a life-changer over traditional Excel alone.  (Yes, it’s written from the Excel PowerPivot perspective, but it still explains the original and most central of the Data Model Engines – the DAX formula and modeling engine – in a manner that’s relevant to Power BI Desktop.)

Transitioning from Excel PowerPivot to Power BI Desktop
Drills down on the similarities between the two environments.  For more on the strategic reasons why Microsoft has two environments, see What is Microsoft Up To?