End-to-end data analysis project using Python → MySQL → Power BI
This project focuses on understanding customer purchasing patterns, category performance, shipping preferences, and customer segmentation.
I started by cleaning and transforming raw data in Python, then moved the refined dataset into MySQL for deeper analysis.
Finally, I visualized key insights using Power BI to create an interactive dashboard.
---
- Handled missing values
- Removed inconsistent entries
- Performed feature engineering
- Exported cleaned dataset for database use
- Created structured tables
- Inserted transformed data
- Wrote advanced SQL queries for deeper insight
- Explored spending patterns, customer segments, and category performance
- Designed analytical dashboard
- Visualized revenue by category
- Analyzed subscription behavior
- Explored shipping preferences
- Segmented revenue by age groups
- Clothing is the strongest category in both sales and revenue
- Only 27% of customers are subscribers → huge loyalty opportunity
- Free & Standard Shipping dominate → price-sensitive customers
- Young Adults generate the most revenue and purchases
- Python (Pandas, NumPy)
- MySQL
- Power BI
- Jupyter Notebook