Data Warehousing Fundamentals for it Professionals, Second Edition, Second Edition

✍ Scribed by Paulraj Ponniah(auth.)

• Year: 2010
• Tongue: English
• Leaves: 578
• Category: Library

✦ Synopsis

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.Content:
Chapter 1 The Compelling Need for Datawarehousing (pages 1–21):
Chapter 2 Datawarehouse: The Building Blocks (pages 23–44):
Chapter 3 Trends in Datawarehousing (pages 45–70):
Chapter 4 Planning and Project Management (pages 71–97):
Chapter 5 Defining the Business Requirements (pages 99–120):
Chapter 6 Requirements as the Driving Force for Datawarehousing (pages 121–138):
Chapter 7 Architectural Components (pages 139–161):
Chapter 8 Infrastructure as the Foundation for Datawarehousing (pages 163–192):
Chapter 9 The Significant Role of Metadata (pages 193–221):
Chapter 10 Principles of Dimensional Modeling (pages 223–248):
Chapter 11 Dimensional Modeling: Advanced Topics (pages 249–279):
Chapter 12 Data Extraction, Transformation, and Loading (pages 281–314):
Chapter 13 Data Quality: A Key to Success (pages 315–337):
Chapter 14 Matching Information to the Classes of Users (pages 339–372):
Chapter 15 Olap in the Datawarehouse (pages 373–406):
Chapter 16 Datawarehousing and the Web (pages 407–427):
Chapter 17 Data Mining Basics (pages 429–460):
Chapter 18 The Physical Design Process (pages 461–487):
Chapter 19 Datawarehouse Deployment (pages 489–509):
Chapter 20 Growth and Maintenance (pages 511–525):