Major Pay TV Company – Centralizes Enterprise Reporting, Analytics and Campaign Management
Industry
Communications/Media/Entertainment (CME)
Company
Major Pay TV Customer
Solution
Customer Acquisition, Customer Retention, Campaign Management, Predictive Analytics, Business Intelligence Strategy, Data Warehousing
Bottom-Line Results
Estimated $20M in ROI benefits in the first year, $45M+ after two years through the acquisition and retention of customers using a scientific approach based on data-driven technologies.
Technology
- Sun Enterprise Systems
- Hitachi Storage Area Networks (SAN)
- Oracle DBMS
- Informatica Extract, Transform and Load (ETL)
- Cognos Online Analytical Processing (OLAP)
- Chordiant Campaign Management
Major Cable Operator Centralizes Enterprise Reporting, Analytics and Campaign Management
The organization owns and manages cable systems serving more than 13 million subscribers in 33 states. Passing approximately 26 million homes, the organization has the most technologically advanced and best-clustered cable systems in the country. Leveraging its leadership in innovation and quality customer care, the organization delivers advanced products and services such as video on demand, high-definition television, digital video recorders high-speed data and digital phone.
Goal:
Executives at the organization needed accurate metrics, trend analysis and campaign management consolidated from the company’s 30+ markets in order to make informed business decisions. Decision-makers recognized the necessity of an Enterprise Data Warehouse (EDW) to consolidate and harness the power of their data and transform it into a strategic asset. The company called on Clear Peak to develop and deploy the foundation of an EDW platform.
Obstacles:
Due to a decentralized infrastructure and difficulties translating proprietary, market-level codes to enterprise standards, the company couldn’t leverage its data to create a competitive advantage.
Solution:
Clear Peak designed and architected the organization’s enterprise data warehouse (EDW) platform to reduce the manual effort and reconciliation required to create standard, enterprise-level reporting. The solution provides the company with integrated historical enterprise information from its 30+ markets. It combines data points from systems across the country while transforming all market-level data to enterprise standards. In addition to building integrated knowledge and campaign management, Clear Peak worked to create the fully integrated self-service reporting required by specific parts of the business to analyze and act on key trends identified in customer data. It also provided executives with clear, up-to-date metrics and tools offering enterprise-level insight and creating a competitive advantage.
Bottom-Line Results:
Estimated $20M in ROI benefits in the first year, $45M+ after two years through the acquisition and retention of customers using a scientific approach based on data-driven technologies.
