Relações públicas e trabalho formal: um dashboard através de business intelligence

Abstract

This work aimed to develop an interactive panel (Dashboard) with information from the public relations profession as a formal job. The study was carried out through the analysis of profession data and had as a database the RAIS portal (Annual Social Information Reports), which is a government platform that contains data from all active professions in the country. For the creation of the Dashboard, Business Intelligence tools were used, specifically Microsft Power BI, where the data were treated and modeled and later the creation was created. The project resulted in a panel with information from the public relations profession that presented information from the years 2010 to 2020, the cabinet has displays ranging from average wages to age range, covering all states of Brazil plus the federal district. Therefore, it was possible to transform data into knowledge and provide a service that serves as a reference for decision making.