| Nome: | Descrição: | Tamanho: | Formato: | |
|---|---|---|---|---|
| 2.03 MB | Adobe PDF |
Autores
Orientador(es)
Resumo(s)
Presently, 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.
Descrição
Internship Report presented as the partial requirement for obtaining a Master's degree in Data Science and Advanced Analytics, specialization in Data Science
Palavras-chave
Centralize Data transformation ETL process SSIS packages T-SQL PowerBi report
