Business KPIs Analysis Using Visual Basics
K. Nageswara Rao1, G.Veerendra Nath2, K. Tanmaya3, B. Roja4, B. Pravallika5, Sk. Nayeem Asla6
1K. Nageswara Rao, Assistant Professor, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India.
2G.Veerendra Nath, Assistant Professor, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India.
3K.Tanmaya, Student, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India.
4B. Roja, Student, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India.
5B. Pravallika, Student, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India. India
6Sk. Nayeem Aslam, Student, Department of Electronics and Communications Engineering, Koneru Lakshmaiah Education Foundation, Vaddeswaram, Andhra Pradesh, India.
Manuscript received on 04 April 2019 | Revised Manuscript received on 11 April 2019 | Manuscript Published on 26 April 2019 | PP: 147-151 | Volume-8 Issue-6S April 2019 | Retrieval Number: F60410486S19/19©BEIESP
Open Access | Editorial and Publishing Policies | Cite | Mendeley | Indexing and Abstracting
© The Authors. Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open-access article under the CC-BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
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.
Keywords: MSP (Mobile Service Provider), KPI (Key Performance Indicator), CEI (Customer Experience Indicator), CEM (Customer Experience Management), QOE (Quality of Experience).
Scope of the Article: Communication