The Integration of Alteryx® and Microsoft Power BI®: A Case Study
Tipo
Artigo de evento
Data de publicação
2022
Periódico
Smart Innovation, Systems and Technologies
Citações (Scopus)
1
Autores
Stopiglia F.S.
Sierra C.C.
de Figueiredo R.J.F.
de Oliveira Igarashi M.
Sierra C.C.
de Figueiredo R.J.F.
de Oliveira Igarashi M.
Orientador
Título da Revista
ISSN da Revista
Título de Volume
Membros da banca
Programa
Resumo
© 2022, The Author(s), under exclusive license to Springer Nature Switzerland AG.Many companies have been seeking competitive advantages over their competitors in various market segments. The insertion of intelligence in the automation processes is one of the points that allow this potentializing. Thus, the automation of data analysis has been gaining more relevance, and the ETL software tools (Extract, Transform, and Load) such as Alteryx Designer® gives the flexibility to overcome complexity and encourage users to find more valuable insights. Therefore, this study aims to highlight the integration of Alteryx Designer® and Microsoft Power BI®, especially for classification analysis. For this purpose, a classificatory model based on a logistic regression tool was used to manipulate production orders from an eyewear frames factory located in the region of Campinas - Brazil. The analysis shows that 88,3% of data is accurately loaded to the target system as per the expectation and 90,7% of data is loaded with precision in the destination system according to expectations. It can contribute to the improvement in the decision-making process. The goals were achieved, and it is concluded that this type of analysis and model help to promote greater efficiency to the business decision making, reducing costs and optimizing time.
Descrição
Palavras-chave
Assuntos Scopus
Automation process , Case-studies , Classification analysis , Competitive advantage , ETL , Logistics regressions , Market segment , MicroSoft , Power , Software-tools