Data warehousing fundamentals

'This book covers the fundamentals of data warehousing specifically for the IT professional who wants to get into the field. It covers all significant topics, including planning requirements, architecture, infrastructure, design, data preparation, information delivery, implementation, and maintenance. l Includes review questions and exercises l Filled with industry examples l The author has 25 years of experience in IT specialising in data warehousing READERSHIP: IT Professionals, Consultants, Students '

Foreword.

Preface.

PART 1: OVERVIEW AND CONCEPTS.

The Compelling Need for Data Warehousing.

Data Warehouse: The Building Blocks.

Trends in Data Warehousing.

PART 2: PLANNING AND REQUIREMENTS.

Planning and Project Management.

Defining the Business Requirements.

Requirements as the Driving Force for Data Warehousing.

PART 3: ARCHITECTURE AND INFRASTRUCTURE.

The Architectural Components.

Infrastructure as the Foundation for Data Warehousing.

The Significant Role of Metadata.

PART 4: DATA DESIGN AND DATA PREPARATION.

Principles of Dimensional Modeling.

Dimensional Modeling: Advanced Topics.

Data Extraction, Transformation, and Loading.

Data Quality: A Key to Success.

PART 5: INFORMATION ACCESS AND DELIVERY.

Matching Information to the Classes of Users.

OLAP in the Data Warehouse.

Data Warehousing and the Web.

Data Mining Basics.

PART 6: IMPLEMENTATION AND MAINTENANCE.

The Physical Design Process.

Data Warehouse Deployment.

Growth and Maintenance.

Appendix A: Project Life Cycle Steps and Checklists.

Appendix B: Critical Factors for Success.

Appendix C: Guidelines for Evaluating Vendor Solutions.

References.

Glossary.

Index.