PowerPivotPro

PowerPivotPro is Coming to Boston

May 15 - 17, 2018

AVAILABLE CLASSES

**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!

Overview:

  • 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!

Overview:

  • 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!

Overview:

  • 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
Share Your Story Or Technique Here On PowerPivotPro!

Share your story or technique here on PowerPivotPro!

Talk About Your Personal Journey OR Share a Technique – Either Way, it’s Time YOUR Voice is Heard Are you ready to see your name in lights? Hi folks!  I know, I know…  long time, no write.  I’ve been busy,…

Read the Rest

Black/White Decisions in a Greyscale World

Post by Rob Collie

image

     JACK RYAN:  “…with them in the same place, the odds of coincidence are
     dropping fast. Still, there’s no way I can be… absolutely certain.”

     ADMIRAL GREER:  “Excuse me, Jack.  Tell me one thing in life that IS
     absolutely certain.  What I need to hear is your best guess, and I think
     I’ve heard it.  Haven’t I?”

Belatedly Reviving a Thanksgiving Tradition

In past years I occasionally took Thanksgiving Week as an opportunity to write some more “thoughtful” things, such as The Cult of the Right Thing.

This year, I would like to share something more “on topic” than any of the previous ones, while still very much fitting the theme of thoughtful/reflective.

An Exchange in “Patriot Games” Captures It

The conversation pictured above, between Jack Ryan and Admiral Greer, was pretty much lost on me the first time I saw Patriot Games in 1992.  It’s a relatively “bland” exchange.  No emotion, no drama, no action.

But in subsequent viewings, that brief little clip etched itself in my brain.  It captures something CRUCIAL about being a human being, regardless of what you do for a living.  But for those of us in data-driven professions, I think it’s even MORE relevant.

WHY is it so crucial?  Well, let’s start with Left Brain and Right Brain…

Left and Right Brain:  A Powerful Alliance

image

 

Read the Rest

Holiday Bonus Post: Mobile Frame Zero!

Let’s Say You’re a Big Nerd…

…and you haven’t spent enough time with your kids over the past year.  Looking for a good way to spend many quality hours with the brood?

I give you…  Mobile Frame Zero.  (And if you’re not a big nerd, well, you may just want to stop reading right now).

image

A Game Where You Design and Build Your Own “War Mechs” Out of Legos?  Yes Please.
(My Mechs on Top.  My Son’s on Bottom.)

A 100% “Open Source” Mech Game That You Can Play for Free??

For nearly 30 years, I have been aware of games like Warhammer – epic tabletop nerd games – and wanted to at least try them.  But they are SUPER expensive.  You can rack up thousands of dollars buying the miniatures, and then spend forever painting them.  So, um, no.  I’ve stayed away.

But what about a mech game where you make your own miniatures out of Legos???  Pure freaking genius, especially considering that the people reading this post ALONE, in total, probably possess millions of unused Lego blocks.

Well, the creators of Mobile Frame Zero weren’t done there.  They also made their RULES free to download!  Optionally, you can choose to pay them $10 for the PDF, kinda like a donation.  Or you can buy a physical copy of the rulebook, like I did.  But they are VERY clear that they do NOT mind you downloading the game for free.  Put that together with the Legos you already have and you’re ready to play.  (Well, you need some dice too, but keep reading for a hookup).

Read the Rest