Joy Mundy, Warren Thornthwaite, Ralph Kimball

The Microsoft Data Warehouse Toolkit

With SQL Server 2005 and the Microsoft Business Intelligence Toolset

• Broschiertes Buch

Produktbeschreibung

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.

Produktdetails

• Verlag: Wiley & Sons
• Seitenzahl: 720
• Englisch
• Gewicht: 1135g
• ISBN-13: 9780471267157
• ISBN-10: 0471267155
• Artikelnr.: 15168915

Autorenporträt

Ralph Kimball, PhD, has been a leading visionary in the data warehouse industry since 1982 and is one of today's most well- known speakers, consultants, and teachers. He writes the "Data Warehouse Designer" column for Intelligent Enterprise magazine and is also the author of the bestselling books The Data Warehouse Lifecycle Toolkit and The Data Webhouse Toolkit (both from Wiley).

Inhaltsangabe

PART I: REQUIREMENTS, REALITIES, AND ARCHITECTURE.
1. Defining Business Requirements.
2. Designing the Business Process Dimensional Model.
3. The Toolset.

PART II: DEVELOPING AND POPULATING THE DATABASES.
4. Setup and Physical Design.
5. Designing the ETL System.
6. Developing the ETL System.
7. Designing the Aanalysis Services OLAP Database.

PART III: DEVELOPING THE BI APPLICATIONS.
8. Business Intelligence Applications.
9. Building the BI Application in Reporting Services.
10. Incorporating Data Mining.

PART IV: DEPLOYING AND MANAGING THE DW/BI SYSTEM.
11. Working with an Existing Data Warehouse.
12. Security.
13. Metadata.
14. Deploying the BI System.
15. Operations and Maintenance.

PART V: EXTENDING THE DW/BI SYSTEM.
16. Managing Growth.
17. Real-Time Business Intelligence.
18. Present Imperatives and Future Outlook.
Index.