Reverse Logistics Analytics Dashboard

Problem

Returns and refunds affect profitability and customer experience.
This project analyzes return data to help Amazon improve reverse logistics.

What this project includes

• SQL Schema: Customers, Products, Orders, Returns
• SQL Queries:
  • Top reasons for returns
  • Products/regions with highest return rates
  • Cost implications of returns
• Future Work: Build dashboard in Tableau/QuickSight

Files

• create_tables.sql → database schema
• analysis_queries.sql → analysis queries