Significance of data integration and ETL in business intelligence framework for higher education
One of the important component toward developing a business intelligence framework is data integration. It is used to combine data from different academic data sources and integrate it together before stored it in integrated manner as needed by higher education institute. ETL is the common steps to...
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Published: |
2015
|
| Subjects: |
| _version_ | 1796861142638788608 |
|---|---|
| author | Mohamad Rodzi, Nur Alia Hamizah Othman, Mohd. Shahizan Mi Yusuf, Lizawati |
| author_facet | Mohamad Rodzi, Nur Alia Hamizah Othman, Mohd. Shahizan Mi Yusuf, Lizawati |
| author_sort | Mohamad Rodzi, Nur Alia Hamizah |
| collection | ePrints |
| description | One of the important component toward developing a business intelligence framework is data integration. It is used to combine data from different academic data sources and integrate it together before stored it in integrated manner as needed by higher education institute. ETL is the common steps to integrate data and transform it to compatible in targeted destination system. This paper use Universiti Teknologi Malaysia (UTM) as the case study for further understanding on the relation of data integration with extract, transform and load (ETL) process. Data integration plays its important role in BI framework as it integrates different attributes from different tables during transformation process in ETL. ETL process performs data cleaning during extraction process and load significant data into data warehouse. Thus, it maintains the integrity of data to be used for decision making and reporting. This paper will highlight the importance of data integration and ETL in business intelligence framework and its significance for better higher education management. |
| first_indexed | 2024-03-05T19:51:54Z |
| format | Conference or Workshop Item |
| id | utm.eprints-61667 |
| institution | Universiti Teknologi Malaysia - ePrints |
| last_indexed | 2024-03-05T19:51:54Z |
| publishDate | 2015 |
| record_format | dspace |
| spelling | utm.eprints-616672017-08-10T03:58:23Z http://eprints.utm.my/61667/ Significance of data integration and ETL in business intelligence framework for higher education Mohamad Rodzi, Nur Alia Hamizah Othman, Mohd. Shahizan Mi Yusuf, Lizawati QA75 Electronic computers. Computer science One of the important component toward developing a business intelligence framework is data integration. It is used to combine data from different academic data sources and integrate it together before stored it in integrated manner as needed by higher education institute. ETL is the common steps to integrate data and transform it to compatible in targeted destination system. This paper use Universiti Teknologi Malaysia (UTM) as the case study for further understanding on the relation of data integration with extract, transform and load (ETL) process. Data integration plays its important role in BI framework as it integrates different attributes from different tables during transformation process in ETL. ETL process performs data cleaning during extraction process and load significant data into data warehouse. Thus, it maintains the integrity of data to be used for decision making and reporting. This paper will highlight the importance of data integration and ETL in business intelligence framework and its significance for better higher education management. 2015 Conference or Workshop Item PeerReviewed Mohamad Rodzi, Nur Alia Hamizah and Othman, Mohd. Shahizan and Mi Yusuf, Lizawati (2015) Significance of data integration and ETL in business intelligence framework for higher education. In: International Conference on Science in Information Technology (ICSITECH), 27-28 Oct, 2015, Indonesia. http://ieeexplore.ieee.org/document/7407800/ |
| spellingShingle | QA75 Electronic computers. Computer science Mohamad Rodzi, Nur Alia Hamizah Othman, Mohd. Shahizan Mi Yusuf, Lizawati Significance of data integration and ETL in business intelligence framework for higher education |
| title | Significance of data integration and ETL in business intelligence framework for higher education |
| title_full | Significance of data integration and ETL in business intelligence framework for higher education |
| title_fullStr | Significance of data integration and ETL in business intelligence framework for higher education |
| title_full_unstemmed | Significance of data integration and ETL in business intelligence framework for higher education |
| title_short | Significance of data integration and ETL in business intelligence framework for higher education |
| title_sort | significance of data integration and etl in business intelligence framework for higher education |
| topic | QA75 Electronic computers. Computer science |
| work_keys_str_mv | AT mohamadrodzinuraliahamizah significanceofdataintegrationandetlinbusinessintelligenceframeworkforhighereducation AT othmanmohdshahizan significanceofdataintegrationandetlinbusinessintelligenceframeworkforhighereducation AT miyusuflizawati significanceofdataintegrationandetlinbusinessintelligenceframeworkforhighereducation |