Elaboración, recopilación, análisis y presentación de los KPIs de una red enmallada simulada en GNS3 por medio de herramientas de Excel, Python y Tableau.

Abstract

This degree work proposes the elaboration of a mesh network in GNS3, which is configured with the routing protocol OSPF (dynamic routing protocol). This network is composed of 7 routers which have the router ID according to the IP of its Loopback interface, then the KPIs of the chassis, route source, ospf neighbors, interfaces, cpu and memory and some others are extracted. The KPIs are changed according to the three proposed scenarios and by means of Python scripts an Excel is then generated, and with the Excel file the data of the different variables are loaded to Tableau where the formats are changed, they are calculated and managed according to their location in the corresponding axes to elaborate the dashboards referring to the KPIs showing graphs in an interactive way for the user, consecutively the respective analysis of the network is performed to obtain the results of the proposed scenarios.