Design and Implementation a Typical University Business Intelligence System Using Data Warehouse Technique (UBIS)

  • Authors

    • Ayad Hameed Mousa
    • Nibras Talib Mohammed
    • Heba Adnan Raheem
    2018-11-27
    https://doi.org/10.14419/ijet.v7i4.19.28060
  • Business Intelligence, Data Warehouse, Decision Making Process.

  • Abstract

    In organizations management, a Business Intelligence systems (BI) provides a flexible and computerized approach to help and support their top management (decision makers) to make better decisions. The education institutes tend to develop a Business Intelligence (BI) system to manage, integrate and control the academic information systems in terms of both data.However, until today, information does not integrate and presented in an appropriate manner for the university-decision-maker in helping them to make better decisions. The main issue is how to extract and process a massive amount of the information to speed up the intended data analysis and processing in supporting the university decision-making process. To manage and facilitate the data management process, in this paper, a university business intelligence system based on data warehouse model was designedand implemented into a case study from local education institute are carried out to explore the influences mentioned above. Finally, to find out the applicability of the proposed model the usability tested was conducted. The findings showed the applicability of the proposed system in practice.

     

     

  • References

    1. [1] W. F. Cody, J. T. Kreulen, V. Krishna, and W. S. Spangler, "The integration of business intelligence and knowledge management," IBM systems journal, vol. 41, pp. 697-713, 2002.

      [2] U. Dayal, M. Castellanos, A. Simitsis, and K. Wilkinson, "Data integration flows for business intelligence," in Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, 2009, pp. 1-11.

      [3] R. Kimball, M. Ross, W. Thorthwaite, B. Becker, and J. Mundy, The data warehouse lifecycle toolkit: John Wiley & Sons, 2008.

      [4] C. M. Olszak and E. Ziemba, "Approach to building and implementing business intelligence systems," Interdisciplinary Journal of Information, Knowledge, and Management, vol. 2, pp. 134-148, 2007.

      [5] J. Reinschmidt and A. Francoise, "Business intelligence certification guide," IBM International Technical Support Organisation, 2000.

      [6] J. H. Thomas Jr, "Business intelligence–why," eAI Journal, pp. 47-49, 2001.

      [7] T. Neumuth, S. Mansmann, M. H. Scholl, and O. Burgert, "Data warehousing technology for surgical workflow analysis," in Computer-Based Medical Systems, 2008. CBMS'08. 21st IEEE International Symposium on, 2008, pp. 230-235.

      [8] C. Kavitha and S. M. Thomas, "Requirement gathering for small projects using agile methods," IJCA Special Issue on Computational Science-New Dimensions & Perspectives, NCCSE, 2011.

      [9] T. M. Connolly and C. E. Begg, Database systems: a practical approach to design, implementation, and management: Pearson Education, 2005.

      [10] A. H. Mousa, N. Shiratuddin, and M. S. A. Bakar, "RGMDV: An approach to requirements gathering and the management of data virtualization projects," in INNOVATION AND ANALYTICS CONFERENCE AND EXHIBITION (IACE 2015): Proceedings of the 2nd Innovation and Analytics Conference & Exhibition, 2015, p. 030024.

      [11] A. H. Mousa, N. Shiratuddin, and M. S. A. Bakar, "Process Oriented Data Virtualization Design Model for Business Processes Evaluation (PODVDM) Research in Progress," Jurnal Teknologi, vol. 72, 2015.

      [12] A. H. Mousa, N. Shiratuddin, and M. S. A. Bakar, "Virtual Data Mart for Measuring Organizational Achievement Using Data Virtualization Technique (KPIVDM)," Jurnal Teknologi, vol. 68, 2014.

      [13] W. H. Inmon and R. D. Hackathorn, Using the data warehouse: Wiley-QED Publishing, 1994.

      [14] A. H. Mousa and N. Shiratuddin, "Data Warehouse and Data Virtualization Comparative Study," in Developments of E-Systems Engineering (DeSE), 2015 International Conference on, 2015, pp. 369-372.

      [15] R. Meredith, P. O’Donnell, and D. Arnott, "Databases and data warehouses for decision support," in Handbook on Decision Support Systems 1, ed: Springer, 2008, pp. 207-230.

      [16] J. Langseth, "Real-Time Data Warehousing: Challenges and Solutions," DSSResources. com, vol. 2, 2004.

      [17] R. Kimball and M. Ross, The data warehouse toolkit: the complete guide to dimensional modeling: John Wiley & Sons, 2011.

      [18] W. H. Inmon, Building the data warehouse: John wiley & sons, 2005.

      [19] P. Giorgini, S. Rizzi, and M. Garzetti, "Goal-oriented requirement analysis for data warehouse design," in Proceedings of the 8th ACM international workshop on Data warehousing and OLAP, 2005, pp. 47-56.

      [20] D.-P. Zhang, "A Data Warehouse Based on University Human Resource Management of Performance Evaluation," in Information Technology and Applications, 2009. IFITA'09. International Forum on, 2009, pp. 655-658.

      [21] P. Ponniah, "Data warehousing fundamentals: a comprehensive guide for IT professionals," 2001.

      [22] F. R. S. Paim and J. F. B. De Castro, "DWARF: An approach for requirements definition and management of data warehouse systems," in Requirements Engineering Conference, 2003. Proceedings. 11th IEEE International, 2003, pp. 75-84.

      [23] A. H. Mousa, "DATA VIRTUALIZATION DESIGN MODEL FOR NEAR REA TIME DECISION MAKING IN BUSINESS INTELLIGENCE ENVIRONMENT," PhD PhD Thesis, Computer Science Department, Universiti Utara Malaysia, Malaysia, 2017.

      [24] N. S. Ayad Hameed Mousa, Muhamad Shahbani Abu Bakar, "Evaluation Framework for Business Process Evaluation Approaches," Journal of Computer Science & Computational Mathematics, vol. 6, p. 7, September 2016.

      [25] M. S. A. B. Ayad Hameed Mousa, "INTELLIGENT IRAQI HEALTH SYSTEM (IIHS) USING ONLINE ANALYTICAL PROCESS (OLAP) MODEL," in the 4th International Conference on Computing and Informatics, ICOCI, Sarawak, Malaysia, 2013, p. 7.

      [26] A. H. Mousa, N. Shiratuddin, and M. S. A. Bakar, "Evaluation Framework for Business Process Evaluation Approaches," evaluation, vol. 18, p. 29, 2014.

      [27] V. P. Bresfelean, N. Ghisoiu, R. Lacurezeanu, and D.-A. Sitar-Taut, "Towards the development of decision support in academic environments," in Information Technology Interfaces, 2009. ITI'09. Proceedings of the ITI 2009 31st International Conference on, 2009, pp. 343-348.

      [28] M. Demarest, "Data Warehouse Prototyping: Reducing Risk, Securing Commitment and Improving Project Governance. Retrieved June 28, 2014, from: http," ed, 2013.

      [29] Y. Bassil, "A Data Warehouse Design for A Typical University Information System," arXiv preprint arXiv:1212.2071, 2012.

      [30] I. I. D. N. Oye, "Design of a Data Warehouse Model for a University Decision Support System."

  • Downloads

  • How to Cite

    Hameed Mousa, A., Talib Mohammed, N., & Adnan Raheem, H. (2018). Design and Implementation a Typical University Business Intelligence System Using Data Warehouse Technique (UBIS). International Journal of Engineering & Technology, 7(4.19), 870-873. https://doi.org/10.14419/ijet.v7i4.19.28060

    Received date: 2019-03-01

    Accepted date: 2019-03-01

    Published date: 2018-11-27