Multi-page Power BI solution covering supplier performance, manufacturing insights, inventory management, customer analytics, and shipping analysis — modeled on a star schema.
Operations needed a single platform to identify reliable suppliers, cut lead-time variability, reduce stockouts, and optimize freight without over-investing in inventory.
Tools & Tech
Power BIPower QueryDAXStar Schema
Key Insights
Supplier 1 led on order volume (1,458) while Supplier 4 had the best turnover ratio.
Skincare had the longest manufacturing duration; cosmetics the shortest.
Refill lead times averaged 15.96 days across 4,777 stock units and 4,840 in availability.
Supplier reliability scores identified two suppliers driving most late shipments.
Skills Demonstrated
Data ModelingMulti-page ReportingSupplier AnalyticsInventory Optimization
Business Impact
Enabled supplier consolidation toward top performers, improving fill rates while reducing working capital and freight spend.
