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

Compulsive Data Crunching Disease Pt1 (Relevant Even if You Don’t Like Football, I Promise!)

 
image

This spreadsheet-wielding Scrooge was the logo of my fantasy football team (“Mighty Ebenezer”) circa 2001.  Yes, I had this art custom commissioned for that purpose.
Yes, that is really, REALLY sick.  And simultaneously PURE FREAKING AWESOME.

Let’s start here:  Football Season is Spreadsheet Season.  Yes, even more spreadsheets than usual, even for me.   And football season starts tonight here in the US.  So it’s high time I tell you this story.

Even if you don’t care about American Football, or sports in general, I suspect you may still find the story itself to be interesting.

Deep down, this story is actually about a trait shared by probably everyone reading this.  And there is a TWIST in this story, a BIG one.  So go get another cup of coffee.  I will wait.

Scene:  Rob Collie, 1996-1997.  And Lots of Losing.

My Microsoft Badge Photo – Taken at New Employee Orientation, July 22, 1996My Microsoft Badge Photo – Taken at New Employee Orientation, July 22, 1996

I started at Microsoft in July 1996, fresh out of college.  I was raw, lazy, and unskilled.  I had never really applied myself to anything.  I had a computer science degree but had scrupulously avoided learning how to program.  I got the job largely because I was decent at logic puzzles, which were the MS interview du jour.

Read the Rest

Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect

image  image

Excel on the Left.  Other Data Tools on the Right.

Today I’m going to “get my nerd on” in a big way.  Buckle up.

The genesis of this post is an email I’ve been meaning to send to my contacts at Microsoft – one I’ve been thinking about writing for at least a year.  But I also figure it’s the sort of thing you folks might find interesting, and I really don’t have time these days to write the same “opus” twice, so here goes – two birds with one stone.  And it’s a friendly stone.

Has there ever been a tool as flexible as Excel?

Let’s take a moment and just marvel at Excel’s “range.”  (VBA macro programmers – yes the joke is intentional).

You can do damn near anything in Excel.  Calendar chart visualizations.  Music videosBeautiful artMore music videosRespiration wavelengthsChess gamesWord clouds.

But those are just the outliers really – the novelties.  The truly valuable examples are much less dramatic and happen hundreds of thousands of times every day.  I’ll give some examples in the next section.

Feature A Was NEVER “Intended” to Be Used With Feature B!

image

“Hey You Got Your Slicer in My Conditional Formatting!”
(And then the whole jar fell into a bucket of DAX)

Read the Rest

Rob Collie’s Real Microsoft Stories: Paper or Plastic?

A “Chuckler” of an Interview Story

My use of “paper or plastic” in today’s post reminded me of a funny story from Microsoft.  There was a manager in Office who used to sit across the hall from me in the late 90’s – let’s call him DH.  He was famous for being a tough interviewer.  And I don’t just mean tough in the “only good candidates got by him” sort of way.  He was tough in ways that went above and beyond the call of duty.  In fact, on at least one occasion he made a candidate cry.  (Not a good thing).

But this isn’t about one of those times.  This particular story is about what happened when a particularly eccentric candidate crossed paths with that draconian interviewer.

Read the Rest