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

Save up to 50% off Maven Pro Plans! ➡️ https://bit.ly/4cXXTHo 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 🎉 UP TO 50% OFF SPRING SAVINGS 🎉 AI is reshaping every industry, and the professionals who will thrive aren’t waiting to figure it out. They’re building real skills right now. You can, too! For Spring Savings, you can choose from 3 great offers through May 14th: 👉 Monthly plan: 25% off your first 3 months ($36.75/mo) 👉 Annual plan: 50% off your first year ($199.50/yr) 👉 Lifetime access: 50% off, forever ($849.50) All Maven Pro memberships include: ✓ Unlimited access to ALL courses & learning paths ✓ Customized learning plans ✓ Guided projects ✓ Skills assessments ✓ Showcase portfolio builder ✓ Free practice data sets ✓ Private student dashboard ✓ Live instructor chat support Plus something brand NEW, launching soon...👀 Build job-ready AI + data skills, all in one membership. SAVE NOW 👉 https://bit.ly/4cXXTHo 🔗 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.