This post is just a list of what helped me grow my Power Pivot skills… well, other than trial by fire. If I have missed any awesome resources, let me know in the comments! Blogs powerpivotpro.com : Rob Collie. One of my oldest friends, mentor and how I “got into” Power Pivot… and still… I get amazed by how much content is on his blog. “Oh crap, how do I calculate compound interest… <web search> … oh, of course Rob has an entry for that”. This is the Every Continue Reading
Two methods to calculate Person-Hours
The point of this post is not really calculating Person-Hours. I mean, we will show some measures on that, and if you got here by searching for that, and I helped you… ROCK ON! I’m happy to help. But… I kind of thing there is value in just… talking about any old measure. Getting some reps in. Getting’ your learn on! Though, in this case, it will have a performance slant to the discussion, which is becoming a theme on this blog. “People need to be reminded more often than they need to be Continue Reading
Script Update: What is Eating Up My Memory in Power Pivot?
As referenced in my previous post, the numbers I was getting for memory usage from Kasper’s VBA Script did not make sense to me. After taking the time to better understand how Power Pivot stores data… it became clear to me why. Let’s look at what the script does, and does not, include… and figure out how much we care. Continue Reading
How does Power Pivot store and compress data?
Intro When I start writing a blog article, I don’t exactly know what to expect. Though… this is basically true in everyday conversation with me, as well. It’s hard to know what words are about to fly out of my mouth. It’s scary for everyone involved. That said… I expect this article to be kind of… epic. Equal parts technical, totally made up, and totally useful As mentioned in this previous post on performance gotchas, … well, many things… but mostly that Power Pivot performance issues Continue Reading