Spaces:
Configuration error
Configuration error
| # Adventure Works Cycles: Sales Performance Dashboard | |
| ## Project Overview | |
| This project provides a comprehensive analysis of sales operations for Adventure Works Cycles, a global manufacturing company. The dashboard tracks revenue performance, shipping costs, and product demand to help stakeholders monitor business health and progress toward annual targets. | |
| ## Key Metrics & KPI Highlights | |
| * **Total Due**: 123.22M in total revenue/receivables. | |
| * **Total Freight**: 3.18M in shipping and logistics costs. | |
| * **Total Tax**: 10.19M in accumulated tax. | |
| * **Current Sales vs. Target**: Real-time tracking of current sales (20.1M) against a 43.62M annual goal using an interactive gauge chart. | |
| ## Core Visualizations | |
| * **Sales by Category**: A donut chart breakdown showing that "Bikes" dominate revenue (9.42M), followed by Components and Clothing. | |
| * **Inventory & Demand**: | |
| * "Total Quantity by Category" horizontal bar chart highlighting high-volume sales in Bikes (90K) and Clothing (74K). | |
| * "Total Quantity by Product" chart tracking top-performing individual items like AWC Logo Caps and Water Bottles. | |
| * **Salesforce Performance**: A "Total Sales by Full Name" chart ranking top contributors, led by Linda C. Mitchell (10.4M) and Jillian Carson (10.1M). | |
| * **Historical Trends**: An area chart tracking order volume fluctuations from 2011 to 2014, identifying 2013 as a peak year for shipping activity. | |
| ## Technical Features | |
| * **Dynamic Interactivity**: Includes multi-select slicers for Year, Category, and Quarter to filter the entire dataset instantly. | |
| * **Target Management**: Custom "Show/Hide Target" buttons that toggle visibility for goal-oriented metrics on the gauge chart. | |
| * **UI/UX Design**: Optimized with a clean blue-themed interface, organized layout for quick scannability, and high-contrast visuals for professional reporting. | |
| ## Insights Derived | |
| * **Dominant Segments**: Bikes remain the core revenue driver, representing the vast majority of "Total Due" by category. | |
| * **Sales Pacing**: As of the current view, the company has achieved approximately 46% of its 43.62M sales target. | |
| * **Operational Peaks**: Identified a significant growth trend in total orders between 2012 and 2013, followed by a stabilization period in 2014. | |
| --- | |
| *Developed for Data Analytics Portfolio* |