Data analytics: desenvolvimento de dashboards de business intelligence para a tomada de decisões baseadas em dados, aplicação no setor comercial de uma indústria de suplementos alimentares

Abstract

The objective of this research is to explore the area of Data Analytics in the study and analysis of data, and together with Business Intelligence tools, identify the best applications and build a project in the commercial sector for a food supplements company, with this, it will be possible to answer what analysis will be needed to assist in monitoring the Objectives and Key Results (OKRs) in comparison with the sales performance of this business. This research is framed as a case study and can be considered of an applied and descriptive nature, in this sense, it aims to collect data from the commercial sector of a company in the field of the food supplements industry, analyze, cross-reference the data and provide strategic information for decision-making following some development steps, which are: identify objectives, map data sources, execute ETL processes, develop dashboards and analyze the results obtained. As a result, a Business Intelligence application was developed using Microsoft Power BI software, integrating the company's various data sources and providing dashboards that enable real-time monitoring of goals through the analysis of indicators. Through this work, management was able to obtain several decisive insights to achieve the goals established in the period.