GlobalMart Year-over-Year Sales Analysis by Category

Learning Objectives

Demonstrate use of JOIN, GROUP BY, and WHERE clause to ensure accurate filtering and calculations.

Demonstrate knowledge of common table expressions (CTEs) to structure and simplify complex queries.

Perform pivot operations to summarize and organize the data

Overview

Something strange is happening in GlobalMart's sales data. Technology products are behaving differently than Furniture. Office Supplies follow their own mysterious patterns. And nobody can explain why.

Globalmart has tasked you with solving this puzzle. GlobalMart's leadership is counting on your skills to decode multi-year sales trends that will shape their entire business strategy. This isn't just data analysis—it's corporate intelligence work.

You'll dive deep into e-commerce data, uncovering the performance secrets of each product category across multiple regions. Your findings will determine where millions get invested next quarter.

The bottom line: Your analysis becomes the roadmap for GlobalMart's future growth strategy.

Ready to crack the case?

Prerequisites

Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
Understand common SQL functions like `COUNT`, `SUM`, and `DATEDIFF`.
Know the purpose and use of joins (e.g., INNER JOIN, LEFT JOIN).
Knowledge of pivoting in SQL.