How atchudan/amazon-sales-sql works
This repository is a MySQL sales analytics project: a user loads a CSV into a normalized relational database, then runs SQL analyses to answer business questions. The README documents schema creation, CSV loading, and 15 queries across sales, products, customers, sellers, payments, returns, and time trends. Source excerpts were not available, so the relationships shown rely on the README and file tree; individual query implementations and screenshot contents are not verified.
Main entry points: queries.sql Business queries · schema.sql Schema and import
Components 11
Data setup
- Schema and import
schema.sql
Relational data
- Sales database
Business analysis
- Business queries
queries.sql - Sales and trends
queries.sql - Product analysis
queries.sql - Customer analysis
queries.sql - Seller analysis
queries.sql - Orders and returns
queries.sql
Other components
- Analyst
- Sales CSV
- Query results
Connections 11
- Analyst → Schema and import: runs setup
- Schema and import → Sales CSV: reads CSV
- Schema and import → Sales database: creates and loads
- Analyst → Business queries: runs queries
- Business queries → Sales database: reads tables
- Business queries → Sales and trends: analyzes
- Business queries → Product analysis: analyzes
- Business queries → Customer analysis: analyzes
- Business queries → Seller analysis: analyzes
- Business queries → Orders and returns: analyzes
- Business queries → Query results: returns results