Desenvolvimento de um sistema de apoio à decisão com técnicas de business intelligence em uma empresa de energia fotovoltaica

Abstract

Many micro and small companies have financial and technical limitations that prevent investment in information technology, which leads entrepreneurs to manage their companies without having control and essential information to do so. In this sense, this work is about the implementation of an Information System (IS) using Business Intelligence (BI) techniques and creation of a global performance indicator developed with the Analytic Hierarchy Process (AHP) in a small company in the photovoltaic market, located in the interior of the state of São Paulo. Furthermore, quality management tools were applied in order to solve two problems highlighted by the managers, one of delays in project delivery and the other of the high number of customer complaints. The use of all these tools to achieve results was structured based on the DMAIC methodology. This system was satisfactory from the point of view of managers, as it not only highlights the main performance indicators for each sector, but is also effective in bringing them together in the general report. The relationship between the tables made it possible to cross relevant and strategic information that are able to provide sufficient basis for decision making, contributing to the control of processes and resources reaching a level that makes the organization competitive. Therefore, the solution of these problems and the monitoring of their updates in the information system were successful, helping the company to become a reference in quality, efficiency, profitability and offering a good experience to customers, strategic objectives that the manager/owner want to achieve.