Telecom
Middle East
Alteryx, Tableau
Our client is a regulatory body that oversees the telecom sector and the licensees in a Middle Eastern nation in accordance with the Federal Laws applicable. It is an independent body, and its duties include ensuring telecom services are made available to all regions of the country, assuring that the licensed operators fully follow established rules and regulations to ensure sustainability, competitiveness and transparency among the service providers, customers and shareholders.
The customer service model of the authority was plagued by recurring issues which resulted in negative impact on the customer satisfaction. This, in turn, caused issues in enforcement, compliance and monitoring.
A machine learning model for dynamic customer happiness index prediction was identified as the solution to effectively monitor and plug the gaps in service delivery.
The solution was modelled as a multi-pronged approach which involved:
The data architecture available at the client was unstructured. Also, it didn’t have any kind of data warehousing methodologies deployed, making it difficult to structure the variables as well as coming up with an ETL strategy.
This bottleneck was overcome with the use of Alteryx Designer in the data preparation process by creating analytic workflows easily with the readily available no-code, low-code automation building blocks. The analytic flows were created in an incremental fashion with lucid and detailed documentation at each step, to future-proof the solution for end user engagement.
The analytic flows considerably reduced the manual effort (≈ 90%) involved in the variable selection while completely eliminating the effort involved in the variable calculation.
The Machine learning model is an essential part of the solution because it can analyze bigger and more complex data while delivering faster, more accurate results at larger scales. The identified model for this solution was the Decision Tree algorithm. Decision Trees are a supervised learning technique that predicts values of responses by learning decision rules derived from features. The model was designed using python and deployed in the Alteryx workflow making use of its in-built integration feature.
The Alteryx server was used to scale and deploy the functionality across organization as well as to schedule the same for recurring results corresponding to updates in data over pre-defined periods. In this case, a weekly periodicity was implemented.
The decision tree algorithm was used to find out the underlying parameters that contribute to customers’ happiness. The model provides the best combination of services that are to be constantly monitored and delivered to ensure customer satisfaction.
The data so generated have been visualized using the Tableau Desktop using its market-leading capabilities for businesses to discover and share insights. The backend data have been dynamically integrated with the Alteryx workflow to reflect the updated data from each periodic run.
Today, the model can predict the satisfaction variance of customer with an accuracy of 94%.
Back
