The Integration of Alteryx® and Microsoft Power BI®: A Case Study

Página do item simplificado
dc.contributor.authorStopiglia F.S.
dc.contributor.authorSierra C.C.
dc.contributor.authorde Figueiredo R.J.F.
dc.contributor.authorde Oliveira Igarashi M.
dc.date.accessioned2025-05-01T06:48:07Z
dc.date.available2025-05-01T06:48:07Z
dc.date.issued2022
dc.description.abstract© 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.
dc.description.firstpage229
dc.description.lastpage235
dc.description.volume295 SIST
dc.identifier.doi10.1007/978-3-031-08545-1_21
dc.identifier.issnNone
dc.identifier.urihttps://dspace.mackenzie.br/handle/10899/40641
dc.relation.ispartofSmart Innovation, Systems and Technologies
dc.rightsAcesso Restrito
dc.subject.otherlanguageAutomation
dc.subject.otherlanguageClassification
dc.subject.otherlanguageETL
dc.subject.otherlanguageLogistic regression
dc.titleThe Integration of Alteryx® and Microsoft Power BI®: A Case Study
dc.typeArtigo de evento
local.scopus.citations1
local.scopus.eid2-s2.0-85135026872
local.scopus.subjectAutomation process
local.scopus.subjectCase-studies
local.scopus.subjectClassification analysis
local.scopus.subjectCompetitive advantage
local.scopus.subjectETL
local.scopus.subjectLogistics regressions
local.scopus.subjectMarket segment
local.scopus.subjectMicroSoft
local.scopus.subjectPower
local.scopus.subjectSoftware-tools
local.scopus.updated2025-05-01
local.scopus.urlhttps://www.scopus.com/inward/record.uri?partnerID=HzOxMe3b&scp=85135026872&origin=inward
Arquivos
Coleções
Artigos de periódico