Sales Analysis Dashboard

By Eng/ Omar Ibrahim Elashry

Project Title: Sales Analysis Dashboard

---

Project Developer

Omar Ibrahim Elashry
(Data Analyst & Business Development Manager)

LinkedIn: https://www.linkedin.com/in/omar-ibrahimelashry

Email: omarelashry27@gmail.com

---

Project Overview

This project presents an interactive sales performance dashboard that analyzes key business metrics across multiple dimensions, including product categories, regions, customer segments, shipment modes, and time periods. The dashboard enables data-driven decision-making by visualizing total sales, profits, quantities, and top-performing products.

---

Tools Used

• Database from (Github)

• Data visualization tool (Microsoft Power BI)

• Data aggregation and cleaning (Microsoft Excel, Python Programming Language)

---

Key Metrics (KPIs)

• Total Sales: 2.3M

• Total Profit: 286.3K

• Total Quantity Sold: 37.9K

---

Key Features & Insights

1. Profit by Category

• Furniture: 18.4K (6.44%)

• Office Supplies: 122.5K (42.77%)

• Technology: 145.4K (50.79%)

Insight: Technology is the most profitable category, followed by Office Supplies.

2. Monthly Sales & Quantity Trends

• Tracks total sales and quantity sold month by month.

• Helps identify seasonal peaks and plan inventory accordingly.

3. Sales by Category & Segment

• Categories: Technology, Office Supplies, Furniture

• Segments: Consumer, Corporate, Home Office

• Enables comparison of which segment performs best in each category.

4. Top 10 States by Profit

• California leads with 76K in profit.

• Followed by New York, Washington, Michigan, Florida, and others.

• Useful for regional marketing and logistics strategies.

5. Top 10 Products by Sales

• Canon image CLASS 2200 Advanced Copier : 61,599 K

• PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind: 27,453K

• Helps identify best-sellers for inventory and promotion planning.

6. Sales by Quarter

• Q4 shows the highest sales.

• Correlates with holiday seasons and year-end discounts.

7. Sales by Region

• Regions analyzed: Central, East, South, West

• Relatively balanced distribution with slight regional variations.

8. Sales by Ship Mode & Category

• Ship modes: First Class, Second Class, Same Day, Standard Class

• Helps optimize shipping policies and cost management.

---

Business Value

• Provides clear visibility into sales and profit performance by product, region, and category

• Supports strategic decision-making in marketing, inventory, and logistics

• Identifies top-performing products and underperforming regions

• Enables quarterly and monthly performance comparisons