The eCommerce Store Sales Dashboard provides a comprehensive view of sales performance, customer trends, and product insights. Built using Microsoft Excel, it leverages pivot tables, charts, and slicers for interactive data analysis and decision-making.
An online retailer, selling products through various channels, including Amazon and Flipkart. They have provided their 2022 sales data for analysis, aiming to gain customer insights and identify growth opportunities to drive increased sales in 2023.
- Data Cleaning: Review the dataset to identify and address duplicates, null values, and inconsistencies.
- Data Processing: Create calculated columns based on existing data to derive additional insights.
- Exploratory Data Analysis: Analyze the dataset using aggregate functions and pivot tables to uncover patterns and trends.
- Data Visualization: Develop appropriate charts to present the data in an easy-to-understand format.
- Dashboard Creation: Design a dashboard by organizing multiple charts and visual elements on a single page.
- Insights: Deliver actionable insights and recommendations to stakeholders based on the analysis.
- Women are more likely to buy compared to men (65%)
- Maharashtra, Karnataka and Uttar Pradesh are the top 3 states (35%)
- Adult age group (31-50 yrs) is max contributing (50%)
- Amazon, Flipkart and Myntra channels are max contributing(80%)
The retail Store should target women customers of age group (31-50 yrs) living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.
