Estudo sobre o uso de ferramentas de inteligência de negócios para análise de dados abertos da área da saúde

Abstract

With the current access to information laws, any citizen can view information related to public administration, bringing the possibility that any interested person can carry out analyzes on this data, bringing a clearer picture of the actions of the different spheres of government. There are already some initiatives where public data are processed in order to transform them into useful information for society and/or publicize this data. One of the areas of public administration where this is necessary is the area of health. The visualization of this data is related to an area called Business Intelligence (BI, or Business Intelligence). Business Intelligence is an umbrella term that encompasses architectures, tools, databases, applications and methodologies. The objective of the Business Intelligence area is to provide information that facilitates analysis and helps in decision making. There are several Business Intelligence tools, including Microsoft's Power BI and Google's Data Studio. Thus, this work presents a comparative study between these tools, using open health data. For the development of this study, firstly, a theoretical presentation of Business Intelligence concepts related to this work is carried out. Next, obtaining data and its use in the development of a data warehouse is described, reporting the transformations performed on them. In the next step, the use of the data warehouse in the development of data visualization panels in the two studied tools is documented, where we sought to maintain the maximum similarity between the panels of each tool so that it was possible to perceive the differences in each tool. Finally, the differences found are described and analyzed, indicating the characteristics, strengths, and weaknesses of each of the tools studied.