Eureka! Institutional Repository

This thesis presents and analyses OLAP technology in depth using Microsoft tools such as SQL Server and Visual Studio with Business Intelligence Server Analysis. In the first chapter we analyze the database that host the data from the various applications and the Data Warehouse that hosts the data for the Business Intelligence analytical process In the second chapter we analyze the OLAP technology by extracting the data from the Data Warehouse and using them to create and fill the cube. The data gets visualized through various techniques – operations to extract information. In the third chapter we are presenting examples using Microsoft tools and we analyze the capabilities that those tools offer, to have a complete OLAP solution. We are creating Data Warehouses and processes that fill the Data Warehouses with data. Concluding we are creating and analyzing OLAP cubes fulfilling by this way the OLAP technology.