Storytelling de dados: contando histórias com Dashboards

• Autor(a) principal: Farias, Eduardo
• Data de Publicação: 2020
• Tipo de documento: Trabalho de conclusão de curso
• Idioma: por
• Título da fonte: Repositório Universitário da Ânima (RUNA)
• Texto Completo: https://repositorio.animaeducacao.com.br/handle/ANIMA/16807
• topic: Data Warehouse; Business Intelligence; Dashboard; Storytelling; Modelagem Dimensional; Visualização de Dados

The Dashboard is a visual data presentation tool with well-defined objectives and incorporating a Business Intelligence solution. A Business Intelligence solution should improve decision making by providing quality data, for which the Dashboard should reveal insights that point to a correct decision. On many occasions Dashboards do not deliver their goals. They are developed out of context and are not created with your target audience in mind. They are also developed using inadequate or poorly designed data visualization capabilities. In some cases they are implemented without an orderly structure for the most important criteria and that require more attention. This work aims to develop a Dashboard for a Business Intelligence solution applying Data Storytelling techniques and concepts. For that, it was conceptualized on Business Intelligence, Dashboard and Data Storytelling. The importance of presenting the data in a correct context and of getting to know your target audience was described, as well as the importance of employing the correct data visualization and narrative techniques. Each data has its best way of being presented, the choice of the correct graph is fundamental for the objectives to be achieved. To apply and validate the concepts, an experiment was applied through a Business Intelligence solution for the case study company. As a first step, a requirements analysis and survey of indicators for the modeling of dimensional data and construction of the Data Warehouse (DW) was carried out. Moving on to the ETL process where the data was extracted, transformed and loaded into the DW. With the data ready and the requirements raised it was possible to develop a Dashboard applying the concepts of Data Storytelling. As a result we have a BI solution that meets the needs of the company's case study director, with a Dashboard that fulfills its proposed objective, making decision making faster and more accurate. The use of Data Storytelling on the Dashboard provided a clear visualization and evidenced the status of the main indicators. In addition, the Dashboard was able to guide, in a preliminary way, what can be done to revert the bad state revealed by an indicator. In this way it was found that the application of a data narrative, consistent with the context of the company and target audience, as well as the appropriate use of visual elements, basic concepts for a good data Storytelling, brought expressive results in the development of the Dashboard for monitoring business.