Industry
e-commerce
Skills
data-wrangling
Tools
sql
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
GlobalMart, a leading e-commerce platform, seeks insights into category-wise sales performance across multiple years. In this scenario we analyze total sales for each category and transform the data into a year-over-year comparison using pivot operations. The results will help identify trends and support strategic decisions for inventory planning and marketing initiatives.
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.