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/14774Abstract
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.
Cited by 7
Reynaldo Joshua Salaki, Kalai Anand Ratnam · Advances in Intelligent Systems and Computing · 2018
Oswaldo Moscoso-Zea, Joel Paredes-Gualtor, Sergio Lujan-Mora · IEEE Access · 2018
Showing 2 of 7 known citations — external sources report more than can currently be individually listed.
Related research
- Unleashing the Power of Cloud Computing for Big Data Management: Advantages, Challenges, and Future Prospects — shares topic coverage
- Comparing ATI, CCT and SCM in Power BI for Performance and Applications: An Analytical Approach — shares topic coverage
- Utilizing Big Data Analytics and Business Intelligence for Improved Decision-Making at Leading Fortune Company — shares topic coverage
- Smarter Marketing with AI: How Cloud Technology is Changing Business — shares topic coverage
- The Role of Artificial Intelligence in Strategic Decision-Making — shares topic coverage
Article metrics
Real usage data collected on this platform.
9
Page views
0
PDF downloads
0
Outbound clicks
7
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.