This Power BI project provides insights into customer orders and product tracking using interactive dashboards. It visualizes order status, sales trends, shipping details, and warehouse assignments.
This dashboard provides a high-level business overview of customer orders, sales performance, and profitability.
- 📈 Total Orders & Customers
- 📊 Sales by Year & Category
- 🌎 Order Count by State & City
- 💰 Profit Trends Over Time
- 🔥 Top Selling Categories & Products
- 🚚 Shipping Cost & Order Priority Analysis
- Pie Chart: Order Delivery Status
- Line Chart: Profit Trends Over Time
- Bar Chart: Order Count by State
- Treemap: Sales by Sub-Category
- Map Visualization: Order Count by Customer Locations
This dashboard focuses on warehouse tracking, showing where orders are stored and shipped.
- 📦 Order Status & Total Sales Tracking
- 🏭 Warehouse Assignment & Product Count per Warehouse
- 📊 Total Products Processed per Day
- 🚛 Shipping Cost Breakdown by Ship Mode
- 🏬 Warehouse Prioritization Based on Order Volume
- Map Visualization: Order Distribution Across Warehouses
- Stacked Bar Chart: Product Count per Warehouse
- Donut Chart: Order Priority Distribution
- Table View: Products, Sales, and Shipping Costs
- Order Dataset (Customer orders, delivery status, order priority)
- Warehouse Locations (Latitude & Longitude, Warehouse Assignments)
- Power BI for data visualization
- DAX (Data Analysis Expressions) for custom measures
- Power Query for data transformation
- Add real-time tracking updates.
- Integrate external API data sources (live shipment tracking).
- Implement predictive analytics for demand forecasting.