Business kpis analysis using visual basics

Abstract

Moving from network-oriented towards customers and service- oriented operations is vital in order to improve business KPIs. In this project we will attempt to create a code/algorithm via machine learning (VBA) to test the KPIs and weed out the troublesome sites from a network’s traffic data dump spanning over a month. We will cover voice and data traffic of all the technologies- 2G, 3G, FDD-LTE and TDD-LTE. This will help identify the problematic sites thus addressing the customer’s problems. Once the identified sites are dealt with, the overall CEI increases. Integrating CEM efforts throughout the organization in MSPs is imperative in order to provide superior telecom services and to manage churn.