In this article, I have shown you the 6 different phases of the Data Analytics Life cycle and its associated processes and tools. Along with it demonstrated the process of Extract Transform and Load, beginning with Data Wrangling where we worked on raw data, transforming it into accurate format using excel, then loading it into MS Visual Studio and Mapping it to get data into MS SQL Data Base without errors along with data anomality in separate text file.