A project on Microsoft Excel which utilizes pivot tables to display information in a manner which is easy to understand and adjust/filter with the help of slicers.
Objective
Let us say a certain store (Vrinda Store in this instance) wants to create an Annual Sales Report for the year 2022. This will help Vrinda Store to understand their customers better and grow more sales for 2023 and further.
Problems we will be able to solve from such approaches, which is basically clever data cleaning, sorting and presentation:
1. Find which month got the highest Sales and Orders
2. Compare the sales and orders using single chart
3. Who makes purcheses more often: Men or Women
4. Order Status
5. Top 10 states contributing to the sales
6. Relation between Age and Gender based on number of orders
7. How much each channel contributes to the sales
8. Highest Selling Categories
and many more can be observed.