Castelli, MauroZaher, Abdallah Ali2022-04-052022-04-052022-04-01http://hdl.handle.net/10362/135876Internship Report presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Data SciencePresently, the amount of data produced every day is truly mind-boggling. There are 2.5 quintillion bytes of data created each day at this current pace and companies are actively generating and collecting it. This data has become of the utmost importance and companies are changing their behavior towards it. Many of these companies nowadays are giving more consideration and time investment into the data analytics area. They have started to figure out a way on how to use their customers’/clients’ data to generate insights and strategies for better futuristic marketing approaches. In order to have a better understanding of the data, these corporations took the initiative to centralize it in an arranged manner so that the analysis will be more organized through the whole procedure. The following internship report studies the transformation of data from its very early stages to the final PowerBi part. This report will discuss specifically the ETL process that the data undergoes from how the data is collected via SSIS packages, treated through T-SQL, and provided as a clean final table to build a PowerBi report from it so that other employees and people who do not have much knowledge about data will be able to see through graphs that explain what the data means and what insights it holds within.engCentralizeData transformationETL processSSIS packagesT-SQLPowerBi reportmaster thesis202988180