📊 ShopEasy Marketing Analytics Project
This project supports ShopEasy, an e-commerce brand facing declining engagement and conversion rates. It applies SQL, Python, and Power BI to uncover insights and guide targeted marketing strategies.
🧩 Tools Used
- SQL for querying and data cleaning
- Python for statistical tests, sentiment analysis and predictive analysis
- Power BI for dashboards and visual storytelling
📌 Key Steps
- Imported and cleaned data in SQL
- Performed statistical tests (t-test and two way Anova test) in Python.
- Performed sentiment analysis on reviews in Python
- Segmented customers by age groups for tailored campaigns in SQL
- Built Power BI dashboards with KPIs and filterable visuals
📷 Snapshots
Click each image to view it in full screen.
💡 Outcome
Based on the insights from this project, the marketing team developed three targeted campaigns. These hypothetical efforts suggest a potential improvement in funnel conversion by 12% within two quarters.