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
Download Case Study

The Benefits

  • With Dashboards showing order summary, order detail and Inventory stock & availability, showing important metrics, Business were able to note region with high order demand and low stock. This helped them to reshuffle items across required inventories. This was very critical analysis helped them to grow their business, making right thing available at right place
  • Shipping Dashboards helps to track order fulfillment which indirectly accounted to money receivable. This dashboard also helped to track order backlogs and close the order within time
  • Training, Guides, documentation and troubleshooting docs really help IT team to monitor & maintain data loads, OBIEE servers, ETL servers and fix business issues and migration activities

The Solution

  • Jade Global reviewed and analyzed EBS customization to the core to design enterprise DW
  • Designed Data-Model to handle one level lower than Order-Line and designed it to be aggregated at report level
  • Based on our past functional knowledge, reporting needs were defined and built to track Sales-Order and Shipping