Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach

Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach

The growth and development of universities, just as other organisations, depend on their abilities to strategically plan and implement development blueprints which are in line with their vision and mission statements. The actualizations of these statements –which are often abstracted into goals a...

Full description

Saved in:
Bibliographic Details
Main Author: Abdullah, Mohammed Thajeel
Format: Thesis
Language:eng
eng
Published: 2016
Subjects:
T58.6-58.62 Management information systems
Online Access:https://etd.uum.edu.my/5640/1/s813668_01.pdf
https://etd.uum.edu.my/5640/2/s813668_02.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
id my-uum-etd.5640
record_format uketd_dc
institution Universiti Utara Malaysia
collection UUM ETD
language eng
eng
advisor Ta'a, Azman
Abu Bakar, Muhamad Shahbani
topic T58.6-58.62 Management information systems
spellingShingle T58.6-58.62 Management information systems
Abdullah, Mohammed Thajeel
Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
description The growth and development of universities, just as other organisations, depend on their abilities to strategically plan and implement development blueprints which are in line with their vision and mission statements. The actualizations of these statements –which are often abstracted into goals and sub-goals and linked to their respective actors –are better measured by defined key performance indicators (KPIs). And in universities that handle modestly large and heterogeneous data, development of data warehouse is important. Specifically, Universiti Utara Malaysia (UUM) is yet to have a data warehouse for monitoring its organisational KPIs. This study therefore proposes a data warehouse schema for university’s KPIs for teaching and learning KPIs using a Requirement Goal Analysis for Data Warehouse KPI(ReGADaK)approach which is an extension of goal-oriented requirement analysis and design (GRAnD). The proposed schema highlights the facts, dimensions, attributes and measures of UUM’s teaching and learning unit. The measures from the goal analysis of this unit serve as basis of developing the related university’s KPIs. The proposed data warehouse schema is evaluated through expert review, prototyping and usability evaluation. The findings from the evaluation processes suggest that the proposed data warehouse schema is suitable for university’s KPIs for teaching and learning KPIs monitoring and practicable.
format Thesis
qualification_name masters
qualification_level Master's degree
author Abdullah, Mohammed Thajeel
author_facet Abdullah, Mohammed Thajeel
author_sort Abdullah, Mohammed Thajeel
title Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
title_short Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
title_full Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
title_fullStr Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
title_full_unstemmed Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach
title_sort data warehouse schema for monitoring key performance indicators (kpis) for university teaching and learning using goal oriented approach
granting_institution Universiti Utara Malaysia
granting_department Awang Had Salleh Graduate School of Arts & Sciences
publishDate 2016
url https://etd.uum.edu.my/5640/1/s813668_01.pdf
https://etd.uum.edu.my/5640/2/s813668_02.pdf
_version_ 1747827962615431168
spelling my-uum-etd.56402021-04-05T01:35:27Z Data warehouse schema for monitoring key performance indicators (KPIs) for university teaching and learning using goal oriented approach 2016 Abdullah, Mohammed Thajeel Ta'a, Azman Abu Bakar, Muhamad Shahbani Awang Had Salleh Graduate School of Arts & Sciences Awang Had Salleh Graduate School of Arts and Sciences T58.6-58.62 Management information systems The growth and development of universities, just as other organisations, depend on their abilities to strategically plan and implement development blueprints which are in line with their vision and mission statements. The actualizations of these statements –which are often abstracted into goals and sub-goals and linked to their respective actors –are better measured by defined key performance indicators (KPIs). And in universities that handle modestly large and heterogeneous data, development of data warehouse is important. Specifically, Universiti Utara Malaysia (UUM) is yet to have a data warehouse for monitoring its organisational KPIs. This study therefore proposes a data warehouse schema for university’s KPIs for teaching and learning KPIs using a Requirement Goal Analysis for Data Warehouse KPI(ReGADaK)approach which is an extension of goal-oriented requirement analysis and design (GRAnD). The proposed schema highlights the facts, dimensions, attributes and measures of UUM’s teaching and learning unit. The measures from the goal analysis of this unit serve as basis of developing the related university’s KPIs. The proposed data warehouse schema is evaluated through expert review, prototyping and usability evaluation. The findings from the evaluation processes suggest that the proposed data warehouse schema is suitable for university’s KPIs for teaching and learning KPIs monitoring and practicable. 2016 Thesis https://etd.uum.edu.my/5640/ https://etd.uum.edu.my/5640/1/s813668_01.pdf text eng public https://etd.uum.edu.my/5640/2/s813668_02.pdf text eng public masters masters Universiti Utara Malaysia Abdullah, H.A. (2010). Business Intelligence Model For A Student Data Warehouse in UUM Environment. A MSc project paper of Universiti Utara Malaysia. Albert, S. (2014). Leadership, Strategic Planning and Strategic Management for Higher Education Institutions in Developing Countries Paper prepared for the World Business and Economics Research Conference, 24-25 February 2014, Rendezvous Hotel, Auckland, New Zealand. Altbach, P. G., Reisberg, L., & Rumbley, L. E. (2009). Trends in global higher education: Tracking an academic revolution. Ali, R., Dalpiaz, F., &Giorgini, P. (2010).A Goal-based Framework for Contextual Requirements Modeling and Analysis. Springer - International Journal of Requirements Engineering, 15(4), 439–458. Allen, S., & Terry, E. (2005). Beginning relational data modelling (2nd ed. ed.). Alwan, H.A. (2012). Requirement Model for Universiti Utara Malaysia Library Data Warehouse. A MSc project paper of Universiti Utara Malaysia. Anton, A. I. (1996). Goal Based Requirements Analysis. Paper presented at the Second Int. Conference on Requirements Engineering (ICRE’ 96). Azma’a, T., Muhamad Shahbani, A., Abdul Razak, S. (2008).Academic Business Intelligence System Development Using SAS Tools. SAS Global Forum, 2008. BI Forum – BI User Application. Azman, T. (2012).A Goal and Ontology-Based Approach for Generating ETL Process Specifications, Unpublished PhD Thesis, Universiti Utara Malaysia. Ayodele, T., O. Sotola, 2014. China in Africa: China in Africa: An Evaluation of Chinese Investment. Lagos: Initiative for Public Policy Analysis. Babbie, E. (2010). The Practice of Social Research, 12th Edition, Wadsworth Cengage Learning, USA. Balakrishnan, M.,Mei, Y. O., Phua, K. K., Saw, L. O. (2011). Assessing Key Performance Indicators Monitoring System (KPI-MS) of a university using Technology Acceptance Model, International Journal of Social Science and Humanity, Vol. 1, No. 3, September 201. Ballard, R.E., Watenpaugh, D.E., Breit, G.A., Murthy, G., Holley, D.C., Hargens, A.R., 1998. Leg intramuscular pressures during locomotion in humans. Journal of Applied Physiology 84, 1976–1981. Bresciani, P., Perini, A., Giorgini, P., Giunchiglia, F., & Mylopoulos, J. (2001). Aknowledge level software engineering methodology for agent oriented programming Proceedings of the fifth international conference on Autonomousagents (pp. 648-655). Montreal, Quebec, Canada: ACM. From http://dx.doi.org/10.1145/375735.376477. Bresciani, P., Perini, A., Giorgini, P., Giunchiglia, F., &Mylopoulos, J. (2004). Tropos: An Agent-Oriented Software Development Methodology. Autonomous Agents and Multi-Agent Systems, 8(3), 203-236. Cai, J., Xiangdong, L., Zhihui, X., & Liu, J. (2009). Improving supply chain performance management: A systematic approach to analyzing iterative KPI accomplishment, Decision Support Systems, 46, 512–521. Canadian Institute for Health Information. Better Information for Improved Health: A Vision for Health System Use of Data in Canada. Ottawa, ON: CIHI; 2013. Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM Sigmod Record, 26(1), 65-74. Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). An overview of business intelligence technology, Commun. ACM, vol. 54, no. 8, pp. 88–98, Aug. 2011. Chen, P. P.-S. (1976). The Entity-Relationship Model-Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1), 9-36. Cheng, E. W. L., & Li, H. (2005). Analytic network process applied to project selection. Journal of Construction Engineering and Management, 131(4), 459-466. Connolly, T. &Begg, C. (2010). Database Systems: A Practical To Design, Implementation, and Management. Boston, Pearson Education Inc., Fifth Edition. Conrad, C., Gasman, M., Lundberg, T., Nguyen, T-H., Commodore, F., Samayoa, A.C. (2013).Using Educational Data to Increase Learning, Retention, and Degree Attainment at Minority Serving Institutions (MSIs), A Research Report of Penn Graduate School of Education, GSE. Coulin, C., &Zowghi, D. (2005). Requirements Elicitation for Complex Systems: Theory and Practice. In J. L. Mate & A. Silva (Eds.), Requirements Engineering For Sociotechnical Systems. Hershey, PA: Information Science Publishing. Cresswell, J. (2009). Research Design: Qualitative, Quantitative, and Mixed Methods Approaches. SAGE Publication, USA. Daft, R. L. (2008). Organization Theory and Design (10 ed.). Mason, USA: South-Western Cengage Learning. Doran, G. T. (1981). There’sa SMART way to write management’s goals and objectives. Management Review, 70(11), 35–36. Drucker, P. F. (1974). Management: tasks, responsibilities, practices: Butterworth- Heinemann. Eckerson, W. (2003).Smart Companies in the 21st Century: The Secrets of Creating Successful Business Intelligent Solutions. The Data Warehousing Institute: Seattle, WA. Few, S. (2006). Information Dashboard Design: The Effective Visual Communication of Data. O’Reilly Publication, Inc. Finkelstein, A. (1994). Requirements engineering: a review and research agenda Software Engineering Conference, 1994. Proceedings., 1994 First Asia-Pacific (pp. 10-19). from citeulike-article-id:173098 http://ieeexplore.ieee.org/xpls/abs_all.jsp?ar number=465278. Forsell, C. (2012). Evaluation in Information Visualization: Heuristic Evaluation, Proceedings of 16th International Conference on Information Visualization, pg. 136-142. DOI: 10.1109/IV.2012.33. Frankel, L. & Racine, M. (2010). The Complex Field of Research: for Design, through Design, and about Design. Giorgini, P., Rizzi, S., &Garzetti, M. (2008).GRAnD: A Goal-Oriented Approach to Requirement Analysis in Data Warehouses. Decision Support Systems, 45, 4-21. Giunchiglia, F., Mylopoulos, J., & Perini, A. (2003). The Tropos Software Development Methodology: Processes, Models and Diagrams. In Agent-Oriented SoftwareEngineering III: Third International Workshop, AOSE 2002, Bologna, Italy, July15, 2002. Revised Papers and Invited Contributions (pp. 162-173). Goguen, J., & Linde, C. (1993).Techniques for Requirements Elicitation.citeulikearticle-id: 4382884 http://citeseerx.ist.psu.edu/viewdoc/ summary?doi=10.1.1.48.8959 Golfarelli, M., Rizzi, S., &Castenaso, V. (2004). Beyond data warehousing: What is next in business intelligence?,Proceedings of the 7th ACM international workshop on Data warehousing and OLAP, pp. 1–6. Golfarelli, M., Maio, D., & Rizzi, S. (1998). The Dimensional Fact Model: A Conceptual Model For Data Warehouses. International Journal of Cooperative Information Systems, 7(2-3), 215-247. Gorbach, I., Melomed, E., Berger, A., & Bateman, P. (2006). Microsoft SQL Server 2005 Analysis Services. United States of America: Sams Publishing. Graham, D. (2004). Introduction to BI Architecture Framework and Methods. A course developed by IBM Software Group and DB2 Data Management Software Halpin, T. (2001).Information Modeling and Relational Databases - From Conceptual Analysis to Logical Design: Morgan Kaufman. Hancock, J., & Toren, R. (2006). Practical business intelligence with sql server 2005. US: Addison-Wesley Professional. Hatch, M. J., &Cunliffe, A. L. (2006). Organization theory: modern, symbolic, and postmodern perspectives: Oxford University Press. Inayatullah, S. (2012). Malaysian Universities in Transformation. Journal of Futures Studies, December 2012, 17(2), 111-124 Iveta, G. (2012). Human Resources Key Performance Indicators. Journal of Competitiveness, 4 (1), 117–128. DOI: 10.7441/joc.2012.01.09 John, K. (2007). Cognos 8: Business Intelligence Dashboards. IBM Software Magazine, 1. Jureta, I. J., Faulkner, S., &Schobbens, P.-Y. (2007). Achieving, Satisficing, and Excelling. Lecture Notes In Computer Science, 48(02), 286-295. Kim, J. A., Lee, H., Jung, R., & Kim, S. (2014). Goal and Scenario-based Feature Identification Techniques from Legacy System. International Journal of Software Engineering and Its Applications, 8 (2), 145-150 Available at: http://dx.doi.org/10.14257/ijseia.2014.8. 2.14 Kimball, R. (1996). The Data Warehouse Toolkit - Practical Techniques for Building Dimensional Data Warehouses: John Wiley & Son. Kimball, R., & Caserta, J. (2004).The Data Warehouse ETL Toolkit. Practical Technique for Extracting, Cleaning, Conforming and Delivering Data: Wiley Publishing, Inc., Indianapolis. Kirkness, V. J., & Barnhardt, R. (1991). First Nations and higher education: The four R’s—Respect, relevance, reciprocity, responsibility. Journal of American Indian Education, 30(3), 1-15. Klatt, T., Schlaefke, M. & Moeller, K. (2011). Integrating business analytics into strategic planning for better performance, Journal of Business Strategy, 32(6), 30–39 Kumar, R. (2011). Research Methodology, a step-by-step guide for beginners, SAGE Publication, Singapore. ISBN: 978-1-84920-300-5. Lamsweerde, A. v. (2009). Requirements Engineering - From System Goals to UML Models to Software Specifications: John Wiley & Sons Ltd. Lazar, J., Feng, J. H., & Hochheiser, H. (2010). Research Methods in Human Computer Interaction. United Kingdom: John Wiley, Ltd. Lewis (1993). IBM Computer Usability Satisfaction Questionnaires: Psychometric Lujan-Mora, S. (2005).Data Warehouse Design With UML. Unpublished PhD, University of Alicante. Maz´on, J-N., Maz´on, J., & Trujill, J. (2007). A Model-Driven Goal-Oriented Requirement Engineering Approach for Data WarehousesJ.-L. In Hainaut et al. (Eds.): ER Workshops 2007, LNCS 4802, pp. 255–264, 2007. Mazon, J.-N., Pardillo, J., & Trujillo, J. (2007).A Model-Driven Goal-Oriented Requirement Engineering Approach for Data Warehouses. Lecture Notes In Computer Science 48 (02), 255–264. Misra, S., Kumar, V., & Kumar, U. (2005). Goal-oriented or scenario based requirements engineering technique - what should a practitioner select? Paper presented at the Canadian Conference on Electrical and Computer Engineering. Saskatoon, Sask. Moyle, K. (2010), ‘Building innovation: learning with technologies’, Australian Education Review, 56 (1). Muraina, Dada Ishola (2011).Healthcare Business Intelligence: A Case Study Of Universiti Utara Malaysia Health Center (PKU). A MSc project paper of School of Computing, Universiti Utara Malaysia Mykkänen, M. & Tampere, K. (2014). Organizational Decision Making: The Luhmannian Decision Communication Perspective. Journal of Business Studies Quarterly, 5(4), 131–146. Mylopoulos, J., Chung, L., & Yu, E. (1999). From object-oriented to goalorientedrequirements analysis. Commun. ACM, 42(1), 31-37. Negash, S. (2004). Business Intelligence. Communications of the Association for Information System, Vol (13), pp. 177 - 195 Nielsen, J. (1997). Usability Engineering. Boston, Massachusetts: Academic Press, Inc. Nur Hani, Z. A., Jamaiah, Y., & Aziz, D. (2013). User requirement analysis in data warehouse design: A review, in International Conference on Electrical Engineering Nuseibeh, B., & Easterbrook, S. (2000). Requirements engineering: a roadmap ICSE '00: Proceedings of the Conference on The Future of Software Engineering (pp. 35- 46). ACM Press. from citeulike-article-id:486087 Olivé, A. (2007). Conceptual Modeling of Information System: Springer-Verlag Berlin Heidelberg. Oliveros, C. H. & Moyle, R. G. (2010) Origin and diversifi- cation of Philippine bulbuls. Molecular Phylogenetics and Evolution, 54, 822–832. Pant, P. (2009). Business Intelligence: How to Build Successful BI Strategy. A White Paper publication of Delloitte Consulting LLP Pedersen, T. B., and Jensen, C. S., 1998. Multidimensional Data Modeling of Complex Data. Proceedings of the 15th IEEE International Conference on Data Engineering (ICDE 99), Sydney, Australia. Ponniah, P. (2007). Data Modeling Fundamentals - A Practical Guide for IT Professionals: John Wiley & Sons. Pourshahid, A., Gregory, R; Daniel, A., (2011). Toward a Goal-oriented, Business pp. 1-9 Prakash, N., &Gosain, A. (2008).An approach to engineering the requirements of data warehouses. Requirements Engineering, 13(1), 49-72 Ranjan, J. (2005). Business Intelligence: Concepts, Components, Techniques And Benefits. Retrieved Dec 2, 2015, from http://www.jatit.org/volumes/researchpapers/Vol9No1/9Vol9No1.pdf. Rizzi, S. (2007).Conceptual Modeling Solutions for the Data Warehouse.Idea Group Inc., 1-26. Rizzi, S., Abello, A., Lechtenborger, J., & Trujillo, J. (2006).Research in Data Warehouse Modeling and Design: Dead or Alive?Paper presented at the DOLAP'06, Arlington, Virginia, USA. Rogers, Y., Sharp, H. &Preece, J. (2011). Interaction Design: Beyond Human Computer Interaction, 3rd Edition, United Kingdom. John Wiley & Sons, Limited. Rolland, C., Souveyet, C., & Achour, C. B. (1998). Guiding goal modeling using scenarios. Software Engineering, IEEE Transactions on, 24(12), 1055-1071. Schläfke, M. (2013). A framework for business analytics in performance management, International Journal Product Performance Management, 62(1), 110–122. Semiu, A., & Zulikha J. (2014). Students' Data-driven Decision Making in HEI: The Explicit Knowledge Involved. Proceedings of 5th International Conference on Future Information Technology, Bangkok, Thailand. Oct 10 – 12, 2014. Shahin, A., & Mahbod, M. A. (2007). Prioritization of key performance indicators: An integration of analytical hierarchy process and goal setting. International Journal of Productivity and Performance Management, 56(3), 226-240. Shams-Ul-Arif, Khan, Q., Gahyyur, S.A.K. (2010).Requirements Engineering Processes Tools/ Technologies & Methodologies. International Journal of Review in Computing, pp. 41 -56. Sheneiderman, B. &Plaisant, C. (2010).Designing the User Interface: Strategies for Effective Human-Computer Interaction, 5th Edition, U.S.A. Pearson Higher Education. Simon, H. (1996). The Sciences of the Artificial (3rd ed.): The MIT Press Sinclair, D., & Zairi, M. (1995). Effective process management through performance measurement: Part III-an integrated model of total quality-based performance measurement. Business Process Management Journal, 1(3), 50-65. Smith, R. (2013). The NACA Collections: When Old Is New Again. A Status Report on the NACA Documents Project. Sci-Tech News, 46(2), 5. Stefanov, V., & List, B. (2005).Bridging the Gap between Data Warehouses and Business Processes: A Business Intelligence Perspective for Event-Driven Process Chains. Paper presented at the 9th IEEE International EDOC Enterprise Computing (EDOC'05), Enschede, The Netherlands. Suryadi, K. (2007). Key Performance Indicators Measurement Model Based on Analytic Hierarchy Process and Trend-Comparative Dimension in Higher Education Institution . ISAHP 2007, Viña Del Mar, Chile, August 3, 2007. Suryadi, K. (2007). Key Performance Indicators Measurement Model Based on Analytic Hierarchy Process and Trend-Comparative Dimension in Higher Education Institution, ISAHP 2007, Viña Del Mar, Chile. Sutcliffe, A. (2003). Scenario-based requirements engineering Requirements Engineering Conference, 2003. Proceedings. 11th IEEE International (pp. 320-329). Fromciteulike-articleid:222845http://ieeexplore.ieee.org/xpls/ abs_all.jsp?arnumber=1232776. Tassey, G. (2009). Rationales and mechanisms for revitalizing US manufacturing R&D strategies. Unpublished Paper, National Institute of Standards and Technology. Teegavarapu, S., & Summers, J.D. (2008). Case Study Method for Design Research, Teske, A. D. (2014). Spatial data warehouse for data exploration International Thayer, R. H., & Dorfman, M. (1990).System and Software Requirements Engineering. Los Alamitos, CA: IEEE Computer Society Press. The University of Edinburgh Strategic Plan (2012- 2016). Retrieved from www.ed.ac.uk. Tilak, J. B. G. (2002). Building Human Capital in East Asia: What Others Can Learn. National Institute of Educational Planning and Administration, New Delhi, India. Tsui, F., & Karam, O. (2007). Essentials of software engineering. Sudbury, Mass. Jones and Bartlett Publishers. Tsumaki, T., and Tamai, T. (2005).A Framework for Matching Requirements Engineering Techniques to Project Characteristics and Situation Changes. Proceedings of SREP’05, Paris, France, August 29–30, 2005 Eds. TULES (2006). Guide to Key Performance Indicator: Communicating the Measures that matter. A Joint White paper publication of PriceWaterHouseCooper and connectedthinking. Turban, E., Aronson, J. E., Liang, T.-P., & Sharda, R. (2007).Decision support and business intelligence systems. Pearson Prentice-Hall. Uygun, Ö., Öztemel, E., & Kubat, C. (2009). Scenario based distributed manufacturing simulation using HLA technologies. Information Sciences, 179(10), 1533-1541. Vaishnavi, V., &Kuechler, W. (2007).Design Science Research Methods and Patterns: Innovating Information and Communication Technology: AUERBACH. van Lamsweerde, A. (2009). Requirements Engineering: From System Goals to UMLModels to Software Specifications: Wiley. Velimirovića, D., Velimirović, M., &Stankovića, R. (2011).Role and Importance of Key Performance Indicators Measurement.Serbian Journal of Management, 6(1), 63 – 72. Vessey, I., & Galletta, D. (1991). Cognitive fit: An empirical study of information acquisition. Information systems research, 2(1), 63-84. Viaene, S.& Van den Bunder, A. (2011). The secrets to managing business analytics projects, MIT Sloan Management Review, 53 (1), 64–70. Windle, D. R., & Abreo, L. R. (2003). Software requirements using the unified process: a practical approach. Upper Saddle River, NJ :: Prentice Hall. Winter, R., &Strauch, B. (2004). Information requirements engineering for data warehouse systems, in Proceedings of the 2004 ACM symposium on Applied computing - SAC ‟04, 2004. Yanosky, R. (2009). Institutional Data Management in Higher Education. A Report from EduCause Centre for Applied Research. Retrieved on 5th March, 2015 from http://net.educause.edu/ir/library/pdf/EKF/ EKF0908.pdf. Yu, E. (1995). Modeling Strategic Relationships for Process Reengineering. Unpublished PhD thesis, University of Toronto. Yu, E., Giorgini, P., Maiden, N., &Mylopoulos, J. (2011).Social Modeling for Requirements Engineering: The MIT Press. Zhang, Jianxin. (2008). ASEAN Higher Education and the Road from Elite to Massification. Conference paper for the Asia-Pacific Sub-regional Preparatory Conference for the 2009 World Conference for Higher Education. Macao SAR, PR China, September 24-26, 2008.

Similar Items