August 29, 2013
Intro from Rob: Um, why bother with an intro? Let’s proceed…
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 »
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.
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
July 30, 2013
Guest Instructors for PowerPivotPro School – The “Slow Reveal”
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 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:
Two Revealed, More to Come.
Read the rest of this entry »
July 18, 2013
A rough night here at PowerPivotPro HQ. We suddenly lost the coolest dog I have ever known, the wonderful Mulan:
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.
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 »
June 17, 2013
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.
June 17, 2013
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!
June 13, 2013
Just Me, my Keyboard, and a Triple Grande Mocha
Well, on Tuesday I promised I’d post sometime late on Tuesday. I want to highlight that I got the “late” part right
But I’m back at my desk after five days straight on the road, and WOW am I energized. I came home with LOTS of new things to talk about – techniques, observations, and ideas.
Also, the trip I was supposed to leave for today has been postponed.
AND there are about six people working on guest posts.
So the next few weeks on this site should be very interesting.
But nevermind the next few weeks. There WILL be posts today! I’m settling in and doing nothing else today. Which feels awesome.
June 11, 2013
I’ve got a few mini-posts in my head for today but I’m off to meetings for the day. Check back late tonight
June 7, 2013
Folks, I’m headed into two solid weeks of travel starting this weekend.
If you’d like to pen a guest post, I’d be thrilled to share the space. You can link to your LinkedIn profile, business website, etc. as a fair trade. It just needs to be unique and new, rather than something you’ve posted elsewhere (or will post elsewhere in the future).
- A PowerPivot or related Excel technique
- Your own personal PowerPivot journey – your story of discovering/learning/applying PowerPivot etc.
- A case study
- A rant or manifesto (like this or this)
- Something else that is interesting and relevant
Drop me a note if you are interested. Rob. At a place called PowerPivotPro. Dot com.
(And yes, the existing “family” of guest posters is encouraged to participate of course, not just new folks).
April 30, 2013
Do You Get This Error From Time to Time in Excel 2010? I Do. And it’s Quite Fixable.
This morning, when I loaded up my workbook from last Thursday to start today’s blog post, I got this error.
For awhile now I’ve been meaning to post that this is very “fixable.”
When I opened the workbook, I had a cell in the pivot selected:
To make the error go away:
- Click OK.
- Select a cell outside of the pivot
- Now select a cell inside the pivot again
- Usually the error goes away
Just click OK, Select a Cell Outside the Pivot, Then Select Back Inside the Pivot