This project analyzes retail sales data using MySQL to evaluate product performance, customer behavior, and sales trends. The focus is on data cleaning, validation, and business-driven analysis for reporting and decision-making.
- MySQL
- SQL (Joins, CTEs, Window Functions)
- Data Cleaning & Validation
- Business & MIS Reporting
- Fixed encoding issues in primary key columns
- Removed duplicate transaction records
- Handled missing and inconsistent values
- Converted date fields to proper DATE format
- Validated transaction prices against inventory prices
- Product-level sales and unit analysis
- Customer purchase frequency and spending behavior
- Category-wise revenue contribution
- Top and bottom performing products
- Daily and monthly sales trends
- Month-on-month sales growth using window functions
- Customer loyalty and segmentation analysis
- Identified top revenue-generating products and categories
- Detected frequent high-value customers for loyalty analysis
- Highlighted low-frequency customers for re-engagement strategies
- Observed monthly sales growth patterns and fluctuations