Sales Dashboard

🔹 Project Overview

An interactive and comprehensive Sales Dashboard designed to provide stakeholders with actionable insights into the company’s financial and commercial performance. It tracks key metrics across multiple dimensions—such as time, geography, and product categories—to help optimize operational efficiency, monitor customer behavior, and mitigate losses.

🛠️Tools

Data BI & Visualization: Microsoft Excel (Advanced Charts, Pivot Tables, Interactive Slicers, and Timelines for dynamic filtering).

📈 Outcomes

KPI Tracking: Displays high-level metrics including Total Sales ($2.3M$), Net Profit ($263K$), and Returns/Losses for immediate financial health assessment.

Segment & Category Analysis: Breaks down performance by customer segments and product sub-categories, identifying Technology and Furniture as major revenue drivers.

Geographic & Logistical Insights: Visualizes shipping costs by state and distribution by shipping modes to streamline supply chain decisions.

Customer Intelligence: Highlights the Top 10 VIP Customers to support targeted retention strategies and high-value relationship management.