The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 4, 2014

Edward E. Baptist: IMG The Two Bodies of The Half Has Never Been Told: Slavery and the Making of American Capitalism



My new book, The Half Has Never Been Told: Slavery and the Making of American Capitalism, is the story of two bodies. The first body was the new... Continue »
  1. $24.50 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$29.00
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Database- Applications

More copies of this ISBN

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

by

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset Cover

ISBN13: 9780471267157
ISBN10: 0471267155
Condition: Standard
All Product Details

Only 1 left in stock at $29.00!

 

Synopses & Reviews

Publisher Comments:

This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.

Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.

Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.

Intended Audience

The target audience for this book is the IT department or service provider (consultant) who is:

  • Planning a small to mid-range data warehouse project;
  • Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology;
  • Familiar with the general concepts of data warehousing and business intelligence.

The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book’s content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interesting to a database administrator or programmer as guiding information.

The book is focused on the mass market, where the volume of data in a single application or data mart is less than 500 GB of raw data. While the book does discuss issues around handling larger warehouses in the Microsoft environment, it is not exclusively, or even primarily, concerned with the unusual challenges of extremely large datasets.

About the Authors

JOY MUNDY has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy co-founded InfoDynamics LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse.

Before returning to consulting with the Kimball Group in 2004, Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy began her career as a business analyst in banking and finance. She graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.

WARREN THORNTHWAITE has been building data warehousing and business intelligence systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm, with his co-author, Joy Mundy. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting with the Kimball Group. In addition to designing data warehouses for a range of industries, Warren speaks at major industry conferences and for leading vendors, and is a long-time instructor for Kimball University. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan.

RALPH KIMBALL, PH.D., has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known authors, speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine.

Synopsis:

As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance.

You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team and learn how to:

  • Identify high-value business requirements and build organizational support for the project
  • Design an information infrastructure for the enterprise using established dimensional design
  • Design and build a flexible and powerful ETL system to clean, align, and restructure data for business use
  • Provide decision makers with tools to analyze business problems and opportunities
  • Use data mining to uncover data relationships and trends
  • Build BI applications in Reporting Services
  • Maintain, secure, and operate the DW/BI system

Visit the companion Web site at www.wiley.com/go/MsftDWToolkit

The companion Web site contains all the code samples, the sample database used throughout, sample templates, and other job aids.

Synopsis:

Microsoft is completely revamping its database product, SQL Server, and adding a host of new tools that will provide a powerful, full featured data warehouse toolset perfectly suited for smaller organizations. This book offers practical examples implemented on the Microsoft's Business Intelligence (BI) toolset and is structured around the major phases of a data warehouse project plan: design, develop, deploy, and maintain.

About the Author

Joy Mundy, a member of the Kimball Group, has been developing, consulting on, and speaking and writing about business intelligence systems and technology since 1992. Joy began her career as a business analyst in banking and finance as one of the power users we talk about in business intelligence. In 1992 she joined the data warehouse team at Stanford University, an effort that was both educational and character building. She next co-founded InfoDynamics LLC, a data warehouse consulting firm, and then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged business intelligence system. From 2000 to 2004, Joy worked with the Microsoft SQL Server Business Intelligence product development team. She managed a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy graduated from Tufts University with a B.A. in Economics, and from Stanford with an M.S. in Engineering Economic Systems.

Warren Thornthwaite, a member of the Kimball Group, has been building decision support and data warehousing systems since 1980. Warren co-authored the best-selling Data Warehouse Lifecycle Toolkit (Wiley, 1998). Warren worked at Metaphor Computer Systems for eight years starting in 1983, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then cofounded InfoDynamics LLC, a data warehouse consulting firm. Warren joined up with WebTV to help build a world-class, multi-terabyte customer-focused data warehouse before returning to consulting.

In addition to designing data warehouses for a range of industries, Warren has extensive experience helping clients develop scalable, practical information access architectures. Warren holds an MBA in Decision Sciences from the University of Pennsylvania’s Wharton School, and a BA in Communications Studies from the University of Michigan.

Ralph Kimball, Ph.D., founder of the Kimball Group, has been designing information systems and data warehouses since 1972. Ralph wrote his Ph.D. dissertation in the Electrical Engineering department at Stanford University on the design of a man–machine system for tutoring mathematics students. In 1972 he joined the Xerox Palo Alto Research Center as a research scientist. Over the following ten years at Xerox, he became a development manager and the product marketing manager for the Xerox Star workstation, the first commercial product that used windows, icons, and the mouse. For this work at Xerox, he received the Alexander Williams Award from the IEEE Human Factors Society for user interface design. Following his years at Xerox, Ralph was a vice president and member of the founding team at Metaphor Computer Systems, the first data warehousing company. Between 1982 and 1986, Metaphor installed many client-server data warehouse systems. In 1986 Ralph founded Red Brick Systems, which developed the first high-performance relational database for decision support. Since 1993, Ralph has designed data warehouse systems, written bestselling data warehouse books, and taught data warehousing skills to more than 10,000 IT professionals.

Table of Contents

Foreword.

Preface.

Acknowledgments.

Introduction.

Part One Requirements, Realities, and Architecture.

Chapter 1 Defining Business Requirements.

Chapter 2 Designing the Business Process Dimensional Model.

Chapter 3 The Toolset.

Part Two Developing and Populating the Databases.

Chapter 4 Setup and Physical Design.

Chapter 5 Designing the ETL System.

Chapter 6 Developing the ETL System.

Chapter 7 Designing the Analysis Services OLAP Database.

Part Three Developing the BI Applications.

Chapter 8 Business Intelligence Applications.

Chapter 9 Building the BI Application in Reporting Services.

Chapter 10 Incorporating Data Mining.

Part Four Deploying and Managing the DW/BI System.

Chapter 11 Working with an Existing Data Warehouse.

Chapter 12 Security.

Chapter 13 Metadata Plan.

Chapter 14 Deployment.

Chapter 15 Operations and Maintenance.

Part Five Extending the DW/BI System.

Chapter 16 ManagingGrowth.

Chapter 17 Real-Time Business Intelligence.

Chapter 18 Present Imperatives and Future Outlook.

Index.

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

gdm, June 28, 2006 (view all comments by gdm)
Let me say, this is an absolutely WONDERFUL book. I originally bought Teo Lachev's book. It is technically very good and I will keep it around, but The Microsoft Data Warehouse Toolkit is absolutely outstanding in the way it takes you by the hand and walks you step-by-step through all the initial stages of a DW/BI project -- an area in which Lachev's book is somewhat lacking. Since we are doing a new, first time DW/BI effort at my company, this book - and indeed several of the Kimball books - will be invaluable.
Was this comment helpful? | Yes | No
(1 of 1 readers found this comment helpful)

Product Details

ISBN:
9780471267157
Author:
Mundy, Joy
Publisher:
John Wiley & Sons
With:
Kimball, Ralph
Author:
Thornthwaite,
Author:
Thornthwaite, Warren
Author:
Warren
Author:
Kimball, Ralph
Subject:
Database Management - General
Subject:
Data warehousing
Subject:
Database Management - SQL Server
Subject:
Database Management - Data Warehousing
Subject:
Database-Data Warehousing
Subject:
Database & Data Warehousing Technologies
Copyright:
Edition Description:
WebSite Associated w/Book
Publication Date:
20060505
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
792
Dimensions:
9.12x7.39x1.66 in. 2.57 lbs.

Other books you might like

  1. Professional SQL Server 2005...
    Used Trade Paper $9.50
  2. Data Warehouse Toolkit 2ND Edition Used Trade Paper $36.00

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Database Management
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management
Reference » Science Reference » Technology
Science and Mathematics » Chemistry » General
Science and Mathematics » Electricity » General Electronics

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset Used Trade Paper
0 stars - 0 reviews
$29.00 In Stock
Product details 792 pages John Wiley & Sons - English 9780471267157 Reviews:
"Synopsis" by , As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance.

You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team and learn how to:

  • Identify high-value business requirements and build organizational support for the project
  • Design an information infrastructure for the enterprise using established dimensional design
  • Design and build a flexible and powerful ETL system to clean, align, and restructure data for business use
  • Provide decision makers with tools to analyze business problems and opportunities
  • Use data mining to uncover data relationships and trends
  • Build BI applications in Reporting Services
  • Maintain, secure, and operate the DW/BI system

Visit the companion Web site at www.wiley.com/go/MsftDWToolkit

The companion Web site contains all the code samples, the sample database used throughout, sample templates, and other job aids.

"Synopsis" by , Microsoft is completely revamping its database product, SQL Server, and adding a host of new tools that will provide a powerful, full featured data warehouse toolset perfectly suited for smaller organizations. This book offers practical examples implemented on the Microsoft's Business Intelligence (BI) toolset and is structured around the major phases of a data warehouse project plan: design, develop, deploy, and maintain.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.