Full analysis of Project in Excel with Interactive Dashboard
Steps involved: Data Cleaning Data Processing Analysis Dashboard Creation Insights
INSIGHTS FROM ANALYSIS
- Women are more likely to buy more than men
- Maharastra, Karnataka, Uttarpradesh are the states that contribute more to more sales
- Adult Age group contributes the maximum
- Amazon, Flipkart, Myntra channels are used maximum by the customers.
To improve the sales of the online store, Target Women customers of age group 30-49 living in the top states by providing more offers in Amazon, Filpkart, Myntra.