SQL Case Study – Sales & Profit Analysis
This project focuses on analyzing business sales, profit, inventory, and marketing data using SQL. The case study uses relational database concepts to solve real-world business problems and generate meaningful insights.
- Fact Table – Sales, Profit, COGS, Inventory, Budget data
- Product Table – Product details and types
- Location Table – State and market information
- Joins
- Aggregate Functions
- Group By & Having
- Window Functions
- CASE Statements
- Stored Procedures
- User Defined Functions
- Rollup Operations
- Transactions
- UNION & INTERSECT
- State-wise sales and profit analysis
- Product performance tracking
- Budget vs actual comparison
- Marketing expense analysis
- Sales ranking and reporting
- SQL
- MySQL