Creating measures and KPIs in Excel Power Pivot REPLAY 02252025

Thanks all for attending today’s session on creating measures and KPIs in Power Pivot for Excel. The recording is now available and you can download the slides and exercises file from https://github.com/stringfestdata/modern-analytics-excel-book/archive/refs/heads/main.zip I’d appreciate your feedback on today’s session if you were able to attend. Feel free to share what you enjoyed, what you'd like to see differently, or any additional topics you'd like me to cover. You can also leave a testimonial if you found the session valuable: https://stringfestanalytics.com/event-feedback . Lastly, if you're looking to elevate your finance or operations teams to operate like data analysts, scientists and engineers using Excel—without the need for costly software or IT delays—check out my services at https://stringfestanalytics.com/consulting . I also offer specialized workshops and training for research, procurement, and supply chain teams, both onsite and online. My goal is to build lasting partnerships that enhance your analytics capabilities for the long term. Thanks again for attending, and I hope to see you at future events! You can sign up for upcoming sessions here: https://www.eventbrite.com/o/stringfest-analytics-34157163075 Timestamps: Introduction to Power Pivot: 0:03 Setting Up the Data Model: 5:40 Creating calculated columns: 19:31 Creating explicit measures: 23:50 Using explicit measures in Pivot Tables: 32:34 Creating KPIs in Power Pivot: 43:09 Adjusting KPI thresholds: 42:23 Conclusion and next steps: 45:00