Relatório de Estágio - Solução de BI Roaming Data Science (RoaDS) em ambiente Vodafone

A telecom company (Vodafone), had the need to implement a Business Intelligence solution for Roaming data across a wide set of different data sources. Based on the data visualization of this solution, its key users with decision power, can make a business analysis and needs of infrastructure and software expansion. This document aims to expose the scientific papers produced with the various stages of production of the solution (state of the art, architecture design and implementation results), this Business Intelligence solution was designed and implemented with OLAP methodologies and technologies in a Data Warehouse composed of Data Marts arranged in constellation, the visualization layer was custom made in JavaScript (VueJS). As a base for the results a questionnaire was created to be filled in by the key users of the solution. Based on this questionnaire it was possible to ascertain that user acceptance was satisfactory. The proposed objectives for the implementation of the BI solution with all the requirements was achieved with the infrastructure itself created from scratch in Kubernetes. This BI platform can be expanded using column storage databases created specifically with OLAP workloads in mind, removing the need for an OLAP cube layer. Based on Machine Learning algorithms, the platform will be able to perform the predictions needed to make decisions about Vodafone's Roaming infrastructure

Aviation organization strategy development in national airspace modernization

The purpose of this qualitative study was to determine how small sub-directorates within larger organizations develop strategy to accomplish expansive legacy infrastructure re-engineering. There is significant, historical academic inquiry on Technological Transitions (TT)s with respect to infrastructure modernization; the conversion of the National Airspace System from ground-based to space-based navigation is an example of a TT. There are also studies on how to re-engineer legacy software systems to continue supporting organizational needs. This study is intended to explore a case of re-engineering the expansive legacy ground-based navigation system in the United States by efficiently reducing the size of the network and expanding then verifying signal coverage on over 4.5 million square miles. It is not a pure TT, nor a pure software re-engineering, but rather a large-scale re-engineering of a pre-existing hardware and software infrastructure. It constitutes a nationwide effort to re-design and expand the legacy ground-based navigation system developed over 70 years. The Federal Aviation Administration (FAA) advised the public in 2011 that it intended to re-engineer and reduce the Very High Frequency Omnidirectional Range (VOR) network from 896 stations down to 593 stations - to be defined as the Minimum Operational Network (MON). This reduction was based on the premise that two-thirds of the legacy VORs would be retained but their coverage expanded to cover twice the airspace within the US than the previous network. The FAA Flight Program Operations (FPO) is a small sub-directorate within the larger organization that is now responsible to validate signal coverage on several million square miles of additional airspace. Understanding how the FPO develops strategy and leverages technology to support this endeavor can provide a repeatable template for future, expansive, legacy infrastructure re-engineering efforts. This study discovered that the FPO developed and iteratively evolved strategy to accomplish the VOR MON using tribal knowledge, subject matter expertise and accepted business re-engineering practices. The template can be applied to other legacy infrastructure re-engineering efforts to support forthcoming TTs

Semantic Navigation and Discussion in a Digital Boardroom

Well-designed interactive visualizations help users gaining insights into an organization's data and, finally, making decisions. In the Business Intelligence (BI) context, the most popular visualization approach is dashboards, which combine multiple visual components, such as charts, on a single view. Well-founded decisions require the collaboration of several analysts, such as domain experts, line-of-business managers, or key suppliers. For face-to-face collaboration settings, multi-display environments and smart meeting rooms have improved. In the BI context, support for boardrooms is being discussed for this setting. In this paper, we propose annotation dashboards, based on a multitouch and multiuser interaction approach, which are integrated in a multi-display environment constituting a BI digital boardroom. In addition, means of semantic navigation help business users to easily get insights into business context information

Semantic Navigation and Discussion in a Digital Boardroom

Well-designed interactive visualizations help users gaining insights into an organization's data and, finally, making decisions. In the Business Intelligence (BI) context, the most popular visualization approach is dashboards, which combine multiple visual components, such as charts, on a single view. Well-founded decisions require the collaboration of several analysts, such as domain experts, line-of-business managers, or key suppliers. For face-to-face collaboration settings, multi-display environments and smart meeting rooms have improved. In the BI context, support for boardrooms is being discussed for this setting. In this paper, we propose annotation dashboards, based on a multitouch and multiuser interaction approach, which are integrated in a multi-display environment constituting a BI digital boardroom. In addition, means of semantic navigation help business users to easily get insights into business context information