Supply Chain Analytics Dataset

The data model for the Supply Chain Analytics dataset is structured to effectively capture and analyze various aspects of the supply chain process. Here's a breakdown of its components:

• Customers: This table stores customer information, linked to the Orders table via the Customer ID, enabling analysis of orders per customer.
• Suppliers: Contains details about suppliers, linked to Products and Orders via Supplier ID, allowing for supplier performance analysis.
• Category_Image: This table holds product categories and their associated images, linked to Products via Product Category, supporting detailed product analysis.
• Freight: Stores information about freight types, linked to Orders via Freight ID, allowing analysis of shipping methods and their impact on order fulfillment.
• Warehouses: Contains warehouse information, linked to Orders via Warehouse ID, facilitating analysis of order fulfillment based on warehouse locations.
• Products: Holds product information, linked to Orders via Product ID and Product Category, supporting detailed product performance analysis.
• Orders: Central fact table containing key order details, including customer, delivery, product, and shipment data, serving as the core for all analysis in the report.

This data model is designed to enable a comprehensive analysis of supply chain operations, from order processing to fulfillment, providing insights across multiple dimensions like time, location, products, and suppliers.