The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset [NOOK Book]

Overview

Learn to use SQL Server 2008 R2 to build a successful data warehouse

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL ...

See more details below
The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$28.99
BN.com price
(Save 42%)$50.00 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

Learn to use SQL Server 2008 R2 to build a successful data warehouse

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance.

In addition to a substantial update to the content of the previous edition as well as a look at the new features and functionality of SQL Server 2008 R2 such as PowerPivot and Master Data Services, this new version includes detailed examples that illustrate how to best apply the techniques described in the book. The authors share their own trial-and-error experiences of building a DW/BI system with the Microsoft tools so that you can benefit from their challenges and successes. You'll also discover how using the Kimball Lifecycle to build your DW/BI system encourages you to zero in on four primary principles: focus on the business, build an information infrastructure, deliver in meaningfulincrements, and deliver the entire solution. With these principles in hand, you'll be well on your way to building a successful DW/BI system that supports business intelligence requirements common to most organizations.

No matter your role in the process of working on a DW/BI project, The Microsoft Data Warehouse Toolkit, Second Edition shows you how to:

  • Focus your efforts on the best opportunities

  • Select, install, and configure the appropriate components of SQL Server 2008 R2 and other Microsoft products

  • Design the dimensional model and create the database structures for the relational and Analysis Services databases

  • Build an ETL System in Integration Services to populate the DW/BI databases

  • Build the BI applications and data mining models to deliver value to your organization

  • Manage, secure, and grow the DW/BI system for long-term success

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Read More Show Less

Product Details

  • ISBN-13: 9781118067956
  • Publisher: Wiley
  • Publication date: 2/25/2011
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 2
  • Pages: 720
  • Sales rank: 926,833
  • File size: 14 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Joy Mundy is a member of the Kimball Group and has been focusing on data warehousing and business intelligence since the early 1990s.

Warren Thornthwaite has been building decision support and data warehousing systems since 1980 and is a member of the Kimball Group.

Ralph Kimball, PhD, is known worldwide as an innovator, writer, educator, speaker, and consultant in the field of data warehousing. He is the founder of the Kimball Group (www.kimballgroup.com), which provides data warehouse consulting and education.

Read More Show Less

Table of Contents

Foreword.

Introduction.

Part 1 Requirements, Realities, and Architecture.

Chapter 1 Defining Business Requirements.

Chapter 2 Designing the Business Process Dimensional Model.

Chapter 3 The Toolset.

Chapter 4 System Setup.

Part 2 Building and Populating the Databases.

Chapter 5 Creating the Relational Data Warehouse.

Chapter 6 Master Data Management.

Chapter 7 Designing and Developing the ETL System.

Chapter 8 The Core Analysis Services OLAP Database.

Chapter 9 Design Requirements for Real-Time BI.

Part 3 Developing the BI Applications.

Chapter 10 Building BI Applications in Reporting Services.

Chapter 11 PowerPivot and Excel.

Chapter 12 The BI Portal and SharePoint.

Chapter 13 Incorporating Data Mining.

Part 4 Deploying and Managing the DW/BI System.

Chapter 14 Designing and Implementing Security.

Chapter 15 Metadata Plan.

Chapter 16 Deployment.

Chapter 17 Operations and Maintenance.

Chapter 18 Present Imperatives and Future Outlook.

Index.

Read More Show Less

Customer Reviews

Average Rating 1
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted December 7, 2012

    No text was provided for this review.

  • Anonymous

    Posted July 11, 2011

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)