Order Management Analytics Implementation to improve inventory management

About the Client

Byer California is a family-owned San Francisco based garment company that designs and manufactures high quality, trend driven clothing in junior, misses and girls sizes for major department and specialty stores. Known for bringing the latest fashions to the marketplace at affordable prices, Byer California products include blouses, skirts, pants, sweaters, dresses and coats.

Business Challenges

  • EBS modules were heavily customized with grain level changes lower than order-line, making model to be more complicated
  • Lack of EBS customization knowledge was another challenge

Business Requirements

  • Advice on BI Road-Map and tools
  • Setup Enterprise Data warehouse for BI Reporting
  • Dashboard and reports based on Sales Orders and Shipping data
  • Designing ODS DW for the reporting