This dashboard suite gives supply chain leadership end-to-end visibility into a cosmetics, haircare, and skincare product portfolio from supplier and manufacturing quality through to shipping, logistics, and final delivery. It spans three connected report pages Shipments & Logistics, Manufacturing & Quality, and a SKU Detail drill-through tracking ₹578K in total revenue, a 99.09% profit margin, and a 2.28 average defect rate across five suppliers and multiple carriers, routes, and transportation modes. The result is a single operational view that connects product quality on the factory floor to cost, delay, and revenue outcomes downstream.
Manufacturing quality data, supplier performance, and shipping/logistics costs lived in separate operational silos, making it difficult to trace a delayed shipment or a low-quality score back to its root cause, a specific supplier, route, or carrier. Leadership had revenue and margin numbers, but no way to connect a 2.28 average defect rate to the shipments and customers it was actually affecting.
Production, inspection, and logistics data were cleaned and linked in Power Query, then modelled around common dimensions like Supplier, Product Type, Location, Route, and Carrier, so quality and shipping metrics could be sliced consistently. Core DAX measures (Quality Score, Total Revenue, Profit Margin %, Avg. Order Value, Total Shipping Cost) were built once and reused from the executive summary down to individual SKU-level drill-throughs.
The model connects manufacturing-floor metrics (defect rate by supplier, inspection status: Pass/Fail/Pending) directly to downstream logistics outcomes (cost by route and mode, delays per route, carrier on-time vs delayed performance). A Cost-vs-Quality scatter plot by SKU and a geographic Shipping Cost by Location map add a spatial and product-level lens that a flat report couldn't provide. A dedicated SKU Detail drill-through page lets any user click from a summary chart straight into the full cost, quality, and delivery history of a single SKU.
Defect rate and quality thresholds (High/Low/Medium defect categories) were refined per supplier as more inspection data came in, and delay patterns by route and carrier were re-evaluated over time to distinguish one-off delays from systemic carrier or route issues — sharpening which suppliers, routes, and carriers actually needed intervention.
“You can't fix a delay or a defect at the summary level you have to be able to drill down to the exact supplier, route, or SKU where the problem actually started.” — Tamanna Thakur, Data Analyst
Enhancing Accuracy in Supply Chain Quality & Logistics Tracking
The dashboard suite combines manufacturing quality data, supplier performance, and shipping/logistics costs into one governed model, so a single defect rate or shipping cost figure means the same thing whether viewed at the executive summary or drilled all the way down to an individual SKU.
What began as separate manufacturing and logistics reports has become a connected view linking factory-floor quality directly to shipping cost, delays, and revenue. Connects manufacturing quality data directly to downstream shipping cost and delay outcomes
