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

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 🔗 Helpful Resources 👉 Build Data Skills with Maven Analytics: http://bit.ly/4lr5e5c 👉 Follow us on LinkedIn: Maven Analytics:   / maven-analytics   Enrique:   / enrique-ruiz-tapia   Alice:   / alicexzhao   Aaron:   / amp28   Chris:   / 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.