Big Data Analytics solution for a Telecommunications leader in US.

The client is a large multi billion-dollar telecommunications service provider in the United States.

Challenge

The Telecom provider needed to better understand its marketplace and the behavior of its customers to remain ahead of its competition.

Solution

• Initial analysis indicated that a large scale Data Warehouse needs to be designed to gain insights into the company's operational data, finances, and profits.
• iGlades designed cloud-based Data Warehouse to deliver unprecedented analytical power to managers over a web interface.
• iGlades succeeded in providing access to large number of branch and field personnel across the Business Market units interactive, Web-based, historical views on data such as call traffic, call type, data circuits, revenue, expense information, customers, and product mixes.

Benefits

• Data Access - Data Warehouse facilitated reporting at senior management levels on details of composite financial information to better analyze company's contributions and profit margins.
• Information Analytics - Managers could access the system for reports on its customers, such as Top 100 gainers or decliners by product or geography, divided by domestic vs. international mix.
• Anomalies - Managers can also track and analyze "gaps," which are period-to-period changes in operational trends.
• Management Decisions - "How has the total utilization or the total sales or mix of a business changed over this period of time?" "Who are the customers who have the greatest gaps? What is driving this gap - a domestic or international mix change? A product change? A rate per minute change?" With verifiable answers to these kinds of questions, managers can make informed decisions.
• Decisions support systems - By leveraging this DSS system, managers can detect subtle problems earlier, or detect a material change in the behavior of a customer or an event in the marketplace. These abilities enabled the company to make timely business decisions that have resulted in significant financial impact.
• Business Drivers - Analyzing the data revealed the actual drivers behind events and helped discover situations that previously may have been overlooked, and acquiring a finer, more subtle understanding of customer utilization of the company's products.

Technologies used:

• Data Warehouse - Google Cloud
• Data Integration (ETL): Talend 3.x
• Business Intelligence - Apache Spark 3.x, Hadoop 3.x