Creating an interactive Dashboard and report to study the annual sales of a store in Excel
1- What is the business Problem here?
The store needs to create an annual sales report for 2023 to better understand the clients and drive more growth and customers into the store in 2024 and afterward but the data is messy, not clean, and needs to be discovered.
2- What are the questions that will be answered through this report?
A- Studying the progress of the sales over the orders inquiries over the last year.
B- Knowing which month had the highest sales in 2023
C- What gender category is making most of the purchases
D- What is the status of the sales that were made last year, the percentage of delivered, canceled orders, and other types of order status
E- Locating top 5 selling states.
F- Is there a correlation between gender and age categories on the progression of sales?
G- Marketing channels contribute mostly to creating more sales.
Based on the results and the created dashboard over the data, the following points reflect the plan for sales for better performance for the upcoming year:
1- Women are more likely to buy and order compared to men by more than 60%.
2- Listed top 3 selling states and top 3 marketing channels controlling the best sales
3- The adult group in general (whether it is men or women) is more likely to make more purchases than any other category
----> Our main targeted category based on this analysis is adult women (gender and age category that made most purchases) in the top 3 selling states and using the top 3 selling channels by showing ads on these channels.