Business e Analytics Intelligence: Revisão Sistematizada das Funcionalidades e Aplicações do Qlik Sense e Microsoft Power BI
Resumo
Ferramentas de análise e inteligência de negócios têm se tornado peças-chave no processo de tomada de decisões nos negócios. Este estudo visa relacionar as principais funcionalidades e aplicações de duas ferramentas de Business Intelligence: Qlik Sense e Microsoft Power BI. Para isso, foi realizada uma revisão sistematizada utilizando as ferramentas StArt e VOSviewer. Foram analisadas 62 publicações dos últimos 10 anos, as quais demonstram que as ferramentas têm sido aplicadas em diversos estudos ao redor do mundo, mas nem sempre com suas funcionalidades detalhadas.
Palavras-chave:
Inteligência de negócios, Qlik Sense, Microsoft Power BI
Referências
Abrahamyan, G.; Atayan, A.; Sharabaeva, L.; Gureva, T. 2021. Model of an intelligent system for managing the process of developing the competencies of industrial enterprise employee's competencies. Journal of Physics: Conference Series.
Al Tunaiji, H.; Al Qubaisi, M.; Dalkilinc, M.; Almahmeed, W.; Baltatu, O.C. (2020). Impact of COVID-19 Pandemic Burnout on Cardiovascular Risk in Healthcare Professionals Study Protocol: A Multicenter Exploratory Longitudinal Study. Frontiers in Medicine. DOI: 10.3389/fmed.2020.571057.
Andriansyah, D., Nulhakim, L. (2020). The Application of Power Business Intelligence in Analyzing the Availability of Rental Units. Journal of Physics: Conference Series. 1641(1),012019.
Ayad, H.A.; Al-kilani, L.A.; Arshad, R.; Hussein, H.T.; Kucukvar, M. (2020). Developing an Interactive Data Visualization Platform to Present the Adaption of Electrical Vehicles in Washington, California and New York. 7th International Conference on Industrial Engineering and Applications.
Banks, J.; Corrigan, D.; Grogan, R.; Delanty, N.; Doherty, C.P. (2021). LoVE in a time of CoVID: Clinician and patient experience using telemedicine for chronic epilepsy management. Epilepsy and Behavior. DOI: 10.1016/j.yebeh.2020.107675.
Barbieri, S.; Omizzolo, L.; Tredese, A.; Dolcet, A.; Feltracco, P. (2018). The rise of new alcoholic games among adolescents and the consequences in the emergency department: Observational retrospective study. JMIR Pediatrics and Parenting.
Barker, R.; Lombardino, J.; Rasmussen, KAI.; Gilroy, S. (2020). Test of Arabidopsis Space Transcriptome: A Discovery Environment to Explore Multiple Plant Biology Spaceflight Experiments. Frontiers in Plant Science. DOI: 10.3389/fpls.2020.00147
Bello, I.M., Sylvester, M., Ferede, M., Anyuon, A., Oluseun, O.O. (2021). Real-time monitoring of a circulating vaccine-derived poliovirus outbreak immunization campaign using digital health technologies in South Sudan. Pan African Medical Journal.
El Firdoussi, S.; Lachgar, M.; Kabaili, H.; Goujdami, D.; El FIrdoussi, L. (2020). Assessing Distance Learning in Higher Education during the COVID-19 Pandemic. Education Research International. DOI: 10.1155/2020/8890633.
Frydrychowicz, A.; Boppel, T.; Sieber, V.; Barkhausen, J.; Amthor, T. (2021). Automatic, log file-based process analysis of a clinical 15T MR scanner: A proof-of-concept study. RoFo Fortschritte auf dem Gebiet der Rontgenstrahlen und der Bildgebenden Verfahren.
Gartner. Self-service Analytics. (2020). Disponível em: [link] Acesso em: 05 jan. 2023.
Ghosh, S.; Neha, K. (2019). Social Media Analytics using Qlik Connectors. International Journal of Recent Technology and Engineering (IJRTE), Vol. 8.
Gruber, T. (1995). Toward principles for the design of ontologies used for knowledge sharing. International Journal Human–Computer Studies. pp. 907–928, 1995.
Gupta, P., Ladia, H., Kakkar, K., Mamgain, R., Gaur, N. (2021). Implementation of demand forecasting – A comparative approach. Journal of Physics: Conference Series. 1714(1),012003.
Ibrahim, H.; Sorrell, S.; Nair, S.C.;Al Mazrouei, S.; Kamour, A. (2020). Rapid development and utilization of a clinical intelligence dashboard for frontline clinicians to optimize critical resources during COVID-19. Acta Informatica Medica. DOI: 10.5455/aim.2020.28.209-213.
Krugh, M.; Mears, L. (2021). Pervasive environmental sensing for Industry 4.0 as an educational tool. Procedia Manufacturing. 53, pp. 790-801.
Kumar, A.; Kalra, Y.; Guan, W.W.; Tibreal, V.; Bata, R.; Chen, A.F. (2021). COVID-19 impact on excess deaths of various causes in the United States. Annals of GIS. DOI: 10.1080/19475683.2021.1982001.
Lakshaga Jyothi, M.; Shanmugasundaram, R.S.C. (2021). Design and implementation of intelligent classroom framework through light-weight neural networks based on multimodal sensor data fusion approach. Revue d'Intelligence Artificielle.
Lima, V.D.O.; Gois, J.M.V.A. (2020). Forensic intelligence approach on traffic accidents in the brazilian federal district. WIT Transactions on the Built Environment. 200, pp. 143-153.
Mirwansyah, D., Riyayatsyah, Sari, D.W. (2021). Implementation of Business Intelligence in Data and Information for Student Admission Process in Mulia University. Journal of Physics: Conference Series. 1807(1),012015.
Mutanov, G., Mamykova, Z., Kopnova, O., Bolatkhan, M. (2020). Applied research of data management in the education system for decision-making on the example of Al-Farabi Kazakh National University. E3S Web of Conferences.
Ovchinnikov, D.A., Sviridov, E.E., Potapov, I.V., Konradi, A.O. (2021). Outpatient unit scheduling: decision-making support system to increase availability of specialized care and volume of medical services. Medical Technologies. Assessment and Choice. pp. 36-43.
Reid, N.E.; Johnson-Arbor, K.; Smolinske, S.; Litovitz, T. (2020) WebPOISONCONTROL data summary. American Journal of Emergency Medicine. 54, pp. 184-195.
Roskladka, A., Roskladka, N., Karpuk, A., Stavytskyy, A., Kharlamova, G. (2020). The data science tools for research of emigration processes in Ukraine. Problems and Perspectives in Management. 18(1), pp. 70-81.
Sharaf Addin, E.H , Admodisastro, N. , Mohd Ashri, SNS , Kamaruddin, A. , Chong, YC. (2022). Customer Mobile Behavioral Segmentation and Analysis in Telecom Using Machine Learning. Applied Artificial Intelligence.
Telaga, A., Librianti, A.F., Umairoh, U.2019. Sales prediction of Four Wheelers Unit (4W) with seasonal algorithm Trend Decomposition with Loess (STL) in PT. Astra International, Tbk. IOP Conference Series: Materials Science and Engineering.
Tiozzo, B.; Ruzza, M.; Rizzoli, V.; D'este, L.; Giaretta, M.; Ravarotto, L. Biological, Chemical, and Nutritional Food Risks and Food Safety Issues From Italian Online Information Sources: Web Monitoring, Content Analysis, and Data Visualization. J Med Internet Res. (2020). DOI: 10.2196/23438.
Tonrangklang, P.; Therdyothin, A.; Preechawuttipong, I. (2022). The financial feasibility of compressed biomethane gas application in Thailand. Energy, Sustainability and Society.
Ulloa, P.A.G.; Castillo, D.V.C.; Mena, V.M.P.; Jacome, D.J.R. (2020). Business intelligence in the administrative management of a distribution company in the electricity sector. o. 3C TIC. Cuadernos de desarrollo aplicados a las TIC, 9(3), 4367. 2020. DOI: 10.17993/3ctic.93.43-67.
Valsala, G.L.; Padmasuresh, L. (2014). A novel unified power quality conditioning system for power quality improvement and bidirectional power flow control for windmill. Research Journal of Applied Sciences, Engineering and Technology.
Vargas-Terranova, C.; Rodrigo-Ilarri, J.; Rodrigo-Clavero, M.-E.; Rozo-Arango, M. (2022). M-GRCT: A Dynamic Circular Economy Model for the Optimal Design of Waste Management Systems in Low-Income Municipalities. International Journal of Environmental Research and Public Health. 19(5),2681.
Voda, M.; Murgu, A.; Sarpe, C.A.; Graves, S.M.; Avram, C. (2021). The Țigani community adaptability to changes in rural romania and the covid-19 impact. International Journal of Environmental Research and Public Health. DOI: 10.3390/ijerph182010622.
Al Tunaiji, H.; Al Qubaisi, M.; Dalkilinc, M.; Almahmeed, W.; Baltatu, O.C. (2020). Impact of COVID-19 Pandemic Burnout on Cardiovascular Risk in Healthcare Professionals Study Protocol: A Multicenter Exploratory Longitudinal Study. Frontiers in Medicine. DOI: 10.3389/fmed.2020.571057.
Andriansyah, D., Nulhakim, L. (2020). The Application of Power Business Intelligence in Analyzing the Availability of Rental Units. Journal of Physics: Conference Series. 1641(1),012019.
Ayad, H.A.; Al-kilani, L.A.; Arshad, R.; Hussein, H.T.; Kucukvar, M. (2020). Developing an Interactive Data Visualization Platform to Present the Adaption of Electrical Vehicles in Washington, California and New York. 7th International Conference on Industrial Engineering and Applications.
Banks, J.; Corrigan, D.; Grogan, R.; Delanty, N.; Doherty, C.P. (2021). LoVE in a time of CoVID: Clinician and patient experience using telemedicine for chronic epilepsy management. Epilepsy and Behavior. DOI: 10.1016/j.yebeh.2020.107675.
Barbieri, S.; Omizzolo, L.; Tredese, A.; Dolcet, A.; Feltracco, P. (2018). The rise of new alcoholic games among adolescents and the consequences in the emergency department: Observational retrospective study. JMIR Pediatrics and Parenting.
Barker, R.; Lombardino, J.; Rasmussen, KAI.; Gilroy, S. (2020). Test of Arabidopsis Space Transcriptome: A Discovery Environment to Explore Multiple Plant Biology Spaceflight Experiments. Frontiers in Plant Science. DOI: 10.3389/fpls.2020.00147
Bello, I.M., Sylvester, M., Ferede, M., Anyuon, A., Oluseun, O.O. (2021). Real-time monitoring of a circulating vaccine-derived poliovirus outbreak immunization campaign using digital health technologies in South Sudan. Pan African Medical Journal.
El Firdoussi, S.; Lachgar, M.; Kabaili, H.; Goujdami, D.; El FIrdoussi, L. (2020). Assessing Distance Learning in Higher Education during the COVID-19 Pandemic. Education Research International. DOI: 10.1155/2020/8890633.
Frydrychowicz, A.; Boppel, T.; Sieber, V.; Barkhausen, J.; Amthor, T. (2021). Automatic, log file-based process analysis of a clinical 15T MR scanner: A proof-of-concept study. RoFo Fortschritte auf dem Gebiet der Rontgenstrahlen und der Bildgebenden Verfahren.
Gartner. Self-service Analytics. (2020). Disponível em: [link] Acesso em: 05 jan. 2023.
Ghosh, S.; Neha, K. (2019). Social Media Analytics using Qlik Connectors. International Journal of Recent Technology and Engineering (IJRTE), Vol. 8.
Gruber, T. (1995). Toward principles for the design of ontologies used for knowledge sharing. International Journal Human–Computer Studies. pp. 907–928, 1995.
Gupta, P., Ladia, H., Kakkar, K., Mamgain, R., Gaur, N. (2021). Implementation of demand forecasting – A comparative approach. Journal of Physics: Conference Series. 1714(1),012003.
Ibrahim, H.; Sorrell, S.; Nair, S.C.;Al Mazrouei, S.; Kamour, A. (2020). Rapid development and utilization of a clinical intelligence dashboard for frontline clinicians to optimize critical resources during COVID-19. Acta Informatica Medica. DOI: 10.5455/aim.2020.28.209-213.
Krugh, M.; Mears, L. (2021). Pervasive environmental sensing for Industry 4.0 as an educational tool. Procedia Manufacturing. 53, pp. 790-801.
Kumar, A.; Kalra, Y.; Guan, W.W.; Tibreal, V.; Bata, R.; Chen, A.F. (2021). COVID-19 impact on excess deaths of various causes in the United States. Annals of GIS. DOI: 10.1080/19475683.2021.1982001.
Lakshaga Jyothi, M.; Shanmugasundaram, R.S.C. (2021). Design and implementation of intelligent classroom framework through light-weight neural networks based on multimodal sensor data fusion approach. Revue d'Intelligence Artificielle.
Lima, V.D.O.; Gois, J.M.V.A. (2020). Forensic intelligence approach on traffic accidents in the brazilian federal district. WIT Transactions on the Built Environment. 200, pp. 143-153.
Mirwansyah, D., Riyayatsyah, Sari, D.W. (2021). Implementation of Business Intelligence in Data and Information for Student Admission Process in Mulia University. Journal of Physics: Conference Series. 1807(1),012015.
Mutanov, G., Mamykova, Z., Kopnova, O., Bolatkhan, M. (2020). Applied research of data management in the education system for decision-making on the example of Al-Farabi Kazakh National University. E3S Web of Conferences.
Ovchinnikov, D.A., Sviridov, E.E., Potapov, I.V., Konradi, A.O. (2021). Outpatient unit scheduling: decision-making support system to increase availability of specialized care and volume of medical services. Medical Technologies. Assessment and Choice. pp. 36-43.
Reid, N.E.; Johnson-Arbor, K.; Smolinske, S.; Litovitz, T. (2020) WebPOISONCONTROL data summary. American Journal of Emergency Medicine. 54, pp. 184-195.
Roskladka, A., Roskladka, N., Karpuk, A., Stavytskyy, A., Kharlamova, G. (2020). The data science tools for research of emigration processes in Ukraine. Problems and Perspectives in Management. 18(1), pp. 70-81.
Sharaf Addin, E.H , Admodisastro, N. , Mohd Ashri, SNS , Kamaruddin, A. , Chong, YC. (2022). Customer Mobile Behavioral Segmentation and Analysis in Telecom Using Machine Learning. Applied Artificial Intelligence.
Telaga, A., Librianti, A.F., Umairoh, U.2019. Sales prediction of Four Wheelers Unit (4W) with seasonal algorithm Trend Decomposition with Loess (STL) in PT. Astra International, Tbk. IOP Conference Series: Materials Science and Engineering.
Tiozzo, B.; Ruzza, M.; Rizzoli, V.; D'este, L.; Giaretta, M.; Ravarotto, L. Biological, Chemical, and Nutritional Food Risks and Food Safety Issues From Italian Online Information Sources: Web Monitoring, Content Analysis, and Data Visualization. J Med Internet Res. (2020). DOI: 10.2196/23438.
Tonrangklang, P.; Therdyothin, A.; Preechawuttipong, I. (2022). The financial feasibility of compressed biomethane gas application in Thailand. Energy, Sustainability and Society.
Ulloa, P.A.G.; Castillo, D.V.C.; Mena, V.M.P.; Jacome, D.J.R. (2020). Business intelligence in the administrative management of a distribution company in the electricity sector. o. 3C TIC. Cuadernos de desarrollo aplicados a las TIC, 9(3), 4367. 2020. DOI: 10.17993/3ctic.93.43-67.
Valsala, G.L.; Padmasuresh, L. (2014). A novel unified power quality conditioning system for power quality improvement and bidirectional power flow control for windmill. Research Journal of Applied Sciences, Engineering and Technology.
Vargas-Terranova, C.; Rodrigo-Ilarri, J.; Rodrigo-Clavero, M.-E.; Rozo-Arango, M. (2022). M-GRCT: A Dynamic Circular Economy Model for the Optimal Design of Waste Management Systems in Low-Income Municipalities. International Journal of Environmental Research and Public Health. 19(5),2681.
Voda, M.; Murgu, A.; Sarpe, C.A.; Graves, S.M.; Avram, C. (2021). The Țigani community adaptability to changes in rural romania and the covid-19 impact. International Journal of Environmental Research and Public Health. DOI: 10.3390/ijerph182010622.
Publicado
28/11/2023
Como Citar
ALVES, Leander; MARINS, Joyce; CUNHA, Vanice Canuto; REIS, Saulo S..
Business e Analytics Intelligence: Revisão Sistematizada das Funcionalidades e Aplicações do Qlik Sense e Microsoft Power BI. In: ESCOLA REGIONAL DE INFORMÁTICA DE MATO GROSSO (ERI-MT), 12. , 2023, Cuiabá/MT.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2023
.
p. 11-20.
ISSN 2447-5386.
DOI: https://doi.org/10.5753/eri-mt.2023.236039.
