The thesis describes the realization of datamart for small and medium-sized businesses (SMB) in an existing data warehouse environment conforming to Kimball Bus architecture. The introductory section deals with the theoretical guidelines of data warehousing and Business Intelligence. Following with the analysis of the current state of SMB datamart and data warehouse architecture. The results together with business requirements are used for the design of new datamart which encompasses ETL processes, OLTP database, OLAP model and reports. Each of these components are implemented using the tools from Microsoft. Final solution is tested and deployed on the production instance of database server running MS SQL Server.
Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:429310 |
Date | January 2018 |
Creators | Balko, Michal |
Source Sets | Czech ETDs |
Language | Slovak |
Detected Language | English |
Type | info:eu-repo/semantics/masterThesis |
Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.0017 seconds