E-commerce Product Retail Dashboard
Project Type: Excel Dashboard | Sales Analysis | Customer & Country Trends
🔍 Project Summary
This Excel-based dashboard uncovers insights from a large Ecommerce Product Review dataset. It focuses on customer behavior, product sales performance, top categories, country-wise patterns, and regional profitability. Designed for retail managers and analysts to understand data stories quickly and visually.
📂 Download Project File
📊 Download Excel Dashboard (.xlsx)📸 Dashboard Preview
📈 Key Insights
- Top-selling products are mostly in Electronics, Accessories, and Clothing.
- USA, UK, and Germany generate the most revenue.
- Ratings of 4+ heavily influence repeat purchases.
- Refund frequency is highest in Fashion and Personal Care categories.
- Profits peak during festival months (November–December).
✅ Suggested Use Cases
Use dashboard to track best-performing categories and top countries.
Identify refund-prone items for better quality control.
Monitor profitability and customer satisfaction side-by-side.
Target high-LTV customers for loyalty campaigns.
🧠 Skills Demonstrated
- Excel (PivotTables, Slicers, Charts)
- Retail Business Intelligence
- Customer Analytics & Product Segmentation
- Storytelling via Data Visuals
🚀 Future Enhancements
- Add region filters and time-period comparisons
- Integrate customer feedback trends
- Convert Excel visuals to Power BI for live reporting
📁 Source Code
View GitHub Repository📞 Let's Connect
For internships, freelance work, or analytics collabs — drop me a message!
Connect on LinkedIn
Connect on GitHub Profile