Skip to content
Research Article Open access CC BY 4.0

Prototyping an Academic Data Warehouse: Case for a Public University in Kenya

Christopher A. Moturi, Alfred Emurugat

Current Journal of Applied Science and Technology · pp. 550–557 · Published 8 May 2015

10.9734/BJAST/2015/14774

Abstract

This study aimed at determining the gaps between university top decision makers in a public university in Kenya and IT personnel in accessing, analyzing and reporting data. We sought to determine an easier and quicker way to analyze data, design, and implement a solution to turn analysis into a report with little or no help from IT department. A survey showed that the University’s existing systems do not allow the top management to explore data, analyze data, and create quick reports. They depend on IT personnel to access data that they need to analyze and generate reports. As result the decision makers tend to have an uneasy relationship with IT people. The study successfully implemented a data warehouse database composed of a single multidimensional cube based on subject area of Fee Payment. By implementing a Business Intelligence (BI) program based on Excel, we turned ordinary spreadsheets into a flexible, powerful, and inexpensive BI system that gives users significant power and flexibility.

Data warehouse University data warehouse University data mart business intelligence

References (26)

  1. 1 The Evolution of Big Data and Learning Analytics in American Higher Education [DOI]
  2. 2 Business intelligence success: The roles of BI capabilities and decision environments [DOI]
  3. 3 Knowledge management and business intelligence: the importance of integration [DOI]
  4. 4 Business Intelligence and Organizational Decisions [DOI]
  5. 5 Techniques, Process, and Enterprise Solutions of Business Intelligence [DOI]
  6. 6 What is Business Intelligence? [DOI]
  7. 7 The Impact of Management Information Systems Adoption in Managerial Decision Making: A Review
  8. 8 Business Intelligence & Knowledge Management - Technological Support for Strategic Management in the Knowledge Based Economy
  9. 9 Support of Decision Making by Business Intelligence Tools [DOI]
  10. 10 Business intelligence in higher education: Enhancing the teaching-learning process with a SRM system
  11. 11 What Academia Can Gain from Building a Data Warehouse.
  12. 12 An academic data warehouse
  13. 13 Data Warehouse as a Backbone for Business Intelligence: Issues and Challenges
  14. 14 Business intelligence applications for university decision makers
  15. 15 A model for a library‐management toolbox [DOI]
  16. 16 Research Data Mart in an Academic System [DOI]
  17. 17 Improving Academic Performance of Students of Defence University Based on Data Warehousing and Data mining
  18. 18 Improving the ETL process and maintenance of higher education information system data warehouse
  19. 19 Building a Data Warehouse step by step
  20. 20 Application Research of University Decision Support System Based on Data Warehouse [DOI]
  21. 21 Oracle 10g Data Warehousing [DOI]
  22. 22 What Is Business Intelligence? [DOI]
  23. 23 CONCEPTUAL FRAMEWORK OF BUSINESS INTELLIGENCE ANALYSIS IN ACADEMIC ENVIRONMENT USING BIRT
  24. 24 Prototyping Data Warehouse System for Ministry of Higher Education in Saudi Arabia [DOI]
  25. 25 Data Warehousing and Decision Making in Higher Education in the United States [DOI]
  26. 26 Data Warehouse Development [DOI]

Cited by 8

Agile Analytics: Applying in the Development of Data Warehouse for Business Intelligence System in Higher Education

Reynaldo Joshua Salaki, Kalai Anand Ratnam · Advances in Intelligent Systems and Computing · 2018

A Holistic View of Data Warehousing in Education

Oswaldo Moscoso-Zea, Joel Paredes-Gualtor, Sergio Lujan-Mora · IEEE Access · 2018

Showing 2 of 8 known citations — external sources report more than can currently be individually listed.

Related research

Article metrics

Real usage data collected on this platform.

50

Page views

0

PDF downloads

28

Outbound clicks

8

Citations

Views over time

Views by country

Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".

Traffic sources

Referring site, by host.

Views and downloads exclude known bots/crawlers. Citations combines this platform's own DOI-resolved index with each external source's own reported total — see Cited by above for individually listed citing works. Last refreshed 0 seconds ago.