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.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
