Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University
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...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Faculty of Informatics
2022-09-01
|
| Series: | วารสารวิทยาการสารสนเทศและเทคโนโลยีประยุกต์ |
| Subjects: | |
| Online Access: | https://ph01.tci-thaijo.org/index.php/jait/article/view/247846 |
| _version_ | 1797848499829604352 |
|---|---|
| author | Kittipong Songsiri Kreangsak Tamee |
| author_facet | Kittipong Songsiri Kreangsak Tamee |
| author_sort | Kittipong Songsiri |
| collection | DOAJ |
| description | 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 OLTP database that use for large data of financial management system. We using the data warehouse which is an OLAP database instead report function to analyze and follow up on the disbursement process more conveniently. In the future, data warehouse technology can also be used to analyze data in other fields within the Faculty of Science as well. |
| first_indexed | 2024-04-09T18:28:36Z |
| format | Article |
| id | doaj.art-5199b305ac704edea37fb2a8bfdf1a08 |
| institution | Directory Open Access Journal |
| issn | 2630-094X 2586-8136 |
| language | English |
| last_indexed | 2024-04-09T18:28:36Z |
| publishDate | 2022-09-01 |
| publisher | Faculty of Informatics |
| record_format | Article |
| series | วารสารวิทยาการสารสนเทศและเทคโนโลยีประยุกต์ |
| spelling | doaj.art-5199b305ac704edea37fb2a8bfdf1a082023-04-11T17:36:34ZengFaculty of Informaticsวารสารวิทยาการสารสนเทศและเทคโนโลยีประยุกต์2630-094X2586-81362022-09-01429911310.14456/jait.2022.8Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan UniversityKittipong Songsiri0Kreangsak Tamee1Department of Computer Science and Information Technology, Faculty of Science, Naresuan University, Phitsanulok 65000, ThailandDepartment of Computer Science and Information Technology, Faculty of Science, Naresuan University, Phitsanulok 65000, ThailandData 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 OLTP database that use for large data of financial management system. We using the data warehouse which is an OLAP database instead report function to analyze and follow up on the disbursement process more conveniently. In the future, data warehouse technology can also be used to analyze data in other fields within the Faculty of Science as well.https://ph01.tci-thaijo.org/index.php/jait/article/view/247846data warehousefinancial report data warehouseolapetljournal |
| spellingShingle | Kittipong Songsiri Kreangsak Tamee Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University วารสารวิทยาการสารสนเทศและเทคโนโลยีประยุกต์ data warehouse financial report data warehouse olap etljournal |
| title | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| title_full | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| title_fullStr | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| title_full_unstemmed | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| title_short | Development of Data Warehouse for Financial Report in Faculty of Science, Naresuan University |
| title_sort | development of data warehouse for financial report in faculty of science naresuan university |
| topic | data warehouse financial report data warehouse olap etljournal |
| url | https://ph01.tci-thaijo.org/index.php/jait/article/view/247846 |
| work_keys_str_mv | AT kittipongsongsiri developmentofdatawarehouseforfinancialreportinfacultyofsciencenaresuanuniversity AT kreangsaktamee developmentofdatawarehouseforfinancialreportinfacultyofsciencenaresuanuniversity |