← All projects
Data foundations

Target Brazil — E-commerce Order Analytics (SQL)

Analysed 100K+ e-commerce orders (2016–2018) in SQL: order status, payments, freight and customer geography — turned into recommendations on pricing, shipping efficiency and customer satisfaction.

100K+ orders
3 years of data
SQLBigQueryEDAData Cleaning

Questions explored

  • How did order volume evolve over time and by state?
  • What drives freight cost and delivery delays?
  • How do customers pay, and in how many instalments?

Approach

Pure SQL: joins across orders, customers, payments, items and sellers; window functions for trends; aggregations for delivery performance.

Outcome

Actionable recommendations on pricing strategy, shipping efficiency and customer satisfaction — a foundation case study from my MS program.