Retail

Case Studies – Retail Implementation

#

1

Customer

NBTY, USA

Details of Customer

NBTY, Inc., formerly known as Nature’s Bounty, Inc., is an American manufacturer of vitamins and nutritional supplements which are distributed under many third party brands in the United States and internationally. Its name was changed from Nature’s Bounty, Inc. to NBTY, Inc. in 1995. NBTY also markets products to chain stores such as CVS and Target.

Challenges

  • Huge Data Volume
  • Multiple source systems
  • Multiple technologies (Oracle/ CISCO/ Tableau
  • Changing requirements
  • Large number of reports

Solutions

  • Enterprise Data Warehouse using ODI
  • Analytical Reports using OBIEE, OBIP
  • Extending the capabilities of ORDM
  • Inventory Close process using CISCO DV
  • Analytical Reports from ERP, SCM using CISCO DV

EBIW Offers

  • Industry: Retail
  • Oracle DW Products:
  • Oracle Retail Data Model
  • Oracle BI Applications
  • Oracle BIEE
  • Oracle Data Integrator
  • CISCO Products:
  • CISCO DV
  • eBIW Solution:
  • ORDM Dimensional data model
  • ORDM Business & Technical Requirement Solution
  • Data Warehouse
  • BI Reporting

#

2

Customer

Outback, USA

Details of Customer

OSI Owns and operates Outback Steakhouse, Carrabba’s Italian Grill, Bonefish Grill, Roy’s Restaurant and Fleming’s Prime Steakhouse & Wine Bar. They a new CEO, and she made it a top priority to get a brand new DW going so they could do better analytics and decision making. OSI went “LIVE” within SEVEN months. ORDM provided a support of 85% “fit” out-of-box. Several ETLs were developed from various source systems to ORDM in addition to extending the model to meet OSI specific needs. Deloitte was the primary partner in this engagement

Challenges

  • Complex data model
  • Stringent delivery schedule
  • Various source systems
  • Advance analytics

Solutions

  • Exadata as a platform for growth and consolidation
  • Initial assessment showed over 85% matching between their DW requirements and ORDM out-of-box solution
  • Advanced Analytics: Affinity, Loss Prevention & Shrinkage, Revenue Forecast, Customer Loyalty Attribute Importance
  • Went “Live” with predictable cost due to several pre-built components with comprehensive metadata

EBIW Offers

  • Industry: Retail
  • Oracle DW Products:
  • Oracle Retail Data Model
  • Oracle BI Applications
  • Oracle BIEE
  • Oracle Data Integrator
  • CISCO Products:
  • CISCO DV
  • eBIW Solution:
  • ORDM Dimensional data model
  • ORDM Business & Technical Requirement Solution
  • Data Warehouse
  • BI Reporting