Development and Operation of an All-in-One IR System
DOI:
https://doi.org/10.52731/lir.v005.387Keywords:
Institutional Research, Data Lake, ETL, Automation, Information Support Cycle, Data Visualization, Higher EducationAbstract
In recent years, Institutional Research (IR) has become increasingly important for decisionmaking support in Japanese higher education institutions. This paper reports on the development and operation of an IR system at Kyushu Institute of Technology, which has been under construction since fiscal year 2022. The system integrates a data lake server with an ETL (Extract, Transform, Load) server to provide various functions including grade distribution visualization, automated infection report generation, and integration with academic affairs systems. The key feature of this system lies in its utilization of programmatically operable tools such as a data lake, an ETL Tool, a statistical software, and PDF creation to automate data collection, restructuring, analysis, and reporting processes within the information support cycle. This approach has improved operational efficiency and reduced costs at the university while establishing a foundation for data-driven decision-making. Future plans include system expansion with the introduction of data warehouse and BI tools.
References
R.D. Howard, Ed., “Institutional Research: Decision Support in Higher Education,” Tamagawa University Press, 2012.
Tetsuya Oishi, Eiichi Takata, and Masao Mori, “Current Status and Issues of IR Human Resource Development Curriculum - Focusing on the Verification of Efforts in Kyushu University,” Proceeding of Japan Society of Educational Information Annual Conference, Vol.31, pp.182-185, 2015.
Eiichi Takata, Tetsuya Oishi, and Masao Mori, “Verification of the IR Human Resource Development Curriculum at Kyushu University - Challenges and Future Directions after Two Years of Efforts,” University Management, 11(8), pp.43-50, 2015.
Tetsuya Oishi, Masao Mori, and Eiichi Takata, “Curriculum of Human Resource Development for Institutional Research in Japan,” The 14th Annual Hawaii International Conference on Education, 2016.
Masao Mori and Tetsuya Oishi, “Current Status and Issues of IR Theory at Professional Academy of Tokyo Institute of Technology,” Proceedings of 10th Meeting on Japanese Institutional Research, vol.10, pp.44-47, 2021.
Professional Academy of Tokyo Institute of Technology, “Institutional Research Theory,” https://www.academy.titech.ac.jp/course-category/ins (accessed 2nd April, 2025).
Yoshiharu Aioi, Shuntaro Iseri, Shotaro Imai, Tetsuya Oishi, Saori Okada, Nobuhiko Kondo, Toru Sugihara, Shintaro Tajiri, Mio Tsubakimoto, Keita Nishiyama, Takeshi Matsuda, Masao Mori, “Data Collection,” Standard Guidebook for University IR，Japan Association for Institutional Research, 2022, pp.122-126.
Shuntaro Iseri, Tetsuya Oishi, Nobuhiko Kondo, and Kunihiko Takamatsu, “Actual Conditions of Training Opportunities on IR in Japan - Based on Archived Data from Asagao ML,” Proceedings of 11th Meeting on Japanese Institutional Research, vol.11, pp.164-169, 2022.
Shuntaro Iseri, Tetsuya Oishi, Nobuhiko Kondo, and Kunihiko Takamatsu, “Training Opportunities and Required Skills for Institutional Research Programs in Japan,” SEAAIR 2023 Annual SEAAIR Conference Proceedings, Vol.3, pp.85-95, 2023.
Tetsuya Oishi, “A questionnaire survey for the development of a brand-new curriculum for the training of IR personnel,” Proceedings of 10th Meeting on Japanese Institutional Research, vol.10, pp.38-43, 2021.
Tetsuya Oishi, “What is the Essential Curriculum for IR in Japan?,” Proceedings - 2022 11th International Congress on Advanced Applied Informatics, IIAI-AAI 2022, Vol.001, LIR009, pp.1-5, 2022.
Tetsuya Oishi, “Designing an Individual Survey for Developing an Essential IR Human Resource Development Curriculum - Based on the Results of aWeb Questionnaire Survey,” Proceeding of Japan Society of Educational Information Annual Conference, Vol.38, pp.238-241, 2022.
Tetsuya Oishi, “Individual surveys and additional analysis for the development of a brand-new curriculum for the training of IR personnel,” Proceedings of 11th Meeting on Japanese Institutional Research, vol.11, pp.112-117, 2022.
Tetsuya Oishi and Takashi Nishide, “Designing a Practical Survey for Developing an Essential IR Human Resource Development Curriculum - Focusing on Self-Perception of IR Skills and Knowledge,” Proceeding of Japan Society of Educational Information Annual Conference, Vol.39, pp.199-202, 2023.
Tetsuya Oishi and Takashi Nishide, “Survey on self-perception of IR skills and knowledge - Focusing on the gap with the training required by the participants,” Proceedings of 12th Meeting on Japanese Institutional Research, vol.12, pp.72-77, 2023.
Takashi Nishide, “Enhancing Communication in University IR through Data: Practical Know-How in Effective Data Visualization and Representation,” Departmental Bulletin Paper of Ritsumeikan University Policy Science Association, vol.31(4), pp.101-122, 2024.
Takashi Nishide and Tetsuya Oishi, “Presentation Method of ’Data’ and Value of ’Information’ in IR - Differences in Information Amount Due to Purpose of Data Use and Analysis, Visualization, and Reporting Methods,” Proceeding of Japan Society of Educational Information Annual Conference, Vol.40, pp.54-57, 2024.
Tetsuya Oishi and Takashi Nishide, “Design of Additional Research Contributing to the Development of Essential IR Human Resource Development Curriculum - Considering Training Course Implementation Methods and Survey Contents,” Proceeding of Japan Society of Educational Information Annual Conference, Vol.40, pp.222-225, 2024.
Tetsuya Oishi and Takashi Nishide, “A Survey on Self-Perception of Institutional Research Skills and Knowledge by Focusing on the Gap with the Participants Needs of Training Courses,” Proceedings - 2024 16th International Congress on Advanced Applied Informatics, IIAI-AAI 2024, Vol.004, LIR239, pp.1-12, 2024.
Tetsuya Oishi and Takashi Nishide, “Results and Discussion of a Additional Study Contributing to the Establishment of an Essential IR Human Resource Development Curriculum,” Proceedings of 13th Meeting on Japanese Institutional Research, vol.13, pp.40-46, 2024.
Tetsuya Oishi and Takashi Nishide, “A Survey on Self-Perception of Institutional Research Skills and Knowledge: Results from Training Courses in 2023-2024,” International Journal of Institutional Research and Management, International Institute of Applied Informatics, Vol.9, No.1, IJIRM882, pp.1-20, 2025.
“Learning and Teaching Center,” https://www.ltc.kyutech.ac.jp/ (accessed 2nd April, 2025).
“Consortium for visualizing educational outcomes by e-portfolio system,” https://ekashika.org/ (accessed 2nd April, 2025).
Tetsuya Oishi, Hirofumi Fukumaru, Akihiro Hayashi, and Hiroshi Sakamoto, “Establishment of an IR System for Institutional Decision-Making in Kyushu Institute of Technology,” Proceedings - 2022 11th International Congress on Advanced Applied Informatics, IIAI-AAI 2023, Vol.003, LIR116, pp.1-8, 2023.
Tetsuya Oishi, Hirofumi Fukumaru, Akihiro Hayashi, and Hiroshi Sakamoto, “Development of an Automated Institutional Research System for Institutional Decision-Making in Kyushu Institute of Technology,” International Journal of Institutional Research and Management, International Institute of Applied Informatics, Vol.8, No.1, IJIRM839, pp.1-16, 2024.
“Data lake,” https://en.wikipedia.org/wiki/Data lake (accessed 2nd April, 2025).
“Extract, transform, load,” https://en.wikipedia.org/wiki/Extract, transform, load (accessed 2nd April, 2025).
“Data warehouse,” https://en.wikipedia.org/wiki/Data warehouse (accessed 2nd April, 2025).
“Business intelligence,” https://en.wikipedia.org/wiki/Business intelligence (accessed 2nd April, 2025).
“Nextcloud,” https://nextcloud.stylez.co.jp/ (accessed 2nd April, 2025).
“Waha! Transformer,” https://waha-transformer.com/ (accessed 2nd April, 2025).
“Latex,” https://ja.wikipedia.org/wiki/LaTeX (accessed 2nd April, 2025).
“RStudio,” https://posit.co/download/rstudio-desktop/ (accessed 2nd April, 2025).
“Dr.Sum,” https://www.wingarc.com/en/index.html (accessed 2nd April, 2025).
Hiroshi Sakamoto, Hirofumi Fukumaru, Takashi Miyaura, Kazunori Nishino, Akihiro Hayashi, “Use Case of Visualization of Learning Achievement Using e-Portfolio - Construction of Internal Quality Assurance of Education and Formation of Consortium by Diverse Educational Institutions -,” Joint Forums between University e-Learning Association and The Japan Association for Development Education 2019, 2020, pp. 31-32.
“JABEE,” https://jabee.org/en/ (accessed 2nd April, 2025).
“Moodle,” https://moodle.org/ (accessed 2nd April, 2025).
