Game Show Network

Use Case

• Is implementing the following applications with OpenText (formerly Vertica):
  • Promotional testing
  • Fraud monitoring/prevention
  • Financial tracking
  • Behavior analytics
  • Clickstream analyses
  • Customer analytics
  • Loyalty analysis
  • Predictive analytics
  • Campaign management
  • Machine/sensor data analysis
• Currently managing 10 – 20 TB of data with OpenText (formerly Vertica) software.
• Uses the following Business Intelligence (BI), visualization, and ETL tools in their environment:
  • Business Objects Crystal Reports
  • Microsoft Integrated Services
  • Microsoft SQL Server Reporting Services
  • Tableau
  • Homegrown
  • Web-based using javascript html5

Results

• Values the following features in OpenText (formerly Vertica) software the most:
  • Extreme speed and performance
  • Simplicity
  • Standard SQL interface
  • Simultaneous loading and querying
  • Aggressive compression
  • Ease of interaction with existing BI tools through connectors and ODBC/JDBC
  • Optimizer and execution engine
• Achieved the following with OpenText (formerly Vertica) software:
  • Faster analysis and reporting
  • The ability to load and analyze data concurrently
  • Greater business insight
  • Greater financial insight
  • Improved insight into customer behaviors
  • Increased amount and complexity of data analyzed
  • High availability for analytics systems
• Is able to analyze 100 – 500% more data at one time with OpenText (formerly Vertica).

OpenText (formerly Vertica) has enabled us to run an unorthodox ETL strategy based on generic columns which allow our engineers to quickly identify important data points and add that data to the data warehouse without support from the BI team. It has also enabled us to run complex reports and load data much faster (orders of magnitude) than our legacy databases.