📈 Product Sales Dashboard

🚀 Project Overview

This project is an interactive Power BI dashboard designed to analyze detailed sales performance across products, customers, and regions. Developed as of September 2025, it consolidates product sales data, customer stats, tax, freight, and order status into a dynamic, multi-page dashboard. The goal is to provide a clear, real-time view of key sales metrics to assist analysts and decision-makers in tracking business health and performance.

The dashboard includes data on 219 products and 93 customers, presenting total sales, tax, freight costs, and detailed customer purchase behaviors. It enables easy navigation between overview, product details, and customer-level insights.

🔧 Tech Stack & Libraries

• Power BI for advanced data visualization and dashboard construction
• Interactive KPIs, bar charts, line charts, pie charts, and treemaps
• Dynamic filters for order status, product categories, and time
• Integrated data sources including sales, customer, and shipping data

📥 Data Workflow

• Data Sourcing: Sourced from structured sales and customer datasets with complete transactional information.
• Transformation: Processes ensure data accuracy and consistency for robust visualizations.
• Dashboard Design: Designed multiple report pages: Main overview, Products sales analysis, and Details with deep-dives.

Visual elements include:

• ✅ KPIs for total products, customers, tax amount, freight, and sales
• ✅ Sales and order count by product with dual-axis bar and line chart
• ✅ Customer sales ranking bar chart highlighting top purchasers
• ✅ Geographic sales distribution by territory with bar charts
• ✅ Order volume by shipping method displayed in donut chart
• ✅ Product quantity distribution by category with treemap and sankey flow to subcategories

📊 Usage and Insights

• Enables executives and analysts to monitor product and customer performance at different granularities.
• Insights on order status trends and key customer contributions support targeted strategies.
• Identifies product categories driving sales and quantities shipped.
• Makes complex multidimensional data accessible through intuitive visual storytelling.

📌 Key Learnings

• ✔️ Effective use of Power BI visuals to communicate sales data
• ✔️ Implementing multi-page, interconnected dashboards for comprehensive exploration
• ✔️ Combining quantitative KPIs with qualitative filters and tooltips for enhanced user experience
• ✔️ Structuring diverse datasets blending products, customers, shipping, and transactional info for BI reporting

⚠️ Notes

• The dashboard utilizes static data snapshots; live data integration is recommended for real-time insights.
• Scalability and dynamic refresh features should be implemented for production environments.

🌟 Project Value

This dashboard project showcases essential Business Intelligence skills applicable for retail, e-commerce, and sales performance analytics. It equips businesses to track financial metrics, customer habits, and product trends for optimized decision-making and resource allocation.