An interactive and dynamic Excel dashboard designed to analyze the sales performance of an e-commerce business. Built as a personal data analysis project to showcase skills in business analytics, data visualization, and Excel automation.
This project focuses on transforming raw sales data into a comprehensive, user-friendly dashboard that enables actionable insights. The dashboard allows users to analyze sales and profit trends over time and across regions, with the added ability to filter by product category through a combo box.
- 🎛️ Interactive Product Category Filter (Combo Box)
- 📈 Monthly Sales & Profit Analysis using clustered column charts
- 🌍 Region-wise Sales Breakdown with visual insights
- 💰 Dynamic KPI Cards for Total Sales and Total Profit
- 📊 Fully Automated Data Summaries using advanced Excel formulas
- 🧩 Clean and professional layout for clear interpretation
- Microsoft Excel (Form Controls, Charts, Sheet Linking)
- Formulas:
SUMIFS,INDEX,MATCH - Dashboard Design & Layout Optimization
- Macros enabled workbook (.xlsm)
- Data Analysis & Reporting
- Excel Dashboard Design
- Interactive Controls & Automation
- Business Performance Monitoring
- Download the
E-commerce Sales Dashboard.xlsmfile from the repository - Open in Microsoft Excel and enable macros
- Use the product category combo box to filter the entire dashboard
- Explore sales trends, profit margins, and regional performance in one view
Let’s connect and grow as data professionals!
This project is licensed under the MIT License.