This project focuses on analyzing a retail store database using SQL and MySQL.
The database contains information about:
- Customers
- Products
- Orders
- Order Items
- Payments
- Product Reviews
The goal of this project is to use SQL queries to answer different business questions related to sales, customers, products, inventory, and payments.
- MySQL
- SQL
- MySQL Workbench
- SELECT
- WHERE
- DISTINCT
- ORDER BY
- GROUP BY
- Aggregate Functions
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- Subqueries
- UNION
Some of the questions analyzed in this project include:
- What is the total revenue?
- What is the average order value?
- How many orders were placed?
- Which customers placed orders?
- Which customers have not placed orders?
- Which products were sold?
- Which products are out of stock?
- Which category has the most products sold?
- How much payment was received through each payment method?
Gourav Mallick
Aspiring Data Analyst
If you found this project useful or interesting, please consider giving the repository a ⭐ Star on GitHub!
Your support and feedback are greatly appreciated and motivate me to keep building and sharing more Data Analytics projects.
Skills: SQL | MySQL | Python | Excel | Power BI | Tableau