See You in 2015!

December 16, 2014

Post by Rob Collie


On Hiatus (from Blog Only) Until 2015

After 120+ published posts in 2014, we’re gonna give our blogging energies some much-needed recuperation time from now until the end of the year.

But that doesn’t mean we are resting!  Far from it.  Lots in the pipeline for early 2015, including a full “reboot” of this website in terms of its design and capabilities.

The rest of the “biz” stuff is also continuing without interruption.  Work with clients, the Online University, everything like that basically continues unabated.  Secret projects as well – we always like to have a few of those simmering at all times.

See you in January. Smile

Help Us Design Our 2015 In-Person Class Schedule!

December 10, 2014

Post by Rob Collie

Seattle?  Cleveland?  Elsewhere?

Hi Folks, we’re already starting to plan our 2015 class schedule and we could really use your quick input.

By default, we plan to offer classes in Cleveland and Seattle.  Cleveland classes will be taught by Rob, and Seattle taught by Avi (who has already worked with double-digit clients, including five onsite trips, and just overall been blowing people’s doors off).

But we don’t know whether, for instance, we should be scheduling CLE and SEA for the same month.  Nor do we know what 2-3 “hot spots” we should try to visit outside of those two obvious “home” cities.

Only the first question is “required” – the other 4 are purely optional.  Many thanks!

The Ultimate Date Table–Revisited

February 27, 2014

Guest post by Dominik Petri, who I am stoked to say is translating the book into German!  Today he shares a cool “hybrid” technique that blends two of my favorites things – Data Market and Power Query!

Take it away, Dominik…

Selecting a DateStream calendar from Power Query Navigator taskpane


As you might already know from Rob’s “The Ultimate Date Table” post, you need a separate calendar table to unleash the power of Power Pivot’s time intelligence functions. You want one for free? Fully customizable? Running up to a variable end date? Updated automatically every time you open your workbook? The time has come…

Get a great calendar table – for free

Boyan Penev has put together various calendar tables that you can download from Azure DataMarket directly into Power Pivot – for free. Again, see Rob’s postfor details. So far, so good. But it is a pain to filter the data range you want to import. But there is Power Query!

Read the rest of this entry »

Two Quick Updates: University Re-Launches Monday. And Power Query is Amazing. AMAZING.

February 6, 2014

Busy Day Today!

What can I say folks.  The Power Pivot “biz” continues to gain steam (one indicator:  last week recorded the highest traffic ever to this site) and that means busy days here at PowerPivotPro HQ.

So I will keep this brief.  First a quick note about the University, then read on for Power Query!

Read the rest of this entry »

Comments should be working again

January 10, 2014

For some reason, no one has been able to successfully submit a comment on this site since Jan 1.  I didn’t realize this until yesterday – I just thought people were unusually quiet to start the year.

This should now be resolved.  Let me know if you submit a comment and it doesn’t show up (and doesn’t tell you it’s marked for moderation).

See you in 2014!

December 17, 2013


Second Xmas Tree – Just Deployed by Santa’s Tree Ninjas at PowerPivotPro HQ

That time of year to rest.  And run around like crazy.

Well folks what can I say.  One heck of a year, this 2013 thing.  And it’s ending on a hectic note – this week I am conducting 3.5 full days of trainings, AND then driving to Chicago.

imageAnd, as pictured above, deploying last-minute “backup” Xmas trees.  You know, the one my wife saw in the movie “Elf” the other day and said “ooh I want one of those someday.”

So she went out to her boxing class tonight and I quickly deployed the tinsel tree that I cut down this afternoon in the tinsel forest.  Let me tell ya, tinsel trees are tough to cut down.  Let’s hope she likes it.

Pretty standard stuff really.

I already see the page view stats doing their standard year-end tapering, so I think it’s time to close up Santa’s PowerPivot Shop until the New Year.

If I get time during the upcoming two weeks to write one of my off-topic holiday posts, I’d very much like to do so.  But I can’t promise to do anything really other than to lay low for a bit.  And catch up on my email.  And prep for big stuff that I want to roll out in the new year.  And drive all over the Midwest, in the passenger seat, with a laptop and a cell phone hotspot.

So if I don’t see you until then, happy holidays / new year to everyone.  Thanks for reading and making my job so much fun.

Oh, and if you’re into 100% politically incorrect, Not Safe For Work Christmas humor that still (IMO) doesn’t cross any truly important lines, I highly recommend checking out this comic from my heroes over at Penny Arcade.

And if you were/are an epic Dungeons and Dragon nerd growing up (like me!), definitely check out How the Illithid Stole Christmas.

Modelling condoms power!

August 29, 2013

Intro from Rob:  Um, why bother with an intro?  Let’s proceed…

Condom Power (Pivot)

Olgeta! I’m Tim Siegenbeek van Heukelom (Twitter, LinkedIn, Blog) and work in the public international health field as program analyst for the Oil Search Health Foundation in Papua New Guinea (although most of the time I work from Sydney).

Part of my job is to create reports from the vast amounts of public health data the Health Foundation produces and/or keeps track of. For instance, I try to make sense of our HIV testing-, malaria diagnosis- and condom distribution data and measure it against performance indicators and targets.

In this post I will discuss one of the examples from Rob’s blog. Remember ‘Modelling Viral Growth’? This is an addendum, based on real-life application and modification of the model.

Read the rest of this entry »

Measure Calculation and the CALCULATE Function

August 6, 2013

Excerpts from PowerPivotPro School

Since it’s been the primary focus of my time lately, for today’s post I thought I’d share two excerpts from the upcoming PowerPivotPro School.

Intro to CALCULATE()

The first one is the complete and uncut introduction to the CALCULATE function:

That’s only the intro of course.  There is a lot more on CALCULATE obviously.  Even the “basics” consume quite a bit more time in the course, but I thought you’d like to see this first part.  I hope it helps some of you even if you don’t choose to join the course.

How Measures Are Calculated – Three Minute “Montage”

Chronologically, this clip occurs before CALCULATE in the course.  This is from the module called “Warmup and Fundamentals.”  It’s 3 minutes of “highlights” spliced together from a longer, 20 minute section:

Whereas the first video above is at “normal speed,” this one moves faster simply because I’ve edited out a lot of the more complete description and background.  The actual course moves more deliberately.

Sign Ups Open Until August 15th

If you’re interested in joining us for the course, signups remain open until August 15th.  Hope to see you there:


I’m getting a lot of questions about how the course is structured and delivered.  I’m compiling a FAQ and should post that tomorrow.

Bluehost Outage

August 2, 2013

Every website hosted on BlueHost was out today for 90+ minutes.  Fantastic eh?

We will now be evaluating a new web hosting service.  Bluehost was great for about 2 years.

And no, it wasn’t TheExcelAddict’s link that brought it down.  That would be much cooler Smile

Updates: PowerPivotPro School, User Groups, Book

July 30, 2013

Guest Instructors for PowerPivotPro School – The “Slow Reveal” Smile

Today’s Internet-powered world is a very cool place.  I’ve made some amazing friends over the past few years – people all over the country and all over the world.

And that network of friends will benefit you, too, because they are graciously volunteering to teach guest modules in PowerPivotPro School Smile I’m not going to announce them all at once, because suspense is fun and I’m still finalizing the roster, but today I’m announcing two: 

Guest Instructor Bill Jelen, aka MrExcel.Guest Instructor Zack Barresse, International Man of Versatility.

Two Revealed, More to Come.

Read the rest of this entry »

No Post Today

July 18, 2013

A rough night here at PowerPivotPro HQ.  We suddenly lost the coolest dog I have ever known, the wonderful Mulan:

The PowerPivot Puppy

Mulan Saying “You gave me this treat, but there’s no way I’m eating it outside like a savage.
Let me inside so I can eat like a civilized person.”

I known it’s cliché to say “coolest dog ever,” but for point of reference, we have two other dogs too, and we love them dearly, but Mulan was far and away our favorite.  The other two dogs are dogs, which I consider to be one of the highest compliments one can bestow on an organism.  But Mulan was a person in a dog form factor.

Anyway last night’s ordeal sets back the schedule a bit.

In the meantime there is something very interesting being announced over on  I’ll have more – lots more – to say about that soon, but can’t do it justice today.

How to Wreck a Knee In Four Easy Steps

June 24, 2013

So.  You’ve just turned 39 years old.  Your wife has just turned 38.  It’s her birthday and she wants to go to a trampoline park.  WHAT COULD GO WRONG?  Nothing…  nothing that is, until you’re about to leave and decide, “hey, one more time for the camera so the kids can see how much fun this was.”




Read the rest of this entry »