This data analytics project aims to analyze Adventure Works sales data to uncover patterns, trends, and insights that can improve Overall sales Regional performance, Identify sales trends, and target customer strategies. The project focuses on key performance indicators (KPIs) that provide a detailed understanding of sales behaviours across different segments.
The goal was to create an interactive and insightful tool that enables Adventure Works Cycles to monitor and enhance their sales strategies by identifying key trends and performance metrics across different regions, products, and customer segments.
- Year-wise Growth: 2013 was a standout year with the highest sales at 16.35M, reflecting effective sales strategies.
- Month-wise Performance: December saw peak sales (₹3.2M), driven by seasonal promotions, while February had the lowest, suggesting a need for targeted campaigns during off-peak months.
- Country-wise Sales: The United States and Australia are the top-performing countries, with sales of ₹9.4M and ₹9.1M, respectively.
- Total Sales & Profit: Adventure Works Cycles achieved a total sales figure of ₹29.36M, with a profit of ₹12.08M.
- Region-wise Breakdown: The United States and Australia lead in sales and profit, while Canada and France lag behind, indicating potential areas for strategic improvements.
- Quarterly Insights: The highest sales were recorded in Q4 (₹9.1M), contributing 30.99% of the yearly sales.
These dashboards empower Adventure Works Cycles with actionable insights, enabling data-driven decisions to enhance profitability, optimize product offerings, and strategically expand into underperforming regions.
