Implementing Data Warehouse On-premises
Obisesan, Abiodun Bamidele (2021)
Obisesan, Abiodun Bamidele
2021
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-202103293931
https://urn.fi/URN:NBN:fi:amk-202103293931
Tiivistelmä
Data whether historical or live is now more crucial to the success of a business more than ever before. Organizations are leveraging on the ability to query the stored data to make sound business decision.
This work has examined the implementation of Data warehouse from its historical viewpoint, importance, and actual implementation. Specific attention was paid to data warehouse evolution overtime. Associated tools like SSIS, SSAS and SSRS were thoroughly examined.
Furthermore, this work replicated the production of data warehouse on-premises. All possible scenarios in a real project were carefully considered. For example, the issue of business rules and steps to data warehouse implementation were duly considered in chapter two and three.
The actual implementation was carried out in Chapter four. The objectives of the work were to understand how to implement a data warehouse from an enterprise standpoint. Emphasis was placed on extract load and transform where scalability and performance were important factors. Chapter five of this work discussed the result while appropriate recommendations were made.
This work has examined the implementation of Data warehouse from its historical viewpoint, importance, and actual implementation. Specific attention was paid to data warehouse evolution overtime. Associated tools like SSIS, SSAS and SSRS were thoroughly examined.
Furthermore, this work replicated the production of data warehouse on-premises. All possible scenarios in a real project were carefully considered. For example, the issue of business rules and steps to data warehouse implementation were duly considered in chapter two and three.
The actual implementation was carried out in Chapter four. The objectives of the work were to understand how to implement a data warehouse from an enterprise standpoint. Emphasis was placed on extract load and transform where scalability and performance were important factors. Chapter five of this work discussed the result while appropriate recommendations were made.