Menu

Vertica Case Study

Bank of America Corporation

Introduction

This case study of Bank of America Corporation is based on a July 2017 survey of Vertica customers by TechValidate, a 3rd-party research service.

“By using Vertica, we were able to reduce the data loading time in Tableau from more than an hour to a few minutes.”

Challenges

The business challenge that led the profiled company to evaluate and ultimately select Vertica:

  • Replaced the following vendors with Vertica:
    • MySQL
    • Oracle
    • Teradata

Use Case

The key features and functionalities of Vertica that the surveyed company uses:

  • Implemented the following use cases with Vertica:
    • Traditional business tracking (ERP, CRM)
    • Customer Behavior analytics
    • Clickstream analytics
    • Predictive analytics
  • Manages 6 – 100 TB of data with Vertica software.
  • Uses the following Business Intelligence (BI), Visualization, ETL, and/or analytics tools in their environment with Vertica:
    • ETL: Informatica – Power Center
    • BI: Tableau

Results

The surveyed company achieved the following results with Vertica:

  • Benefited from the following Vertica Software capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • In-database machine learning capabilities
    • Ease of interaction with existing BI tools and ETL tools
    • High availability without hardware redundancy
    • Optimizer and Execution Engine
  • Improved their query performance by 10 – 50x with Vertica.
  • Achieved 51 – 100% return on investment (ROI) as a result of implementing Vertica.




About This Data

This data was sourced directly from verified users of Micro Focus Vertica by TechValidate.

TechValidate verifies the identity and organizational affiliation of all participants that contribute to published research data. When research participants so desire, we also guarantee their anonymity so that they may share information honestly and freely.


More Research on Micro Focus Vertica