مشروع كامل بي power bi

This Power BI dashboard offers a comprehensive overview of order performance and financial metrics across multiple dimensions and years. Here's a detailed description:

________________________________________

Key Metrics (Top KPIs)

•YOY Revenue: $22.3M

•Number of Orders: 24K

•Total Amount: $30.1M

•Total Amount Due: $33.9M

•Total Freight: 916K

•Total Tax: $2.9M

________________________________________

Order Trends and Insights

•# Orders by Year (Line Chart):

Orders steadily increased from 2011 to 2013, peaking in 2013, then declined in 2014.

•# Orders by Status (Pie Chart):

oApproved: 396 (27.03%)

oIn Process: 392 (26.76%)

oShipped: 374 (25.53%)

oCancelled: 137 (9.35%)

oRejected: 117 (7.99%)

oBackordered: (not labeled with value)

________________________________________

Sales by Product Category (Tree Map)

•Bikes: 9K orders (highest)

•Components: 7K orders

•Clothing: 5K orders

•Accessories: 2K orders

________________________________________

Territory Performance (Bar & Line Chart Combo)

This chart compares:

•# of Orders (orange bars)

•Total Amount (blue line)

Top territories:

•Canada: 11M revenue with highest order count

•Northwest, France, UK: moderate orders and revenue

•Southwest & Central: lowest performance (almost $0)

________________________________________

? Summary

This dashboard presents a clear view of operational and sales performance by year, status, product category, and region. It helps identify where orders are coming from, their status, and how much revenue is being generated per region and product. Perfect for business decisions regarding logistics, product focus, and market strategy.