Created and Analyzed by: Saddam Ansari @Aspiring Data Analyst LinkedIn
Live Dashboard At Novypro Link
✨➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖✨
The objective of this project is to analyze the dataset from the past two to three years for our watch seller company. The Sales Director aims to extract key performance indicators (KPIs) and insights from this data, consolidating them into a single dashboard. This dashboard will provide a comprehensive overview of sales insights, allowing for better decision-making and strategic planning.
The provided dataset encompasses various aspects crucial for analyzing watch sales, including sales figures, quantities sold, order details, dates, and additional pertinent information related to watch sales.
✨➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖✨
✨✨➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖✨✨
- Year-to-Date (YTD) Sales 2022: Total sales in 2022 amounted to $746k.
- YTD Sales 2021: Total sales in 2021 were $614k.
- Sales Growth from 2021 to 2022: The sales witnessed a growth of 21.4%.
- Total Category-wise Sales Growth: The overall sales growth across categories was 21.4%.
- Segment-wise Sales Growth: Segment-wise sales experienced a growth of 19.5%.
- Budget for 2023: The allocated budget for 2023 stands at $473k.
- A column chart illustrates the sales figures by month, indicating that the highest sales occurred in November, followed by December and September, respectively.
- Notably, February recorded the lowest sales figures.
- A line chart displays the number of orders each month, revealing similar trends to sales. December, November, and September stand out as months with the highest number of orders, while February exhibits the lowest.
- These insights provide a comprehensive understanding of sales performance and ordering trends over the specified time period.
✨✨➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖✨✨
Don't forget to give a start to this project because its motivate me and also please follow me on Linkeldin. and Please consider me for any internship or entry level data analyst role. I need a job or internship. Thanks in Advance.
-
First and foremost, your appreciation and endorsement of this project mean the world to me. If you have any recommendations or suggestions, please feel free to share them with me. Your input can immensely assist me in refining and improving this project further.
-
Additionally, I have worked on over 40 projects, which you can explore on my portfolio at Novypro. If you believe that my skills align with your requirements, I would be grateful if you could recommend me on LinkedIn.
-
As I am currently seeking internship or entry-level positions, your support and assistance would be invaluable to me. I assure you of my gratitude for any help extended.
I hope you found this project enjoyable and insightful.😊😊
Created & Presented by -Saddam Ansari @ Aspiring Data Analyst