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

Maven Analytics July 9, 2025
Video Thumbnail
Maven Analytics Logo

Maven Analytics

@mavenanalytics

About

We empower everyday people and teams with future-proof data & AI skills. 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 learning for free at www.mavenanalytics.io

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.

You May Also Like

Data Mastery Essentials

AI-recommended products based on this video

Loading...
Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

Open Office Suite 2024 Professional Edition CD DVD 100% compatible with Microsoft® Word® and Excel® for Windows 10, 8, 7, Vista, XP And Mac OS X

(137)
$19.97
FREE delivery Sat, Jun 14 on your first order
Loading...
OUMAX N150 Dual LAN Mini PC, Intel 13th Gen Twin Lake N150 (Up to 3.6GHz), 16GB DDR4 500GB M.2 SSD, Mini Computer Support 4K Dual HDMI, WiFi5/BT5.0/USB3.2, Built-in 45W Power Supply Office Desktop PC

OUMAX N150 Dual LAN Mini PC, Intel 13th Gen Twin Lake N150 (Up to 3.6GHz), 16GB DDR4 500GB M.2 SSD, Mini Computer Support 4K Dual HDMI, WiFi5/BT5.0/USB3.2, Built-in 45W Power Supply Office Desktop PC

(0)
$299.00
PrimeFREE delivery Sat, Jun 14
Loading...
WEIDIAN Fanless Mini PC Industrial Win 11 Pro N100, 8GB RAM 128GB SSD, 2xCOM RS232, 2xGigabit LAN, 2xDisplays HD VGA Small Desktop PC Computer for Industrial Business Office Auto Power On

WEIDIAN Fanless Mini PC Industrial Win 11 Pro N100, 8GB RAM 128GB SSD, 2xCOM RS232, 2xGigabit LAN, 2xDisplays HD VGA Small Desktop PC Computer for Industrial Business Office Auto Power On

(115)
$396.27
FREE delivery Jun 23 - Jul 8
Loading...
90W AC Power Adapter for Dell OptiPlex 3000 5000 7000 9020 Series Micro Desktop Inspiron 20" 22" 24" 27" AIO Desktop, Inspiron 15 16 17 14 13 3000 5000 7000 Series Laptop Charger

90W AC Power Adapter for Dell OptiPlex 3000 5000 7000 9020 Series Micro Desktop Inspiron 20" 22" 24" 27" AIO Desktop, Inspiron 15 16 17 14 13 3000 5000 7000 Series Laptop Charger

(5)
$29.99
FREE delivery Tue, Aug 26 on your first order
50+ bought in past month
Loading...
WEIDIAN Mini PC Fanless Industrial Win 11 Pro PC Core i7 10810U 64GB RAM 1TB SSD Mini Desktop Computer GPIO, 4K 2HD+DP, 2LAN, 2COM RS232/422/485, 6USB WiFi&BT RAID Wake On LAN Auto Power On

WEIDIAN Mini PC Fanless Industrial Win 11 Pro PC Core i7 10810U 64GB RAM 1TB SSD Mini Desktop Computer GPIO, 4K 2HD+DP, 2LAN, 2COM RS232/422/485, 6USB WiFi&BT RAID Wake On LAN Auto Power On

(30)
$1,000.80
FREE delivery Aug 19 - Sep 2
Loading...
2026 New Embroidery Stitch Book Kit, Stitch Book Embroidery, All-in-One Embroidey StitchBook & Sewing Kit, Comes with a Complete Toolkit and Instructional Tutorial (1set)

2026 New Embroidery Stitch Book Kit, Stitch Book Embroidery, All-in-One Embroidey StitchBook & Sewing Kit, Comes with a Complete Toolkit and Instructional Tutorial (1set)

(1)
$14.90
FREE delivery Jan 23 - Feb 12
500+ bought in past month
Loading...
Rechargeable Hand Warmers, EnjoyNest C306 3-in-1 Hand Warmer Reusable 10000mAh Electric Portable Pocket Heater with 2 Pack Power Bank Flashlight 3 Levels Heating Gifts for Men,Winter,Hunting,Camping

Rechargeable Hand Warmers, EnjoyNest C306 3-in-1 Hand Warmer Reusable 10000mAh Electric Portable Pocket Heater with 2 Pack Power Bank Flashlight 3 Levels Heating Gifts for Men,Winter,Hunting,Camping

(430)
$58.94$58.44
FREE delivery Jun 13 - 17
Loading...
UGLOEY 5.0Ah 20V Max Lithium Batteries:Replacement for Dewalt 20V Max Battery,Compatible with Dewalt Battery DCB208 DCB200 DCB206 DCB205 DCB204 DCB203 DCB180 Cordless Power Tools,2 Pack

UGLOEY 5.0Ah 20V Max Lithium Batteries:Replacement for Dewalt 20V Max Battery,Compatible with Dewalt Battery DCB208 DCB200 DCB206 DCB205 DCB204 DCB203 DCB180 Cordless Power Tools,2 Pack

(42)
$51.28
FREE delivery Wed, Aug 20
500+ bought in past month
Loading...
Power-Bank-Solar-Charger - 42800mAh Power Bank,Portable Charger,External Battery Pack 5V3.1A Qc 3.0 Fast Charging Built-in Super Bright Flashlight (Orange)

Power-Bank-Solar-Charger - 42800mAh Power Bank,Portable Charger,External Battery Pack 5V3.1A Qc 3.0 Fast Charging Built-in Super Bright Flashlight (Orange)

(3,091)
49.98
PrimeFREE delivery Saturday, June 14
4K+ bought in past month
Loading...
Portable Charger 38800mAh,LCD Display Power Bank,5 USB Outputs Battery Pack Backup, USB-C in&Out Dual Input Phone Charging Compatible with iPhone 16/15/14/13/12/11,Android Samsung Galaxy Pixel Nexus

Portable Charger 38800mAh,LCD Display Power Bank,5 USB Outputs Battery Pack Backup, USB-C in&Out Dual Input Phone Charging Compatible with iPhone 16/15/14/13/12/11,Android Samsung Galaxy Pixel Nexus

(127)
$30.74
FREE delivery Sun, Aug 10 on your first order
50+ bought in past month
Loading...
Freenove Ultimate Starter Kit for BBC micro bit (V2 Included), 316-Page Detailed Tutorial, 225 Items, 44 Projects, Blocks and Python Code

Freenove Ultimate Starter Kit for BBC micro bit (V2 Included), 316-Page Detailed Tutorial, 225 Items, 44 Projects, Blocks and Python Code

(382)
$94.95
PrimeFREE delivery Sat, Jun 14