Business Intelligence for Academic Management Systems: Results of a Study in a Brazilian Federal University
Resumo
Context: Brazilian public universities require managing vast and diverse academic and administrative information. The government requires periodic reports about finances, education, research, and social impact to obtain enough economic resources for universities’ continuous operations. Additionally, since the approval of the National Law nº 12.527 (LAI - Lei de Acesso à Informação) of 2012, all public organizations must provide information as requested by any civilian, public, or private organization. Problem: Answering diverse information requests by public universities demands a lot of time and effort from public officials since, to produce a report, they must consult different systems and documents. These tasks increase the workload of public employees, which is repetitive and manual work. Solution: This work investigates the information necessities of public universities in Brazil to manage their academic sectors strategically, using Business Intelligence (BI) techniques. IS Theory: This work was developed using organizational information processing theory, which helps to understand how information is processed and exchanged within organizations and among their members. Method: Observations and semi-structured interviews were conducted with experts working in a public university’s academic sector. The interviews were transcripted, and topic analysis was conducted to identify necessary functional and non-functional requirements. Results: Requirements were specified using the Personas method, containing stakeholders’ needs, motivations, and goals for using a BI solution. Moreover, the required structured, semi-structured, and non-structured data to support operational, managerial, and strategic activities in the academic sector were identified. A preliminary conceptual model of the BI solution is also proposed. Additionally, important data integrations among university sectors were defined. Contributions: The results of this study are hoped to be used as an asset to define a BI solution to support academic management in Brazilian public universities. As a future work, it is intended to develop an initial BI tool and create a national reference architecture to guide the development of these solutions.
Referências
Ana Azevedo, José Manuel Azevedo, and Michelle Eiko Hayakawa. 2021. Designing and Implementing a Dashboard with Key Performance Indicators for a Higher Education Institution.. In CSEDU (1). 165–172.
Jacqueline Bichsel. 2012. Analytics in higher education: Benefits, barriers, progress, and recommendations. EDUCAUSE Center for Applied Research.
Clodis Boscarioli, Renata Mendes de Araujo, Rita Suzana Maciel, Valdemar Vicente Graciano Neto, Flavio Oquendo, Elisa Yumi Nakagawa, Flavia Cristina Berrnardini, José Viterbo, Dalessandro Vianna, Carlos Bazilio Martins, et al. 2017. I GranDSI-BR: Grand Research Challenges in Information Systems in Brazil 2016-2026. (2017).
Wadii Boulila, Muhib Al-Kmali, Mohammed Farid, and Hamzah Mugahed. 2023. A business intelligence based solution to support academic affairs: case of Taibah University. Wireless Networks (2023), 1–8.
Wilson Castillo, Fernando Medina Quispe, and Francisco Fariña Molina. 2018. Una metodología para procesos data warehousing basada en la experiencia. (2018).
Luz Yamile Caicedo Chacón, Cristian Noé Cárdenas Parra, Juan Sebastián Müller Rueda, and Jeniffer Tatiana Ortiz Bernal. 2019. Aplicación para la gestión y el análisis de información relacionada con la deserción estudiantil universitaria. Revista Colombiana de Computación 20, 2 (2019), 6–19.
Presidência da República do Brasil. 2011. LEI Nº 12.527, DE 18 DE NOVEMBRO DE 2011. Casa Civil. Subchefia para Assuntos Jurídicos., Brasília, Brasil. [link]
Presidência da República do Brasil. 2018. LEI Nº 13.709, DE 14 DE AGOSTO DE 2018. Casa Civil. Subchefia para Assuntos Jurídicos., Brasília, Brasil. [link]
Ernani Vinicius Damasceno, Ana Azevedo, and Agostinho Sousa Pinto. 2018. Business Intelligence-Implantation on Federal Institute of Triângulo Mineiro (IFTM) System. In In Proceedings of the 10th International Conference on Computer Supported Education (CSEDU 2018)-Volume 2. 528–535.
Abdelhamid El Malki and Samira Touate. 2024. An overview of human and organizational determinants in business intelligence adoption. Multidisciplinary Reviews 7, 11 (2024). DOI: 10.31893/multirev.2024253 Cited by: 0.
José Carlos Abbud Grácio. 2012. Preservação digital na gestão da informação: um modelo processual para as instituições de ensino superior. [link] (2012), 214–p.
Jolana Gubalová. 2015. The use of Business Intelligence Tools for leadership and university administration. In 2015 13th International Conference on Emerging eLearning Technologies and Applications (ICETA). IEEE, 1–7.
Preeti Gupta, Deepti Mehrotra, and TK Sharma. 2015. Identifying knowledge indicators in higher education organization. Procedia Computer Science 46 (2015), 449–456.
Waqar Haque. 2018. An Interactive Framework to Allocate and Manage Teaching Workload using Hybrid OLAP Cubes. In 2018 IEEE 9th Annual Information Technology, Electronics and Mobile Communication Conference (IEMCON). IEEE, 694–700.
Olival de Gusmão Freitas Júnior, Victor Diogho Heuer de Carvalho, Petrucio Antonio Medeiros Barros, and Marcus de Melo Braga. 2022. Uma Experiência com Business Intelligence para apoiar a Gestão Acadêmica em uma Universidade Federal Brasileira. Revista Ibérica de Sistemas e Tecnologias de Informacão 46 (2022), 5–20.
Dorina Kabakchieva. 2015. Business intelligence systems for analyzing university students data. Cybernetics and Information Technologies 15, 1 (2015), 104–115.
Sergei Karabtsev, Roman Kotov, Ivan Davzit, and Evgeny Gurov. 2023. Building data marts to analyze university faculty activities using power BI. In E3S Web of Conferences, Vol. 419. EDP Sciences, 02014.
Devi Karolita, Jennifer McIntosh, Tanjila Kanij, John Grundy, and Humphrey O. Obie. 2023. Use of personas in Requirements Engineering: A systematic mapping study. Information and Software Technology 162 (2023), 107264. DOI: 10.1016/j.infsof.2023.107264
Adler Looks Jorge. 2005. Dealing with interviews when creating Personas: a practical approach. Student Interaction Design Research Conference (SIDER05) (January 2005), 129 – 138.
Zhanl Mamykova, Mukhtar Bolatkhan, Oksana Kopnova, Malika Zubairova, Natalya Surina, and Shyngys Rabat. 2021. Development of the information and analytical system of the university. Journal of Mathematics, Mechanics and Computer Science 112, 4 (2021).
Hichem Mezhoud. 2024. Requirements of adopting SMEs for business intelligence systems: A field study in the industrial zone of setif in Algeria. 125 – 154 pages. DOI: 10.4018/979-8-3693-1846-1.ch007 Cited by: 0.
Amalia R Miller and Catherine Tucker. 2014. Health information exchange, system size and information silos. Journal of health economics 33 (2014), 28–42.
Dedy Mirwansyah, Dewi Wulan Sari, et al. 2021. Implementation of Business Intelligence in Data and Information for Student Admission Process in Mulia University. In Journal of Physics: Conference Series, Vol. 1807. IOP Publishing, 012015.
Oswaldo Moscoso-Zea, Sergio Luján-Mora, et al. 2016. Datawarehouse design for educational data mining. In 2016 15th International Conference on Information Technology Based Higher Education and Training (ITHET). IEEE, 1–6.
Harold Arturo Combita Niño, Johana Patricia Cómbita Niño, and Roberto Morales Ortega. 2020. Business intelligence governance framework in a university: Universidad de la costa case study. International Journal of Information Management 50 (2020), 405–412.
James A. O’Brien and George M. Marakas. 2013. Administração de sistemas de informação. (15a ed.). Mc Graw Hill., Porto Alegre, Brasil.
Vincent Koon Ong, Yanqing Duan, and Stephen Jackson. 2012. Supporting institutional decision making with an intelligent student engagement tracking system. IADIS International Conference Information Systems.
Malhena Sánchez Peralta. 2018. Business Intelligence in E-learning, a case study of an Ecuadorian University. In 2018 XIII Latin American Conference on Learning Technologies (LACLO). IEEE, 29–32.
Roger S. Pressman. 2011. Engenharia de Software. Uma Abordagem Profissional. (7a ed.). The McGraw-Hill Companies, Inc., São Paulo, Brasil.
Marko Pribisalić, Igor Jugo, and Sanda Martinčić-Ipšić. 2020. Selecting a business intelligence solution that is fit for business requirements. 32nd Bled eConference Humanizing Technology for a Sustainable Society, BLED 2019 - Conference Proceedings (2020), 443 – 465. DOI: 10.18690/978-961-286-280-0.24 Cited by: 5; All Open Access, Bronze Open Access.
Hifza Qureshi, Anil Kumar Sagar, Rani Astya, and Gulshan Shrivastava. 2021. Big Data Analytics for Smart Education. 2021 IEEE 6th International Conference on Computing, Communication and Automation, ICCCA 2021 (2021), 650 – 658. DOI: 10.1109/ICCCA52192.2021.9666389 Cited by: 2.
Rémi Rampin and Vicky Rampin. 2021. Taguette: open-source qualitative data analysis. Journal of Open Source Software 6, 68 (2021), 3522. DOI: 10.21105/joss.03522
Caio Eduardo Ribeiro and Anna Izabel Joao Tostes Ribeiro. 2015. Methodology for generation of business intelligence platforms to university evaluation committees. In Proceedings of the annual conference on Brazilian Symposium on Information Systems: Information Systems: A Computer Socio-Technical Perspective-Volume 1. 187–194.
Alessandro Marco Rosini and Angelo Palmisano. 2016. Administração de sistemas de informação e a gestão do conhecimento. (2a ed.). CENGAGE Learning., São Paulo, Brasil.
Taha Samad-Soltani, Marjan Ghazisaeedi, Hossein Masoumi-Asl, Peyman Rezaei-Hachesu, Kayvan Mirnia, and Reza Safdari. 2017. A general approach to extract the business intelligence requirements of bio-surveillance systems. Annals of Tropical Medicine and Public Health 10, 4 (2017), 816 – 820. DOI: 10.4103/ATMPH.ATMPH_258_17 Cited by: 1.
Robert J SÊNCHEZ-TICONA, Oscar R ALCÊNTARA-MORENO, José A GOMEZ-AVILA, Marcelino TORRES-VILLANUEVA, Jhordan M ROMERO-ARCE, and Juan P SANTOS-FERNÊNDEZ. 2023. Inteligencia de negocios y la dinamización de la toma de decisiones en la gestión de egresados de una universidad estatal peruana. gestión 60 (2023), 37.
Forrest Shull, Janice Singer, and Dag I. K. Sjøberg. 2007. Guide to Advanced Empirical Software Engineering. Springer London. 388 pages. DOI: 10.1007/978-1-84800-044-5 Cited by: 0.
Christian Siemen, Nico Clever, Benjamin Barann, and Jörg Becker. 2018. Requirements elicitation for an inter-organizational business intelligence system for small and medium retail enterprises. Proceeding - 2018 20th IEEE International Conference on Business Informatics, CBI 2018 1 (2018), 129 – 138. DOI: 10.1109/CBI.2018.00023 Cited by: 11.
M. Skjott Linneberg and S. Korsgaard. 2019. Coding qualitative data: a synthesis guiding the novice. Qualitative Research Journal 19, 3 (2019), 259–270. DOI: 10.1108/QRJ-12-2018-0012
Ian Sommerville. 2011. Engenharia de Software. (9a ed.). Pearson Education do Brasil., São Paulo, Brasil.
Ramos Somya, Danny Manongga, and Magdalena A Ineke Pakereng. 2018. Service-oriented business intelligence (SoBI) for academic and financial data integration in university. In 2018 International Seminar on Application for Technology of Information and Communication. IEEE, 1–5.
Miguel A. Teruel, Roberto Tardío, Elena Navarro, Alejandro Maté, Pascual González, Juan Trujillo, and Rafael Muñoz-Terol. 2014. CSRML4BI: A goal-oriented requirements approach for collaborative business intelligence. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) 8824 (2014), 423 – 430. DOI: 10.1007/978-3-319-12206-9_36 Cited by: 4.
William Villegas-Ch, Xavier Palacios-Pacheco, and Sergio Luján-Mora. 2020. A business intelligence framework for analyzing educational data. Sustainability 12, 14 (2020), 5745.
Claes Wohlin, Per Runeson, Martin Höst, Magnus C Ohlsson, Björn Regnell, and Anders Wesslén. 2012. Experimentation in Software Engineering. Springer, Germany. DOI: 10.1007/978-3-642-29044-2
Mudasser Fraz Wyne, Jodi Reeves, Frank Xavier Montes, and Tom J Gurbach. 2015. Business Intelligence Dashboard for Academic Program Management. In 2015 ASEE Annual Conference & Exposition. 26–312.
Luzia Zorzal. 2016. Transparência das informações das universidades federais: estudo dos relatórios de gestão à luz dos princípios de boa governança na Administração Pública Federal. (2016). DOI: 10.26512/2015.12.T.19202