My buddy Derek Rickard gave this great talk awhile back at a local “Modern Excel User Group” meetup. I’m putting it here because a) it is awesome and b) I can never find it. Now I can!
Definitely worth a watch – some really clean modeling here. Stolen without permission, because I am a bad man.
Derek does some Power Pivot consulting, if you need to get ahold of him let me know, and I will get you in touch. If he gets back to me with a link to a website or something, I will add it here