Data Analysis Sports data Analysiss.pptx

sports data analysis ppt

1. SPORTS DATA ANALYSIS SANSKRUTI SANJAY BHANDARE

2. “ Reletionship Between The Tables”

3. “Data Dashborad ”

4. Our company achieved a total sale of $14.10 million, with a total order quantity of 158k, resulting in a total profit of $1.30M. On average, each order yielded a profit of $24.52, and the average sale per order reached $265.24. "Key Financial Metrics Overview "

5. Monthly sales data demonstrates consistent performance throughout the year, with slight fluctuations observed in November and December. Overall, our sales remained robust, averaging at approximately $1.20 million per month. We can see that in the month of october the sale is more. Analysis of weekday sales reveals a relatively balanced distribution throughout the week, with Tuesday and Saturday recording the highest proportions of sales. While there are minor variations, overall consistency is evident, indicating a stable sales pattern across weekdays." “Month and weekdays Sales Distribution Overview"

6. Profit per order analysis by category reveals that fishing and cleats are the top-performing categories, generating the highest sum of profits. Cardio equipment and camping/hiking follow closely behind, showcasing solid profitability. Women's apparel and water sports also contribute significantly to overall profits, demonstrating the diversity and strength of our product offerings across various categories. Our sales figures for the period totaled $14.10 million, slightly below our targeted goal of $15.00 million. While we didn't reach our intended mark, it's important to note the positive momentum and efforts made towards our targets “Profit by category name and sum of sales Analysis”

7. “Analysis Of Sum Of Sale By Coustomer Segment” Analyzing our sales data reveals distinct trends across customer segments. Consumer sales lead the pack at $7.2 million, followed closely by Corporate at $4.3 million, with Home Office trailing at $2.6 million. This suggests a robust consumer base driving our revenue, indicating potential areas for targeted marketing and sales strategies. Additionally, exploring ways to enhance Corporate and Home Office sales could further bolster overall profitability. Understanding these segment-specific dynamics is crucial for informed decision-making and maximizing growth opportunities.

8. “Sum Of Order Quantity By Customer City” Cities like Chicago, Brooklyn, and Los Angeles emerge as major hubs with substantial order volumes, reflecting strong market demand and economic activity. Efficient supply chain management is crucial, especially in high-demand cities like Los Angeles and Chicago, to ensure timely delivery and customer satisfaction Caguas have many order quantity

9. Over All concluion : We can see that our company have archeive total sales of $ 14.10 million . In the month of October and Jaunary the sale is more and in November and December we can see that the the sale is low In weekdays we can see that the sale is balanced but at Tuesday and Saturday the sale is more. By category name we can say that the fishing and cleats have more profit order This year we were having the target of $15 million but unfortunatly we have not reached it ue to less and less profit The consumers have more sale in the field of coustmer segment

10. THANK YOU!!!