In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming "Business Intelligence release" of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance.
The Microsoft Data Warehouse Toolkit - With SQL Server 2008 R2 and the Microsoft Business Intelligen
Subject Description The data warehousing marketplace continues to be one of the fastest growing areas of technology application. Whether it's used with CRM, ERP, e-Commerce, Financial Analysis, Sales Analysis or any of a large number of other disciplines, data warehousing has become an essential business tool for making informed decisions. This subject introduces students to data warehousing concepts. The subject uses a hands-on project to design and develop a data warehouse. Star schema fact tables and dimension tables will be examined. Multidimensional databases are emphasized as the students build on their database knowledge. A team project will be used to handle the process of moving data from an OLTP system to a DW with management reports through the cube and pivotal tables. Microsoft SQL server 2005 Analysis Services will be used to develop OLAP cubes and Microsoft Excel for OLAP reporting. 2ff7e9595c
Comments