Allen Solly_Store_Data_Analysis (Interactive Dashboard creation using MS Excel)

Project Objective

The Allen Solly Store wants to create an annual sales report for 2022. So that, the owner of the Allen Solly store can understand their customers and grow more sales in 2023.

Sales Analysis

• Cleaning of raw data and then performing data analysis using Excel formulas.
• Summarise the data by Creating pivot tables.
• At the end created a dynamic dashboard of 12 months of sales.

Dashboard

A fully interactive Dynamic Dashboard

Conclusion:

To improve sales of Allen Solly Store, women customers of the age group (30-49 yrs) living in Maharashtra, Karnataka, and Uttar Pradesh must be targeted by showing ads/offers/coupons available on Amazon, Flipkart and Myntra.