Excel Projects | Self Learned Project
Project - 1
Vrinda Annual Report 2022
Objective:-
Vrinda store wants to create an annual sales report for 2022. So that, Vrinda can understand their customers and grow more sales in 2023
Problem Statements:-
- Compare the sales and orders using single chart
- Which month got thee highest sales and orders ?
- Who purchased more – men or women in 2022 ?
- List Top 5 states contributing to the sales ?
- Relation between age and gender based on number of orders
- Which channel is contributing to maximum sales
Solutions
Age group date
=If(E2>=50,”Senior”,If(E2>=30,”Adult”,”Teenager”))
Month
=TEXT(G2,”mmm”)
Next, for each problem we will create separate pivot table. After creating pivot table we will visualize them through chart.
Here is the screen short of Final output.If you are in the market for clothes, our platform is your best choice! The largest shopping mall!
Insights
>> Women are more likely to buy compared to men (~65%)
>> Maharashtra, Tamil Nadu and Uttar Pradesh are the top 3 states (~35%)
>> Adult age group (30-49 yrs) is max contributing (~50%)
>> Amazon, Flipkart and Myntra channels are max contributing (~80%)
Final Conclusion to improve Vrinda store sales:
Skills which I gained after doing this project are:-
>> Data Cleaning
>> Data Processing
>> Data Analysis
>> Data Visualization
>> Creating Reports
- Target women customers of age group (30-49 yrs) living in Maharashtra, Tamil Nadu and Uttar Pradesh showing ads/offers/coupons available on Amazon, Flipkart and Myntra