This project utilizes SQL to conduct a comprehensive data analysis of a quick-commerce (e-commerce grocery delivery) platform, simulated using Blinkit's data schema. The primary goal is to extract key business insights related to sales performance, product popularity, and operational efficiency, thereby demonstrating strong analytical and database querying skills.
- Revenue and Sales Performance
- Daily Revenue Trend
- Total Revenue per Product
- Product & Category Management
- Top-Selling Products (by Quantity)
- Most Popular Categories
- Pricing Analysis
- Data Integrity & Cleaning
- Date Formatting
- Safety Handling
Based on the analysis performed in general.sql, the following key business observations were made:
- Category Dominance
- Price Sensitivity
- Revenue Cycle