Customer Story

Nicholas and Company: Delivering Data Fast with HVR and Amazon S3

Customer: Nicholas and Company

How a Food Distribution Company Delivers Faster Reporting


About: Nicholas and Company has offered food distribution services since 1939. With operations across middle and western United States, the company distributes food, beverage, and chemical products and equipment to schools, healthcare organizations, and restaurant chains. It also offers services such as employee training and marketing.

Previously, the company enabled decision support by moving data in a daily batch from several ERP systems to multiple data warehouses and completing extract, translate, load (ETL) operations. But the complexity of the process meant that the data warehouses were straining to produce daily reports in a timely fashion.

The company looked for a real-time data integration solution to dramatically speed up its existing batch business intelligence (BI) reporting. It also created a second solution that would deliver near real-time data access.

Challenge:

  • 16-18 hour ETL jobs
  • Reduce time of running reports
  • Data accuracy

Databases: 

  • Amazon S3 Data Lake
  • Amazon Redshift Data Warehouse

Use Case:

  • Data Warehousing
  • Data Lake



HVR_Case_Study_Nicholas_andCo_COVER

© 2019 HVR

Try now Contact us