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 well-designed 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.