Helping a Jewellery Retailer Use Data for Smarter Decisions

• A prominent jewelry retailer with multiple stores, a central warehouse, and a growing online presence. They faced challenges with fragmented inventory data, fulfillment delays, and missed sales opportunities. 

• Fragmented Inventory Visibility
  -  Online shows items “in stock” that aren’t available at stores or DCs
  -  Store staff lack real-time access to inventory across locations
   
• Imbalanced Inventory Distribution
  -  Overstock in low-performing stores; stockouts in high-demand regions
  -  Trending items unavailable where demand is highest
   
• Inefficient Stock Transfers
  -  Manual, delayed store-to-store or DC-to-store movements
  -  No intelligent system to guide replenishment
   
• Fulfillment & Customer Experience Gaps
  -  Delays in online order dispatch due to DC unavailability
  -  Lack of connection between sales recommendations and actual stock

• Data silos between stores, e-commerce, and the distribution center caused poor coordination.
• Inaccurate stock visibility led to overstocking in some locations and stockouts in others. 
• Online orders were delayed due to limited fulfillment flexibility and lack of dynamic routing. 
• Store staff couldn't access real-time inventory, leading to lost sales and poor customer service. 
• No reliable way to predict demand by region or channel (online vs in-store).
• Merchandisers and managers lacked real-time insights to act quickly and effectively. 

             1.  Unified Inventory Visibility

• Integrated data from POS systems, e-commerce platforms, ERP, and DCs into Microsoft Fabric’s OneLake
• Delivered a real-time 360° view of inventory by SKU, location, channel, and aging
• Enabled store staff and managers to make accurate, timely stock decisions

            2.   Optimized Inventory Allocations & Transfers

• Built data models to recommend dynamic transfers between DC and stores
• Highlighted at-risk items (overstock/stockouts) via Power BI dashboards
• Sent auto-alerts to merchandisers and DC teams for timely action

            3.   Smarter Fulfillment & Omnichannel Enablement

• Enabled dynamic order fulfillment logic (e.g., fulfill online orders from stores if DC is out)
• Tracked delivery delays, returns, and cancellations to improve service

•  Reduced delivery timelines through dynamic order routing and improved stock visibility. 
•  Predictive analytics ensured trending items were available where demand was highest. 
•  Smart inventory movement minimized overstock in low-performing locations. 
•  Data-driven recommendations enabled timely and effective stock transfer between locations.