{"product_id":"data-warehousing-fundamentals-for-it-professionals-hardback-9780470462072","title":"Data Warehousing Fundamentals for IT Professionals (Hardback) 9780470462072","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eData Warehousing Fundamentals for IT Professionals\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003ePaulraj Ponniah (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9780470462072, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eHardback, published 11 June 2010\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e608 pages\u003cbr\u003e25.6 x 18.5 x 3.6 cm, 1.179 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cem\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\"... clearly the author is a long-time practitioner and expert in this area. And if this were not enough, the language is clear and precise, and the associated content is easily internalised.\" (\u003cem\u003eBCS\u003c\/em\u003e, August 2010)\u003c\/p\u003e\u003c\/font\u003e\u003c\/em\u003e\u003c\/p\u003e\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\u003cb\u003eCUTTING-EDGE CONTENT AND GUIDANCE FROM A DATA WAREHOUSING EXPERT—NOW EXPANDED TO REFLECT FIELD TRENDS\u003c\/b\u003e  \u003c\/p\u003e\n\u003cp\u003eData warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of \u003ci\u003eData Warehousing Fundamentals\u003c\/i\u003e, 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.  \u003c\/p\u003e\n\u003cp\u003eThe 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.  \u003c\/p\u003e\n\u003cp\u003eThis practical \u003ci\u003eSecond Edition\u003c\/i\u003e 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.  \u003c\/p\u003e\n\u003cp\u003eSpecifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, \u003ci\u003eData Warehousing Fundamentals\u003c\/i\u003e presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003ePreface xxv\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1 Overview and Concepts 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e1 The Compelling Need For Data Warehousing 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 3\u003c\/p\u003e \u003cp\u003eEscalating Need For Strategic Information 4\u003c\/p\u003e \u003cp\u003eFailures of Past Decision-Support Systems 9\u003c\/p\u003e \u003cp\u003eOperational Versus Decision-Support Systems 11\u003c\/p\u003e \u003cp\u003eData Warehousing—The Only Viable Solution 13\u003c\/p\u003e \u003cp\u003eA Simple Concept For Information Delivery 15\u003c\/p\u003e \u003cp\u003eThe Data Warehousing Movement 17\u003c\/p\u003e \u003cp\u003eEvolution of Business Intelligence 18\u003c\/p\u003e \u003cp\u003eChapter Summary 20\u003c\/p\u003e \u003cp\u003eReview Questions 20\u003c\/p\u003e \u003cp\u003eExercises 21\u003c\/p\u003e \u003cp\u003e\u003cb\u003e2 Data Warehouse: The Building Blocks 23\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 23\u003c\/p\u003e \u003cp\u003eDefining Features 24\u003c\/p\u003e \u003cp\u003eData Warehouses and Data Marts 29\u003c\/p\u003e \u003cp\u003eArchitectural Types 32\u003c\/p\u003e \u003cp\u003eOverview of The Components 34\u003c\/p\u003e \u003cp\u003eMetadata in The Data Warehouse 41\u003c\/p\u003e \u003cp\u003eChapter Summary 42\u003c\/p\u003e \u003cp\u003eReview Questions 43\u003c\/p\u003e \u003cp\u003eExercises 43\u003c\/p\u003e \u003cp\u003e\u003cb\u003e3 Trends in Data Warehousing 45\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 45\u003c\/p\u003e \u003cp\u003eContinued Growth in Data Warehousing 46\u003c\/p\u003e \u003cp\u003eSignificant Trends 50\u003c\/p\u003e \u003cp\u003eEmergence of Standards 64\u003c\/p\u003e \u003cp\u003eWeb-Enabled Data Warehouse 66\u003c\/p\u003e \u003cp\u003eChapter Summary 69\u003c\/p\u003e \u003cp\u003eReview Questions 69\u003c\/p\u003e \u003cp\u003eExercises 70\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2 Planning and Requirements 71\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e4 Planning and Project Management 73\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 73\u003c\/p\u003e \u003cp\u003ePlanning Your Data Warehouse 74\u003c\/p\u003e \u003cp\u003eThe Data Warehouse Project 79\u003c\/p\u003e \u003cp\u003eThe Development Phases 83\u003c\/p\u003e \u003cp\u003eThe Project Team 85\u003c\/p\u003e \u003cp\u003eProject Management Considerations 90\u003c\/p\u003e \u003cp\u003eChapter Summary 96\u003c\/p\u003e \u003cp\u003eReview Questions 96\u003c\/p\u003e \u003cp\u003eExercises 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003e5 Defining The Business Requirements 99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 99\u003c\/p\u003e \u003cp\u003eDimensional Analysis 100\u003c\/p\u003e \u003cp\u003eInformation Packages—A Useful Concept 103\u003c\/p\u003e \u003cp\u003eRequirements Gathering Methods 109\u003c\/p\u003e \u003cp\u003eRequirements Definition: Scope and Content 116\u003c\/p\u003e \u003cp\u003eChapter Summary 119\u003c\/p\u003e \u003cp\u003eReview Questions 119\u003c\/p\u003e \u003cp\u003eExercises 120\u003c\/p\u003e \u003cp\u003e\u003cb\u003e6 Requirements As The Driving Force For Data Warehousing 121\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 121\u003c\/p\u003e \u003cp\u003eData Design 122\u003c\/p\u003e \u003cp\u003eThe Architectural Plan 125\u003c\/p\u003e \u003cp\u003eData Storage Specifications 131\u003c\/p\u003e \u003cp\u003eDBMS Selection 132\u003c\/p\u003e \u003cp\u003eInformation Delivery Strategy 133\u003c\/p\u003e \u003cp\u003eChapter Summary 136\u003c\/p\u003e \u003cp\u003eReview Questions 136\u003c\/p\u003e \u003cp\u003eExercises 137\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3 Architecture and Infrastructure 139\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e7 Architectural Components 141\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 141\u003c\/p\u003e \u003cp\u003eUnderstanding Data Warehouse Architecture 141\u003c\/p\u003e \u003cp\u003eDistinguishing Characteristics 143\u003c\/p\u003e \u003cp\u003eArchitectural Framework 146\u003c\/p\u003e \u003cp\u003eTechnical Architecture 148\u003c\/p\u003e \u003cp\u003eArchitectural Types 156\u003c\/p\u003e \u003cp\u003eChapter Summary 160\u003c\/p\u003e \u003cp\u003eReview Questions 160\u003c\/p\u003e \u003cp\u003eExercises 161\u003c\/p\u003e \u003cp\u003e\u003cb\u003e8 Infrastructure As The Foundation For Data Warehousing 163\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 163\u003c\/p\u003e \u003cp\u003eInfrastructure Supporting Architecture 164\u003c\/p\u003e \u003cp\u003eHardware and Operating Systems 166\u003c\/p\u003e \u003cp\u003eDatabase Software 181\u003c\/p\u003e \u003cp\u003eCollection of Tools 184\u003c\/p\u003e \u003cp\u003e Data Warehouse Appliances 188\u003c\/p\u003e \u003cp\u003eChapter Summary 191\u003c\/p\u003e \u003cp\u003eReview Questions 191\u003c\/p\u003e \u003cp\u003eExercises 192\u003c\/p\u003e \u003cp\u003e\u003cb\u003e9 The Significant Role of Metadata 193\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 193\u003c\/p\u003e \u003cp\u003eWhy Metadata Is Important 193\u003c\/p\u003e \u003cp\u003eMetadata Types By Functional Areas 203\u003c\/p\u003e \u003cp\u003eBusiness Metadata 207\u003c\/p\u003e \u003cp\u003eTechnical Metadata 209\u003c\/p\u003e \u003cp\u003eHow To Provide Metadata 212\u003c\/p\u003e \u003cp\u003eChapter Summary 219\u003c\/p\u003e \u003cp\u003eReview Questions 220\u003c\/p\u003e \u003cp\u003eExercises 220\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4 Data Design and Data Preparation 223\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e10 Principles of Dimensional Modeling 225\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 225\u003c\/p\u003e \u003cp\u003eFrom Requirements To Data Design 225\u003c\/p\u003e \u003cp\u003eThe Star Schema 232\u003c\/p\u003e \u003cp\u003eStar Schema Keys 239\u003c\/p\u003e \u003cp\u003eAdvantages of The Star Schema 241\u003c\/p\u003e \u003cp\u003eStar Schema: Examples 244\u003c\/p\u003e \u003cp\u003eChapter Summary 246\u003c\/p\u003e \u003cp\u003eReview Questions 247\u003c\/p\u003e \u003cp\u003eExercises 247\u003c\/p\u003e \u003cp\u003e\u003cb\u003e11 Dimensional Modeling: Advanced Topics 249\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 249\u003c\/p\u003e \u003cp\u003eUpdates To The Dimension Tables 250\u003c\/p\u003e \u003cp\u003eMiscellaneous Dimensions 255\u003c\/p\u003e \u003cp\u003eThe Snowflake Schema 259\u003c\/p\u003e \u003cp\u003eAggregate Fact Tables 262\u003c\/p\u003e \u003cp\u003eFamilies of Stars 272\u003c\/p\u003e \u003cp\u003eChapter Summary 277\u003c\/p\u003e \u003cp\u003eReview Questions 278\u003c\/p\u003e \u003cp\u003eExercises 278\u003c\/p\u003e \u003cp\u003e\u003cb\u003e12 Data Extraction, Transformation, and Loading 281\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 281\u003c\/p\u003e \u003cp\u003eETL Overview 282\u003c\/p\u003e \u003cp\u003eETL Requirements and Steps 284\u003c\/p\u003e \u003cp\u003eData Extraction 286\u003c\/p\u003e \u003cp\u003eData Transformation 295\u003c\/p\u003e \u003cp\u003eData Loading 302\u003c\/p\u003e \u003cp\u003eETL Summary 308\u003c\/p\u003e \u003cp\u003eOther Integration Approaches 311\u003c\/p\u003e \u003cp\u003eChapter Summary 313\u003c\/p\u003e \u003cp\u003eReview Questions 313\u003c\/p\u003e \u003cp\u003eExercises 314\u003c\/p\u003e \u003cp\u003e\u003cb\u003e13 Data Quality: A Key To Success 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 315\u003c\/p\u003e \u003cp\u003eWhy Is Data Quality Critical? 316\u003c\/p\u003e \u003cp\u003eData Quality Challenges 323\u003c\/p\u003e \u003cp\u003eData Quality Tools 326\u003c\/p\u003e \u003cp\u003eData Quality Initiative 328\u003c\/p\u003e \u003cp\u003eMaster Data Management (Mdm) 335\u003c\/p\u003e \u003cp\u003eMDM Categories 335\u003c\/p\u003e \u003cp\u003eMDM Benefits 335\u003c\/p\u003e \u003cp\u003eMDM and Data Warehousing 336\u003c\/p\u003e \u003cp\u003eChapter Summary 336\u003c\/p\u003e \u003cp\u003eReview Questions 336\u003c\/p\u003e \u003cp\u003eExercises 337\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5 Information Access and Delivery 339\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e14 Matching Information To The Classes of Users 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 341\u003c\/p\u003e \u003cp\u003eInformation From The Data Warehouse 342\u003c\/p\u003e \u003cp\u003eWho Will Use The Information? 349\u003c\/p\u003e \u003cp\u003eInformation Delivery 356\u003c\/p\u003e \u003cp\u003eInformation Delivery Tools 360\u003c\/p\u003e \u003cp\u003eInformation Delivery: Special Topics 366\u003c\/p\u003e \u003cp\u003eChapter Summary 371\u003c\/p\u003e \u003cp\u003eReview Questions 371\u003c\/p\u003e \u003cp\u003eExercises 372\u003c\/p\u003e \u003cp\u003e\u003cb\u003e15 OLAP in The Data Warehouse 373\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 373\u003c\/p\u003e \u003cp\u003eDemand For Online Analytical Processing 374\u003c\/p\u003e \u003cp\u003eOLAP is The Answer 379\u003c\/p\u003e \u003cp\u003eOLAP Definitions and Rules 379\u003c\/p\u003e \u003cp\u003eOLAP Characteristics 382\u003c\/p\u003e \u003cp\u003eMajor Features and Functions 382\u003c\/p\u003e \u003cp\u003eOLAP Models 393\u003c\/p\u003e \u003cp\u003eOLAP Implementation Considerations 398\u003c\/p\u003e \u003cp\u003eChapter Summary 404\u003c\/p\u003e \u003cp\u003eReview Questions 405\u003c\/p\u003e \u003cp\u003eExercises 405\u003c\/p\u003e \u003cp\u003e\u003cb\u003e16 Data Warehousing and The Web 407\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 407\u003c\/p\u003e \u003cp\u003eWeb-Enabled Data Warehouse 408\u003c\/p\u003e \u003cp\u003eWeb-Based Information Delivery 414\u003c\/p\u003e \u003cp\u003eOLAP and The Web 420\u003c\/p\u003e \u003cp\u003eBuilding A Web-Enabled Data Warehouse 421\u003c\/p\u003e \u003cp\u003eChapter Summary 426\u003c\/p\u003e \u003cp\u003eReview Questions 426\u003c\/p\u003e \u003cp\u003eExercises 427\u003c\/p\u003e \u003cp\u003e\u003cb\u003e17 Data Mining Basics 429\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 429\u003c\/p\u003e \u003cp\u003eWhat Is Data Mining? 430\u003c\/p\u003e \u003cp\u003eMajor Data Mining Techniques 439\u003c\/p\u003e \u003cp\u003eData Mining Applications 452\u003c\/p\u003e \u003cp\u003eChapter Summary 459\u003c\/p\u003e \u003cp\u003eReview Questions 459\u003c\/p\u003e \u003cp\u003eExercises 460\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 6 Implementation and Maintenance 461\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003e18 The Physical Design Process 463\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 463\u003c\/p\u003e \u003cp\u003ePhysical Design Steps 464\u003c\/p\u003e \u003cp\u003ePhysical Design Considerations 467\u003c\/p\u003e \u003cp\u003ePhysical Storage 473\u003c\/p\u003e \u003cp\u003eIndexing The Data Warehouse 477\u003c\/p\u003e \u003cp\u003ePerformance Enhancement Techniques 483\u003c\/p\u003e \u003cp\u003eChapter Summary 486\u003c\/p\u003e \u003cp\u003eReview Questions 486\u003c\/p\u003e \u003cp\u003eExercises 487\u003c\/p\u003e \u003cp\u003e\u003cb\u003e19 Data Warehouse Deployment 489\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 489\u003c\/p\u003e \u003cp\u003eData Warehouse Testing 490\u003c\/p\u003e \u003cp\u003eMajor Deployment Activities 491\u003c\/p\u003e \u003cp\u003eConsiderations For A Pilot 497\u003c\/p\u003e \u003cp\u003eSecurity 502\u003c\/p\u003e \u003cp\u003eBackup and Recovery 504\u003c\/p\u003e \u003cp\u003eChapter Summary 508\u003c\/p\u003e \u003cp\u003eReview Questions 508\u003c\/p\u003e \u003cp\u003eExercises 509\u003c\/p\u003e \u003cp\u003e\u003cb\u003e20 Growth and Maintenance 511\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Objectives 511\u003c\/p\u003e \u003cp\u003eMonitoring The Data Warehouse 512\u003c\/p\u003e \u003cp\u003eUser Training and Support 515\u003c\/p\u003e \u003cp\u003eManaging The Data Warehouse 520\u003c\/p\u003e \u003cp\u003eChapter Summary 524\u003c\/p\u003e \u003cp\u003eReview Questions 525\u003c\/p\u003e \u003cp\u003eExercises 525\u003c\/p\u003e \u003cp\u003eAnswers To Selected Exercises 527\u003c\/p\u003e \u003cp\u003eAppendix A: Project Life Cycle Steps and Checklists 531\u003c\/p\u003e \u003cp\u003eAppendix B: Critical Factors For Success 535\u003c\/p\u003e \u003cp\u003eAppendix C: Guidelines For Evaluating Vendor Solutions 537\u003c\/p\u003e \u003cp\u003eAppendix D: Highlights of Vendors and Products 539\u003c\/p\u003e \u003cp\u003eAppendix E: Real-World Examples of Best Practices 549\u003c\/p\u003e \u003cp\u003eReferences 555\u003c\/p\u003e \u003cp\u003eGlossary 557\u003c\/p\u003e \u003cp\u003eIndex 565\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer networking \u0026amp; communications [\u003ca title=\"See our other books on Computer networking \u0026amp; communications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20networking%20\u0026amp;%20communications%20%5BUT%5D%22\"\u003eUT\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wiley","offers":[{"title":"Brand New","offer_id":52276283212056,"sku":"9780470462072","price":87.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9780470462072.jpg?v=1781366138","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/data-warehousing-fundamentals-for-it-professionals-hardback-9780470462072","provider":"Freshly Printed Books","version":"1.0","type":"link"}