ProjectViewr/data/ReadMeFiles/pro8.readme

# 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*