Paper Smart Cities data analysis with Power BI and R

Abstract

Currently the transformation of a city involves the participation of users through all media and especially through communication networks and social networks. Right now, the pandemic waves of COVID-19, and the phases of confinement, oriented users to communicate through social networks specifically Twitter in which they shared their feelings, and the behavior of their situation in the face of the pandemic. When talking about sharing sentiment information on social networks we are talking about a large volume of information that is posted on the networks that can be processed and analyzed using technological tools including RStudio to collect and process; and Power BI to analyze and visualize. The methodology presented has been the result of a process of investigation of related works focused on the participations of the users of a city in Ecuador downloading data from the Social Network Twitter. The methodology is composed of the phases of collecting, storing, transforming, analyzing and visualizing, and the development and execution of the proposal, leaving solid foundations for the implementation of an intelligent campus prototype that combines technological tools and the analysis of information that supports decision making and information analysis. (Abstract)