Journal
| Title | Development of a University Financial Data Warehouse and its Visualization Tool Posted by Dante Dinawanao |
| Authors | Lapura, Earl Von F.; Fernandez, John Kenneth J.; Pagatpat, Mark Jonathan K.; Dinawanao, Dante D. |
| Publication date | 2018 |
| Journal | Procedia Computer Science |
| Volume | 135 |
| Issue | The 3rd International Conference on Computer Science and Computational Intelligence (ICCSCI 2018) : Empowering Smart Technology in Digital Era for a Better Life |
| Pages | 587-595 |
| Publisher | Elsevier B.V. |
| Abstract | In today's data-driven world, organizations which make use of the transactional data they have accumulated over time to come up with a more realistic picture of their operations can make more informed decisions towards attaining their goals and interests. However, due to the huge volumes of these accumulated transactional data, they cannot just be easily and readily used for reporting and analysis purposes. With this, a data warehouse is needed to store these accumulated data obtained from different sources within an organization where other decision-support applications can be built on to guide management decisions. In this study, a financial data warehouse was developed with a multidimensional construct that splits time, finance unit, account, and time dimensions, which is updated periodically with the accumulated transactional data sourced from a financial database of a university, and accessible via a Representational State Transfer application programming interface (REST API). To demonstrate the API's functionalities, we have created a data visualization tool which we integrated into our university web portal and subjected it to usability testing by its target end-users. It was shown that most of the respondents find the tool useful. Also, a query performance test was conducted comparing the execution of certain queries on the source transactional database and on the data warehouse. Result showed that the query time was greatly reduced by an average of over 50% when these queries were executed on the latter. |
| Index terms / Keywords | decision support system, data visualization, database systems |
| DOI | https://doi.org/10.1016/j.procs.2018.08.229 |
| URL | https://www.sciencedirect.com/science/article/pii/S1877050918315254 |