Effective Distributed Based Decision-Making Approach Using ETL Data Warehousing Based On Smart Business Intelligence Technology

Abstract

In advancement of recent era, business organization is developing drastically as there is an increase number of information Technology (IT) as they give wide impact on the national and international development as they all managing the vast and complex amount of data. In order to analyses the performance of data, those vast data have to be processed and analysed. In managing the data, Extract, Transform and Load (ETL) process is applied and stored in the data warehouse as repository in order to take effective distributed based decision as it faces the problem of time-consuming process. As the data warehouse takes the data source in the distributed manner as it is difficult to integrate those data.

 To overcome the above challenges, the Modified ETL based Data warehouse is proposed as it is applied with modified multi-dimensional based bottom-up approach as it carried out various activities to deeply analysis the data based on content profiling. In the process of cleaning, confirming and delivery of data depends on the various data sources. Then algorithm makes three various processes of data extraction as it provides data cleaning and conforming to create the conform steps based on the source data analysis using data hierarchy structure. Until the data sources gets integrated based on the various distributed database, ETL steps are performed. In the analysis, modified ETL is applied on any real time organization as it takes various source table to compare the actual and expected results. Then various metadata testing is performed on various documentation to makes the process of transformation effective.