The Story
As one of the leading telecommunication providers offering wireline and wireless services to millions of customers across the globe. Its public-facing website is visited by millions of people each month and functions as one of the company’s most important marketing communications vehicles. The site allows the client to offer thousands of pages of searchable information about its products and services directly to the public. It also serves as a virtual storefront, enabling the company to engage customers and transact business with them daily.
The Challenge
With millions of interactions on a daily basis, the data generated through clickstream data has exploded into terabytes quickly. Gaining insightful intelligence through a traditional data warehouse became unmanageable due to a lack of adequate design and highly scalable solutions. The sheer volume of data collected created issues, and consequently, the performance of the database became sluggish, and queries started to take days to process.
Our Solution
The company turned to Centennial to assess and recommend a more robust solution that would improve its analytical capability and overall performance. Centennial conducted an end-to-end assessment of existing requirements, infrastructure components, and tools used for reporting and analytics, thus comparing the results with the industry’s leading practices and tools. Centennial proposed various “Big Data” alternatives and recommended Vertica Analytics Platform along with Hadoop that supported real-time querying and loading, advanced in-database analytics, and sophisticated storage and execution functionality to speed queries 50 to 1,000 times faster than traditional databases.
Results:
As a result of Centennial’s “Big Data” solution, which easily accommodates billions of rows of clickstream data and delivers enhanced analytics capabilities, the company was able to quickly correlate events across its business units and insights into how website functionality is affecting user interactions. With that business intelligence and decision support system, the company:
- Improved data analytics capabilities for Business users.
- Reduced report requests to the IT division by 60%.
- Reduced data extraction by 80%.
- Analyze data with billions of rows within seconds.
Curious to learn more? Contact Us!