|
Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
|---|---|
| รหัสดีโอไอ | |
| Creator | Kittipong Songsiri |
| Title | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| Contributor | Kreangsak Tamee |
| Publisher | Faculty of Informatics, Mahasarakham University |
| Publication Year | 2565 |
| Journal Title | Journal of Applied Informatics and Technology |
| Journal Vol. | 4 |
| Journal No. | 2 |
| Page no. | 99-113 |
| Keyword | Data Warehouse, Financial Report Data Warehouse, OLAP, ETL |
| URL Website | https://ph01.tci-thaijo.org/index.php/jait/ |
| Website title | Journal of Applied Informatics and Technology |
| ISSN | 2586-8136 |
| Abstract | Data warehouse technology is useful for managing large data. The purpose of them are analyzing organization’s datasets to formulate a strategy and direction of the organization. In this paper have present method of the development of data warehouse based on Ralph Kimball’s methodology, starting from the study of the data source. Process of Extraction, Transformation and Loading (ETL) until we finished to get for summary financial data warehouse of Faculty of Science, Naresuan University. That they have problem about reporting from Online Transaction Processing (OLTP) database that use for large data of financial management system. We are using the data warehouse which is an Online Analytical Processing (OLAP) database instead report function to analyze and follow up on the disbursement process more conveniently. The result of performance testing of the prototype system is proof the concept that the data warehouse can be fix the problem of large data processing from OLTP and we can usage from this data warehouse for analysis the financial data in many dimensions. |
