Excel Data Analysis Dashboard
- Tech Stack: Microsoft Excel, Pivot Tables, Pivot Charts, Slicers, Data Cleaning, Conditional Formatting
- Project Focus: Ecommerce Store Sales Analysis
- Github URL: Project Link
This project involves the creation of a dynamic Sales Dashboard in Microsoft Excel to analyze ecommerce store data. The dashboard provides insights into product sales across different channels, gender-based sales trends, and more.
Key features of the dashboard include the use of Pivot Tables for data summarization, Pivot Charts for visualization, Slicers for interactive filtering, and Data Refresh functionality to keep the dashboard updated. The project also emphasizes data cleaning and processing to ensure accurate analysis.