Calculating Monthly Changes in Aggregate Data | Excel vs SQL vs Power BI vs Python

Video Description

Maven instructors Enrique Ruiz, Alice Zhao, Aaron Parry, and Chris Bruehl explain how to aggregate data and perform period-over-period calculations in Excel, SQL, Power BI, and Python, respectively. Data Drill Objective: You’ve been given a table with raw data for individual coffee shop transactions. Your task is to aggregate the total sales by month and store, then calculate the month-over-month change in sales for each store (in dollars). Try this Data Drill out yourself! 👉 http://bit.ly/4ef21TI 📆 Coming Soon: January Jumpstart 2026! 📆 Join us January 5th - 16th to jumpstart the new year with LIVE instructor-led learning sessions and FREE course access to our top career & AI learning paths. Let’s make AI your new data superpower in 2026! REGISTER NOW 👉 https://bit.ly/4oX9MkO 🔗 Helpful Resources 👉 Build Data Skills with Maven Analytics: http://bit.ly/4lr5e5c 👉 Follow us on LinkedIn: Maven Analytics: https://www.linkedin.com/company/maven-analytics Enrique: https://www.linkedin.com/in/enrique-ruiz-tapia/ Alice: https://www.linkedin.com/in/alicexzhao/ Aaron: https://www.linkedin.com/in/amp28/ Chris: https://www.linkedin.com/in/chrisbruehl/ ⏱️ Timestamps: 00:00 - Intro 00:15 - Data Drill Objective 00:31 - Excel Solution Walkthrough 04:18 - SQL Solution Walkthrough 10:33 - Power BI Solution Walkthrough 17:13 - Python Solution Walkthrough 21:36 - Validation Question 21:54 - Outro/Resources Maven Analytics is an award-winning learning platform where individuals and teams build new skills, showcase work, and connect with experts around the world. We've helped 2M+ people build job-ready data literacy & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundation for successful careers. Start building life-changing skills for FREE at mavenanalytics.io.