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 
Some ways to get ahold of Derek!
twitter.com/SourceToShare
linkedin.com/in/derekrickard
- The streak is alive! – August 10, 2017
- DAX KEEPFILTERS Plus Bonus Complaining! – July 20, 2017
- VAR: The best thing to happen to DAX since CALCULATE() – July 11, 2017
- Review: Analyzing Data with Power BI and Power Pivot for Excel – June 20, 2017
- Power BI Date Table – June 2, 2017
Scott Senkeresty here… Founder and Owner of Tiny Lizard. Yes, I have done some stuff: A Master’s Degree in Computer Science from California Polytechnic State University in beautiful San Luis Obispo, California. Over twelve years developing software for Microsoft, across Office, Windows and Anti-Malware teams… Read More >>
Good stuff
Thanks for sharing the video, do you have a link to the demo workbook used in the video?