PowerPivotPro

PowerPivotPro is Coming to Phoenix

February 20 - 22, 2018

Registration for 2018 Public Training is now open!

AVAILABLE CLASSES

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

FEBRUARY 20 - 21

Foundations: Power Pivot & Power BI

Instructor: Kellan Danielson

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!

  • Learn Microsoft’s secret weapon behind Power Pivot & Power BI: DAX
  • Taught by Kellan Danielson – PowerPivotPro Partner and Vice President of Client Services
  • You don’t need to be an IT professional – most of our students come from an Excel background

FEBRUARY 20 - 21

Level Up Series: Advanced DAX

Instructor: Ryan Sullivan

The Advanced DAX Course was such a hit in the first half of 2017 that we’ve expanded the course to 2 days!

Overview

  • This advanced DAX training class is taught completely in Power BI Desktop.
  • Students are encouraged to take our Foundations course and have hands on experience with the DAX language.
  • Taught by Ryan Sullivan – Principal Consultant.
  • Class material drawn from usage of Advanced DAX applications while consulting with hundreds of international firms.

FEBRUARY 22

Level Up Series: Power Query for Excel & Power BI

Instructor: Krissy Dyess

The second class in the series is our Level Up Series is Power Query for Excel & Power BI.

  • Students are encouraged to take our Foundations course and have hands on experience with Power Query in Excel or Power BI Desktop.
  • Taught by Krissy Dyess – PowerPivotPro Principal Consultant and Phoenix native!
  • We will cover common to unique business challenges made easy with Power Query’s data wrangling capabilities.
  • Intermediate to Advanced Level Power Query best practices distilled into easy to understand patterns to apply to your most common business challenges.
PowerPivotPro Logo

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

Friday Bonus: A Blog Stats “Whodunit?” (AKA “We Are Legion.”)

 
image

A Single Post (the “Cheese” Post About Power Pivot Being Removed From
Most Versions of Excel 2013) Had Its Best Day Ever Yesterday.  Why?

Yesterday I awoke to unusually high traffic on the site.  A single post – Who Moved My PowerPivot Cheese? – was going gangbusters.

What does “gangbusters” mean?  Well, for perspective, let’s check out the Mary Jo Foley Effect:

Read the Rest