Business intelligence aplicado ao comércio eletrônico
Carregando...
Data
2021-06-17
Tipo de documento
Monografia
Título da Revista
ISSN da Revista
Título de Volume
Área do conhecimento
Ciências Exatas e da Terra
Modalidade de acesso
Acesso aberto
Editora
Autores
Diogo Scheidemantel Ganzo, Eduardo Schroeder de Lacerda
Orientador
Morales, Aran Bey Tcholakian
Coorientador
Resumo
O comércio eletrônico vem ganhando muita força nos últimos anos, e com isso vem causando grande aumento na competitividade do setor. O varejo no meio digital, em relação ao varejo tradicional, possui uma maior densidade de informações e grande facilidade para capturá-las. Toda ordem de compra, até cliques no website, gera informações importantes que podem ser utilizadas para auxiliar no processo de tomada de decisão. Para organizar as informações, e ficar à frente de seus concorrentes, empresas estão adotando as práticas de Business Intelligence (BI). Este trabalho tem como objetivo a construção de uma arquitetura de BI utilizando dados da Olist, uma grande loja em marketplaces no Brasil como apoio para o processo decisório. A arquitetura consiste na criação de um Data Warehouse (DW), na criação do processo de Extrac, Transform and Load (ETL) e a criação de um dashboard para visualização de dados. Cada etapa teve o auxílio de uma ferramenta específica, a modelagem do DW foi feita no Power Architect, o processo ETL foi feito no Pentaho Data Integration, a base de dados foi armazenada no PostgreSQL e o dashboard foi feito no PowerBI. Com toda arquitetura desenvolvida, foi realizada uma entrevista com um profissional da área para validar as regras de negócio e os objetivos do trabalho.
E-commerce has been gaining a lot of strength in the last few years, and with that it has caused a great increase in the competitiveness of the sector. Retailing in the digital environment, in relation to traditional retailing, has a higher density of information and a greater facility to capture it. Every purchase order, even clicks on the website, generates important information that can be used to assist in the decision-making process. To organize information, and stay ahead of their competitors, companies are adopting Business Intelligence (BI) practices. This work aims to build an Intelligent Business architecture using data from Olist, a large store in brazilian marketplaces, as support for the decision-making process. The architecture consists in the creation of a Data Warehouse (DW), the creation of the Extrac, Transform and Load (ETL) process and the creation of a dashboard for data visualization. Each step was assisted by a specific tool, DW modeling was done in Power Architect, the ETL process was done in Pentaho Data Integration, the database was stored in PostgreSQL and the dashboard was made in PowerBI. With all the architecture developed, an interview was carried out with a professional in the area to validate the business rules and the objectives of the work.
E-commerce has been gaining a lot of strength in the last few years, and with that it has caused a great increase in the competitiveness of the sector. Retailing in the digital environment, in relation to traditional retailing, has a higher density of information and a greater facility to capture it. Every purchase order, even clicks on the website, generates important information that can be used to assist in the decision-making process. To organize information, and stay ahead of their competitors, companies are adopting Business Intelligence (BI) practices. This work aims to build an Intelligent Business architecture using data from Olist, a large store in brazilian marketplaces, as support for the decision-making process. The architecture consists in the creation of a Data Warehouse (DW), the creation of the Extrac, Transform and Load (ETL) process and the creation of a dashboard for data visualization. Each step was assisted by a specific tool, DW modeling was done in Power Architect, the ETL process was done in Pentaho Data Integration, the database was stored in PostgreSQL and the dashboard was made in PowerBI. With all the architecture developed, an interview was carried out with a professional in the area to validate the business rules and the objectives of the work.
Palavras-chave
Business Intelligence, Comércio Eletrônico, Dashboard