Download This PaperImproved Use of ETL Tool for Updation and Creation of Data Warehouse From Different RDBMS
4 Pages Posted: 3 Apr 2020
Date Written: April 8, 2020
Abstract
ETL plays a very important role in any organization in the perspective of taking critical business decisions. The companies can use ETL tool to analyze their business data and answer complex business queries which Transactional databases cannot answer. ETL is a method of moving the data from various sources into a data warehouse. If the data source is changed, ETL facilitates updates on data warehouse automatically. Hence there is a need for welldesigned and documented ETL system for the success of a Data Warehouse project. The Proposed paper shows the execution of ETL operation using Visual Studio 2017 with SQL Server and PowerBi with MS Excel. All the ETL operation steps executed using Visual Studio 2017 with SQL Server and PowerBi with MS Excel provides the improved results for all types of Complex Business Analytics and Queries on top of Data Warehouse. A comparison of these two technologies are carried out.
Keywords: ETL, Data Warehouse, DBMS, Analytics, Execution
Suggested Citation: Suggested Citation