This project consists of a complete SQL analysis of the Northwind database using MySQL.
The objective is to explore business data and extract meaningful insights about:
- Sales performance
- Customers behavior
- Product performance
- Employee activity
- Business trends
The project demonstrates SQL skills including:
- Data exploration
- Filtering and sorting
- Aggregations
- JOIN operations
- Subqueries
- Common Table Expressions (CTE)
The project uses the Northwind sample database, which contains information about:
- Customers
- Orders
- Products
- Categories
- Employees
- Suppliers
- MySQL Workbench
- Visual Studio Code
- Git & GitHub
northwind-sql-analysis/
├── database/ │ └── northwind_schema.sql
├── queries/ │ ├── 01_data_exploration.sql │ ├── 02_sales_analysis.sql │ ├── 03_customer_analysis.sql │ ├── 04_product_analysis.sql │ ├── 05_employee_analysis.sql │ └── 06_advanced_sql.sql
├── insights/ │ └── business_insights.md
└── screenshots/
The Northwind database contains:
| Table | Description |
|---|---|
| customers | Customer information |
| orders | Sales transactions |
| order_details | Product details per order |
| products | Product catalog |
| employees | Company employees |
| suppliers | Product suppliers |
| categories | Product categories |
The main goal is to answer business questions using SQL and transform raw data into actionable insights.
Adam Matsiona
Aspiring Data Analyst / Data Scientist