1 . Creating a Student portfolio Dataset - Click Here to View
2. Collecting Data in Google Sheet - Click Here To View
About this Data - Objective
Vrinda store located in Varanasi (UP) wants to create an annual sales report for 2022. So that, Vrinda can understand their customers and grow more sales in 2023.
3. Annual Sales Report : An annual sales report also known as a yearly sales report is an annual activity report made by the sales leaders or sales manager. It is the summary of all sales activities that occur during a specific year, usually the past year.
An annual sales report gives an organization a clear overview of all its activities and how it performed in the previous year and what new goals and missions should be developed for the upcoming year.
It covers everything that a business sales team does from financial statements from the company CFO to a sales and marketing report. Creating an annual sales report starts with data or information gathering about the company’s sales strengths and weaknesses, the percentage of sales goals met in the previous year, and the milestones that were achieved.
4. By analyzing this dataset with a variety of parenting and psychological methods it is possible to investigate
• Compare the sales and orders using single chart
•Which month got the highest sales and orders?
•Who purchased more- men or women in 2022?
•What are different order status in 2022?
•List top 10 states contributing to the sales?
• Relation between age and gender based on number
•Which channel is contributing to maximum sales?
•Highest selling category?, etc.