Data warehousing fundamentals for IT professionals 2nd ed.

Author

• Ponniah, Paulraj

Additional Author(s)

-

Publisher

Hoboken, New Jersey: John Wiley and Sons, Inc., 2010

Language

English

ISBN

9780470462072

Series

Subject(s)

• DATA WAREHOUSING

Notes

• Glossary: p. 557-564

. Bibliography: p. 555-556. Index: p. 565-571

Abstract

Cutting-edge content and guidance from a data warehousing expert-now expanded to reflect field trends
Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field.
The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery.
This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information.
Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, Data Warehousing Fundamentals presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.

Physical Dimension

Number of Page(s)

xxvii, 571 p.

Dimension

26 cm.

Other Desc.

ill.

Summary / Review / Table of Content

Preface.

Part 1 OVERVIEW AND CONCEPTS.
1 The Compelling Need for Data Warehousing
2 Data Warehouse: The Building Blocks.
3 Trends in Data Warehousing.

Part 2 PLANNING AND REQUIREMENTS.
4 Planning and Project Management.
5 Defining the Business Requirements.
6 Requirements as the Driving Force for Data Warehousing.

Part 3 ARCHITECTURE AND INFRASTRUCTURE.
7 The Architectural Components.
8 Infrastructure as the Foundation for Data Warehousing.
9 The Significant Role of Metadata

Part 4 DATA DESIGN AND DATA PREPARATION.
10 Principles of Dimensional Modeling
11 Dimensional Modeling: Advanced Topics.
12 Data Extraction, Transformation, and Loading.
13 Data Quality: A Key to Success.

Part 5 INFORMATION ACCESS AND DELIVERY.
14 Matching Information to the Classes of Users
15 OLAP in the Data Warehouse.
16 Data Warehousing and the Web.
17 Data Mining Basics.
18 The Physical Design Process.
19 Data Warehouse Deployment
20 Growth and Maintenance.

Appendix A. Project Life Cycle Steps and Checklists.
Appendix B. Critical Factors for Success.
Appendix C. Guidelines for Evaluating Vendor Solutions.
Appendix D. Highlights of Vendors and Products.
Appendix E. Real-World Examples of Best Practices.
References.
Glossary.
Index.

Exemplar(s)

#	Accession No.	Call Number	Location	Status
1.	00462/17	005.745 Pon D	Library - 7th Floor	Available