The Microsoft data warehouse toolkit : with SQL server 2008 R2 and the Microsoft Business Intelligence toolset

The Microsoft data warehouse toolkit : with SQL server 2008 R2 and the Microsoft Business Intelligence toolset / Joy Mundy and Warren Thornthwaite, with Ralph Kimball.

Best practices and invaluable advice from world-renowned data warehouse expertsIn 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 edit...

Full description

Saved in:
Bibliographic Details
Main Author: Mundy, Joy, 1961-
Other Authors: Thornthwaite, Warren, 1957-, Kimball, Ralph
Format: eBook
Language:English
Published: Indianapolis, IN : Wiley, ©2011.
Edition:2nd ed.
Subjects:
SQL server.
SQL server
Data warehousing.
Client/server computing.
Client/server computing
Data warehousing
Online Access:Click for online access
Table of Contents:
  • Requirements, realities, and architecture
  • Defining business requirements
  • Designing the business process dimensional model
  • The toolset
  • System setup
  • Building and populating the databases
  • Creating the relational data warehouse
  • Master data management
  • Designing and developing the ETL system
  • The core analysis services OLAP database
  • Design requirements for real-time BI
  • Developing the BI applications
  • Building BI applications in reporting services
  • PowerPivot and Excel
  • The BI portal and SharePoint
  • Incorporating data mining
  • Deploying and managing the DW/BI system
  • Designing the implementing security
  • Metadata plan
  • Deployment
  • Operations and maintenance
  • Present imperatives and future outlook.

Similar Items