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

 
image

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:

http://www.powerpivotpro.com/wp-content/uploads/2013/07/image46.png

FAQ

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 Chandoo.org.  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.”

image

image

image

Read the rest of this entry »


Hablas PowerPivot? (Monday Mini-Post #2)

June 17, 2013

image

This is a Progress Report…  On My Book’s Translation into Spanish!

PowerPivot Education & Training Resource in Spanish!

That’s right folks, Miguel Escobar is translating my book for the Spanish markets of the world, and the process is well underway.  It should be available as an eBook in late Summer or early Fall.

This is one of the many advantages of working with a smaller, more nimble publisher.  Someone suggests an idea, and if it sounds like a good idea, why not try it?  (If you are thinking of writing a book, about anything, talk to me about Holy Macro before you sign with a bigger label.)

Spanish-Language PowerPivot Webinar on June 26-28

Miguel is also running a web-based training course in Spanish over three days starting on June 26:

Click here for info

Como se dice “PowerPivot Pro” en espanol?  Miguel Escobar, obviamente.


User Groups Update (Monday Mini-Post #1)

June 17, 2013

 
clip_image002

Atlanta, Boston, Seattle, Cincinnati, and Madison are Ready, Other Areas Getting Close…
(Blue = Participant, Red = Willing to Organize)
(I’ll post maps of rest of world later)

Just checking in on this…

If you haven’t registered to be notified about PowerPivot/Excel user groups in your area, please do so by clicking the link below:

Yes!  I am interested in a PowerPivot/Excel User Group in My Area!