This project demonstrates SQL-based business analysis using the Classic Models database. The objective was to extract meaningful business insights from sales, customers, products, orders, and employee data by writing optimized SQL queries. The project focuses on data retrieval, reporting, and analytical problem-solving to support business decision-making.
- Analyse sales and order performance.
- Understand customer purchasing behaviour.
- Evaluate product performance and inventory.
- Generate business reports using SQL.
- Practice real-world data analysis techniques.
- MySQL
- MySQL Workbench
- SQL
- Customer Analysis
- Sales Performance Analysis
- Product Performance Analysis
- Order Analysis
- Employee & Office Analysis
- Revenue Analysis
- Customer Payment Analysis
- Country-wise Sales Analysis
- SELECT Statements
- WHERE, ORDER BY, LIMIT
- Aggregate Functions
- GROUP BY & HAVING
- INNER JOIN, LEFT JOIN
- Subqueries
- Common Table Expressions (CTEs)
- Window Functions
- CASE Statements
- Views
- Date Functions
- Identified top-performing products and product lines.
- Analysed customer purchasing patterns.
- Evaluated monthly and yearly sales trends.
- Compared revenue across countries and offices.
- Identified high-value customers based on payments.
- Generated reports to support business decision-making.
The project includes analysis using multiple tables, including:
- Customers
- Orders
- Order Details
- Products
- Product Lines
- Payments
- Employees
- Offices
- SQL Query Writing
- Data Retrieval
- Data Analysis
- Data Aggregation
- Database Management
- Business Reporting
- Data Filtering
- Joins & Relationships
- Analytical Problem Solving
This project demonstrates the practical application of SQL for business analysis by transforming raw relational data into meaningful insights. It showcases proficiency in writing efficient SQL queries, analysing business data, and generating reports that support data-driven decision-making.