This project analyzes the Northwind SQLite Database using SQL and Pandas to answer key business questions and generate actionable business insights.
The Northwind database is a sample business database containing information about:
- Customers
- Orders
- Products
- Categories
- Suppliers
- Employees
- Shippers
It is widely used for learning SQL and business data analysis.
This project answers the following business questions:
- What are the top 10 selling products?
- Who are the top 10 customers by revenue?
- How do monthly sales change over time?
- Which product categories perform the best?
- How frequently do customers place orders?
Using SQL and Pandas, the following analyses were completed:
- Top 10 Selling Products
- Top 10 Customers by Revenue
- Monthly Sales Trends
- Best Performing Product Categories
- Customer Purchase Frequency
- Basic Exploratory Data Analysis
- Data Visualization
- A small number of products contribute significantly to total sales.
- Top customers generate a large share of the overall revenue.
- Monthly sales show noticeable fluctuations over time.
- Certain product categories consistently outperform others in revenue.
- Customer purchase frequency varies, highlighting opportunities for customer retention strategies.
- SQL (SQLite)
- Python
- Pandas
- Matplotlib
- Jupyter Notebook
epochs26-day02-sql-analysis/
│
├── analysis.ipynb
├── queries.sql
├── README.md
└── northwind.db
This project demonstrates how SQL and Pandas can be combined to answer business questions, analyze sales performance, and derive meaningful insights from a relational database.
...
This project demonstrates how SQL and Pandas can be combined to answer business questions, analyze sales performance, and derive meaningful insights from a relational database.
