Industry
e-commerce
Skills
data-wrangling
Tools
sql
Learning Objectives
Understand how Market Basket Analysis works
Use SQL to analyze orders data to understand the constituents of the basket
Analyze the basket by calculating Support, Confidence and Lift metrics
Overview
In this scenario, you'll work on a very popular and useful problem statement in Retail industry, that is, Market Basket Analysis.
Prerequisites
- Working knowledge of SQL
- Familiarity with constructs like JOINs, CTEs, Group Aggregations etc.