Any sufficiently advanced technology is indistinguishable from magic I have been wanting to do a Kahn Academy style screencast for awhile and finally forced myself to do it! It is… possible… that I spent a bit too much time working out the quirks in the software, and not enough time planning out what the heck I was talking about… but I put enough effort into it, that it would be a shame not to post it. The loose goal was to discuss (at least at a high level) the whys and hows of the Power Continue Reading
PASS BA Conference 2015
I don’t exactly have many conferences to compare this one (PASS Business Analytics) to. Also, I’m not sure it is proper to end a sentence with the word “to”. But this was basically my first conference. It was basically fantastic. Proof: Come on! Do we look crazy happy or what!? An amazing set of dudes here – Chandoo, Rob Collie, Matt Allington, myself, and Ken Puls. The “networking” was super fun, and the chance to chat for a few with Marco Russo, Mr Excel, Jen Stirrup, Jen Underwood, Continue Reading
Power Pivot Date Table
All great achievements require time. - Maya Angelou Trying to round out my posts of Fundamentals here – so when I ask the crazy kids on the forum “Are you building this against a Calendar table?” – I have somewhere to point them for reference. If you are seasoned… probably not a ton of excitement for you here Power Pivot has a lot of really cool Time Intelligence functions... none of which have much to do with Time :) They all have to do with Dates. If you look at any of the functions in the Continue Reading
Dynamically changing chart axis
I have been sitting on this post for awhile (that looks weird in one word – should that be “a while”? Let’s just skip that discussion). Okay, I got distracted and was wondering how long I was sitting on this… and it looks like this thread over on the Mr Excel forums came back to life about a month ago and got me thinking about it... The goal is to have charts where the axis/labels/columns/whatever can change via a slicer. So, instead of showing Sales across Years, I can flip and show Sales Continue Reading