Mini-project
Retail, E-commerce & Consumer Goods
Indian e-commerce sales analysis
Load Indian online-retail data into a database and answer business questions with SQL.
The brief
An online seller wants to know which categories, sizes and states make money and which cause cancellations. Load the order data into a database and answer the questions a category manager asks, with SQL and pandas. Good looks like: reconciled queries, clear charts, and five business recommendations.
What you will build
- Load orders into a database
- Analyse sales by category, size and state
- Find cancellation and return patterns
- Compare channels and fulfilment types
- Present recommendations to a category manager
Free, open data to build it with
Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.