Data analytics in cloud data warehousing, case company
Ly, Duong Hai (2019)
2019
All rights reserved. This publication is copyrighted. You may download, display and print it for Your own personal use. Commercial use is prohibited.
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201904175534
https://urn.fi/URN:NBN:fi:amk-201904175534
Tiivistelmä
The objective of the final year project was to discover a solution for gathering and analyzing digital marketing service data from different sources such as Google ads, Facebook ads and internal database of case company. By viewing well-presented analyzed data, business owners, sales and campaign managers could easily achieve better and accurate planning and forecasting. As a result, this would improve case company business strategies.
To reach the mentioned objective above, the cloud data warehousing solution was required to tackle two problems. Firstly, required data are scattered among the internet which often makes the analysis processes more complex and time consuming. Secondly, data have different models and analyzing such a large quantities of data demands a high-performance data processing platform.
The project has successfully created a cloud data warehouse in Snowflake and scheduled different analytics processes on the given data imported from various sources. In addition, one of the most important outcomes of the project is that it provides various report files that contain analytics data.
To reach the mentioned objective above, the cloud data warehousing solution was required to tackle two problems. Firstly, required data are scattered among the internet which often makes the analysis processes more complex and time consuming. Secondly, data have different models and analyzing such a large quantities of data demands a high-performance data processing platform.
The project has successfully created a cloud data warehouse in Snowflake and scheduled different analytics processes on the given data imported from various sources. In addition, one of the most important outcomes of the project is that it provides various report files that contain analytics data.