Sale!

The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd edition by Ralph Kimball, Margy Ross, Warren Thornthwaite ISBN 1118067959 9781118067956

Original price was: $50.00.Current price is: $35.00.

The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd edition Edition Kimball Digital Instant Download

Author(s): Kimball, Ralph;Mundy, Joy;Thornthwaite, Warren
ISBN(s): 9781118067956, 1118067959
Edition: 2nd edition
File Details: PDF, 11.32 MB
Year: 2011
Language: english
SKU: EB-11776650 Category: Tags: , , , , ,

The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd Edition by Ralph Kimball, Margy Ross, Warren Thornthwaite – Ebook PDF Instant Download/Delivery: 1118067959, 9781118067956
Full download The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd Edition after payment

Product details:

ISBN 10: 1118067959
ISBN 13: 9781118067956
Author: Ralph Kimball, Margy Ross, Warren Thornthwaite

A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term “business intelligence” emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business. Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand firsthand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You’ll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd Table of contents:

Part 1: Requirements, Realities, and Architecture

  1. Defining Business Requirements

    • The Most Important Determinant of Long-Term Success

    • Adventure Works Cycles Introduction

    • Uncovering Business Value

    • Prioritizing the Business Requirements

    • Revisiting the Project Planning

    • Gathering Project-Level Requirements

    • Summary

  2. Designing the Business Process Dimensional Model

    • Dimensional Modeling Concepts and Terminology

    • Additional Design Concepts and Techniques

    • The Dimensional Modeling Process

    • Case Study: The Adventure Works Cycles Orders Dimensional Model

    • Summary

  3. The Toolset

    • The Microsoft DW/BI Toolset

    • Why Use the Microsoft Toolset?

    • Architecture of a Microsoft DW/BI System

    • Overview of the Microsoft Tools

    • Summary

  4. System Setup

    • System Sizing Considerations

    • System Configuration Considerations

    • Software Installation and Configuration

    • Summary

Part 2: Building and Populating the Databases

  1. Creating the Relational Data Warehouse

    • Getting Started

    • Complete the Physical Design

    • Define Storage and Create Constraints and Supporting Objects

    • Partitioned Tables

    • Finishing Up

    • Summary

  2. Master Data Management

    • Managing Master Reference Data

    • Introducing SQL Server Master Data Services

    • Creating a Simple Application

    • Summary

  3. Designing and Developing the ETL System

    • Round Up the Requirements

    • Develop the ETL Plan

    • Introducing SQL Server Integration Services

    • The Major Subsystems of ETL

    • Extracting Data

    • Subsystems Overview

    • Summary

  4. The Core Analysis Services OLAP Database

    • Overview of OLAP

    • Designing the Cube

    • Building the Cube

    • Processing the Cube

    • Summary

  5. Design Requirements for Real-Time BI

    • Real-Time BI Concepts

    • Designing for Real-Time BI

    • Implementing Real-Time BI

    • Summary

Part 3: Developing the BI Applications

  1. Building BI Applications in Reporting Services

    • Overview of Reporting Services

    • Designing Reports

    • Implementing Reports

    • Deploying Reports

    • Summary

  2. PowerPivot and Excel

    • Overview of PowerPivot

    • Designing PowerPivot Models

    • Implementing PowerPivot Models

    • Summary

  3. The BI Portal and SharePoint

    • Overview of SharePoint

    • Integrating BI with SharePoint

    • Designing the BI Portal

    • Implementing the BI Portal

    • Summary

  4. Incorporating Data Mining

    • Overview of Data Mining

    • Designing Data Mining Models

    • Implementing Data Mining Models

    • Summary

Part 4: Deploying and Managing the DW/BI System

  1. Designing and Implementing Security

    • Security Concepts

    • Designing Security

    • Implementing Security

    • Summary

  2. Metadata Plan

    • Metadata Concepts

    • Designing Metadata

    • Implementing Metadata

    • Summary

  3. Deployment

    • Setting Up the Environments

    • Testing

    • Deploying to Production

    • Data Warehouse and BI Documentation

    • User Training

    • User Support

    • Desktop Readiness and Configuration

    • Summary

  4. Operations and Maintenance

    • Providing User Support

    • System Management

    • Performance Monitoring

    • Usage Monitoring

    • Managing Disk Space

    • Service and Availability Management

    • Performance Tuning the DW/BI System

    • Backup and Recovery

    • Executing the ETL Packages

    • Summary

Part 5: Present Imperatives and Future Outlook

  1. Present Imperatives and Future Outlook

    • Current Trends

    • Future Directions

    • Summary

People also search for The Microsoft Data Warehouse Toolkit With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset 2nd:

the microsoft data warehouse toolkit with sql

the microsoft data warehouse toolkit

the data warehouse toolkit pdf

the data warehouse toolkit free pdf

the data warehouse toolkit 4th edition

Tags: Ralph Kimball, Margy Ross, Warren Thornthwaite, Microsoft Data