Data analytics and Recommendation solution for telecom customers.
A prominent telecom company needed assistance in building their customized product for data analytics and recommendation tool using big data tools.
The primary goal of the system was to transform the existing system's data to newly developed scalable system for better analytics.
Consolidate the data generated from various sources using Distributed Messaging Queue.
Optimize the extraction and data loading process and stage the data in columnar database.
Perform aggregation of data from columnar database to data warehouse.
Perform analytics on top of data warehouse using distributed SQL queries.
Customize the ETL product as per requirement.
There were multiple challenges while developing the solution like,
Collecting & processing massive amount of CDRs.
Providing fault tolerant searching solution on top of massive amount of data.
Delivering minute level in depth data analytics on top of millions of records.
The high level flow diagram of our proposed system is shown below.
We followed an iterative model approach to implement the solution that included the following phases:
Business requirements analysis.
Developed the ETL (Extract, Transform and Load) Suit.
The system delivered various benefits to different teams of organization in visualizing the end to end data as well as troubleshooting various aspects from engineering, finance, technical, IT etc.
Our solution delivered performance gain upto 14% and various new features which were requested by various customers as well as in house teams.
Contact us for your business needs anytime and our support team will be available to you 24 * 7 to answer your queries.