{"product_id":"a-managers-guide-to-data-warehousing-9780470176382","title":"A Managers Guide to Data Warehousing","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eAimed at helping business and IT managers clearly communicate with each other, this helpful book addresses concerns straight-on and provides practical methods to building a collaborative data warehouse . You'll get clear explanations of the goals and objectives of each stage of the data warehouse lifecycle while learning the roles that both business managers and technicians play at each stage. Discussions of the most critical decision points for success at each phase of the data warehouse lifecycle help you understand ways in which both business and IT management can make decisions that best meet unified objectives.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eIntroduction xxiii\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart One The Essentials of Data Warehousing 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Gaining Data Warehouse Success 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Essentials of Data Warehousing 3\u003c\/p\u003e \u003cp\u003eWhat Is a Data Warehouse? 4\u003c\/p\u003e \u003cp\u003eDifferences Between Operational and DW Systems 4\u003c\/p\u003e \u003cp\u003eThe Data Warehousing Environment 4\u003c\/p\u003e \u003cp\u003eWhat Is a Data Model? 6\u003c\/p\u003e \u003cp\u003eUnderstanding Industry Perspectives 7\u003c\/p\u003e \u003cp\u003eDesign and Development Sequence 8\u003c\/p\u003e \u003cp\u003eWhy Build a Data Warehouse? 11\u003c\/p\u003e \u003cp\u003eThe Value of Data Warehousing 12\u003c\/p\u003e \u003cp\u003eThe Promises of Data Warehousing 15\u003c\/p\u003e \u003cp\u003eKeys to Success 16\u003c\/p\u003e \u003cp\u003eDeveloping and Maintaining Strong Business and Technology Partnerships 17\u003c\/p\u003e \u003cp\u003eIdentifying True Business Requirements 17\u003c\/p\u003e \u003cp\u003eShifting to a Global Perspective 18\u003c\/p\u003e \u003cp\u003eOvercoming Unrealistic Expectations 19\u003c\/p\u003e \u003cp\u003eProviding Clear Communication 20\u003c\/p\u003e \u003cp\u003eTreating Data As a Corporate Asset 21\u003c\/p\u003e \u003cp\u003eEffectively Leveraging Technology 21\u003c\/p\u003e \u003cp\u003eRoadblocks to Success 22\u003c\/p\u003e \u003cp\u003eBelieving the Myth: ‘‘If You Build It, They Will Come’’ 22\u003c\/p\u003e \u003cp\u003eFalling into the Project Deadline Trap 23\u003c\/p\u003e \u003cp\u003eFailing to Uphold Organizational Discipline 23\u003c\/p\u003e \u003cp\u003eLacking Business Process Change 24\u003c\/p\u003e \u003cp\u003eNarrowing the Focus Too Much 25\u003c\/p\u003e \u003cp\u003eResting on Your Laurels 27\u003c\/p\u003e \u003cp\u003eRelying on the Technology Fix 27\u003c\/p\u003e \u003cp\u003eGetting the Right People Involved 28\u003c\/p\u003e \u003cp\u003eFinding Lost Institutional Knowledge 29\u003c\/p\u003e \u003cp\u003eSummary 30\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 The Executive’s FAQ for Data Warehousing 31\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eQuestion: What is the business benefit of a data warehouse? 32\u003c\/p\u003e \u003cp\u003eAnswer 32\u003c\/p\u003e \u003cp\u003eQuestion: How much will it cost? 33\u003c\/p\u003e \u003cp\u003eAnswer 33\u003c\/p\u003e \u003cp\u003eQuestion: How long will it take? 34\u003c\/p\u003e \u003cp\u003eAnswer 35\u003c\/p\u003e \u003cp\u003eQuestion: How can I ensure success? 36\u003c\/p\u003e \u003cp\u003eAnswer 36\u003c\/p\u003e \u003cp\u003eQuestion: Do other companies really build these in 90 days? 37\u003c\/p\u003e \u003cp\u003eAnswer 37\u003c\/p\u003e \u003cp\u003eQuestion: How will we know we are doing this right? 38\u003c\/p\u003e \u003cp\u003eAnswer 38\u003c\/p\u003e \u003cp\u003eQuestion: Why didn’t this work last time? What is different this time? 39\u003c\/p\u003e \u003cp\u003eAnswer 39\u003c\/p\u003e \u003cp\u003eQuestion: Do we have the right technology in place? 39\u003c\/p\u003e \u003cp\u003eAnswer 40\u003c\/p\u003e \u003cp\u003eQuestion: Are we the only company with data warehouse problems? 40\u003c\/p\u003e \u003cp\u003eAnswer 41\u003c\/p\u003e \u003cp\u003eQuestion: Will I get one version of the truth? 41\u003c\/p\u003e \u003cp\u003eAnswer 42\u003c\/p\u003e \u003cp\u003eQuestion: Why can’t we just use our current systems? 43\u003c\/p\u003e \u003cp\u003eAnswer 44\u003c\/p\u003e \u003cp\u003eQuestion: Will the data warehouse replace our old systems? 45\u003c\/p\u003e \u003cp\u003eQuestion: Who needs to be involved? 45\u003c\/p\u003e \u003cp\u003eQuestion: Do we know where we are going? How will we know when we get there? 46\u003c\/p\u003e \u003cp\u003eAnswer 46\u003c\/p\u003e \u003cp\u003eQuestion: How do we get started and stay focused? 47\u003c\/p\u003e \u003cp\u003eAnswer 47\u003c\/p\u003e \u003cp\u003eSummary 48\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Two The Business Side of Data Warehousing 49\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 Understanding Where You Are and Finding Your Way 51\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAssessing Your Current State 51\u003c\/p\u003e \u003cp\u003eWhat Is Your Company’s Strategic Direction? 52\u003c\/p\u003e \u003cp\u003eWhat Are the Company’s Top Initiatives? 54\u003c\/p\u003e \u003cp\u003eHow Healthy Is Your Data? 55\u003c\/p\u003e \u003cp\u003eDoes the Business Place Value on Analysis? 56\u003c\/p\u003e \u003cp\u003eReflecting on Your Data Warehouse History 57\u003c\/p\u003e \u003cp\u003eUnderstanding Your Existing Reporting Environment 58\u003c\/p\u003e \u003cp\u003eFinding the Reporting Systems 59\u003c\/p\u003e \u003cp\u003eCompiling an Inventory 60\u003c\/p\u003e \u003cp\u003eIdentifying the Business Purpose 61\u003c\/p\u003e \u003cp\u003eDiscovering the Data You Already Have 63\u003c\/p\u003e \u003cp\u003eUnderstanding the People 65\u003c\/p\u003e \u003cp\u003eTracking Technology and Tools 65\u003c\/p\u003e \u003cp\u003eUnderstanding Enterprise Resources 66\u003c\/p\u003e \u003cp\u003eNetting It All Out 68\u003c\/p\u003e \u003cp\u003eIntroducing the Case Studies 70\u003c\/p\u003e \u003cp\u003eThe Call Center Data Warehouse Project 70\u003c\/p\u003e \u003cp\u003eIn Real Life 70\u003c\/p\u003e \u003cp\u003eGiant Company 71\u003c\/p\u003e \u003cp\u003eAgile, Inc. 72\u003c\/p\u003e \u003cp\u003eSummary 72\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 Successful IT–Business Partnerships 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat a Partnership Really Means 75\u003c\/p\u003e \u003cp\u003eWhat the Business Partners Should Expect to Do 76\u003c\/p\u003e \u003cp\u003eBusiness Executives and Senior Management 78\u003c\/p\u003e \u003cp\u003eThe Executive Business Sponsor 78\u003c\/p\u003e \u003cp\u003eBusiness Managers 81\u003c\/p\u003e \u003cp\u003eThe Business Champion 82\u003c\/p\u003e \u003cp\u003eBusiness Analysts 83\u003c\/p\u003e \u003cp\u003eHelping the Business Analyst Deal with Change 85\u003c\/p\u003e \u003cp\u003eBusiness User Audience 86\u003c\/p\u003e \u003cp\u003eProject Manager 86\u003c\/p\u003e \u003cp\u003eWhat You Should Expect from IT 88\u003c\/p\u003e \u003cp\u003eCIO\/IT Executive Sponsor 89\u003c\/p\u003e \u003cp\u003eData Warehouse Manager 89\u003c\/p\u003e \u003cp\u003eBusiness Systems Analyst 90\u003c\/p\u003e \u003cp\u003eSource System Analyst 91\u003c\/p\u003e \u003cp\u003eData Modeler\/Data Architect 92\u003c\/p\u003e \u003cp\u003eETL Developer(s) 93\u003c\/p\u003e \u003cp\u003eBusiness Intelligence Application Developer 94\u003c\/p\u003e \u003cp\u003eOther Supporting Roles 95\u003c\/p\u003e \u003cp\u003eTips for Building and Sustaining a Partnership 95\u003c\/p\u003e \u003cp\u003eLeveraging External Consulting 97\u003c\/p\u003e \u003cp\u003eBuilding Strong Project Teams 98\u003c\/p\u003e \u003cp\u003eEffective Communication 99\u003c\/p\u003e \u003cp\u003eNetting Out Key Messages 99\u003c\/p\u003e \u003cp\u003ePresenting in Business Terms 100\u003c\/p\u003e \u003cp\u003eMeeting Preparation 101\u003c\/p\u003e \u003cp\u003ePresentation Tips 102\u003c\/p\u003e \u003cp\u003eWhen to Communicate 103\u003c\/p\u003e \u003cp\u003ePartnerships Beyond a Project 104\u003c\/p\u003e \u003cp\u003eThe Decision-Making Process 104\u003c\/p\u003e \u003cp\u003eExecutive Steering Committee 104\u003c\/p\u003e \u003cp\u003eDW Business Support Team 106\u003c\/p\u003e \u003cp\u003eEnterprise Considerations 107\u003c\/p\u003e \u003cp\u003eIn Real Life 107\u003c\/p\u003e \u003cp\u003eA Glimpse into Giant, Co. 107\u003c\/p\u003e \u003cp\u003eInsight from Agile, Inc. 108\u003c\/p\u003e \u003cp\u003eSummary 109\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Setting Up a Successful Project 111\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining the Project 111\u003c\/p\u003e \u003cp\u003eSetting Up the Project Charter 112\u003c\/p\u003e \u003cp\u003eDocumenting Project Scope 117\u003c\/p\u003e \u003cp\u003eDeveloping a Statement of Work 117\u003c\/p\u003e \u003cp\u003eHow Much Will It Cost? 120\u003c\/p\u003e \u003cp\u003eProject Approval 122\u003c\/p\u003e \u003cp\u003eStarting the Project 122\u003c\/p\u003e \u003cp\u003eLaunching the Project 123\u003c\/p\u003e \u003cp\u003eManaging a Successful Project 124\u003c\/p\u003e \u003cp\u003eIssue Tracking 124\u003c\/p\u003e \u003cp\u003eUsing Project Change Control 125\u003c\/p\u003e \u003cp\u003eDiscussing Change in Business Terms 126\u003c\/p\u003e \u003cp\u003eManaging Expectations 128\u003c\/p\u003e \u003cp\u003eIn Real Life 129\u003c\/p\u003e \u003cp\u003eStructured Projects with Giant 129\u003c\/p\u003e \u003cp\u003eFreedom for Creativity at Agile, Inc. 130\u003c\/p\u003e \u003cp\u003eSummary 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Providing Business Requirements 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Requirements Are Needed? 134\u003c\/p\u003e \u003cp\u003ePeeling Back the Layers of Requirements Gathering 134\u003c\/p\u003e \u003cp\u003eWho Provides Input? 137\u003c\/p\u003e \u003cp\u003eWho Gathers the Requirements? 137\u003c\/p\u003e \u003cp\u003eProviding Business Requirements 138\u003c\/p\u003e \u003cp\u003eStrategic Requirements 138\u003c\/p\u003e \u003cp\u003eBroad Business Requirements 140\u003c\/p\u003e \u003cp\u003eBusiness Analyses 143\u003c\/p\u003e \u003cp\u003eBusiness Data Requirements 145\u003c\/p\u003e \u003cp\u003eSystems and Technical Requirements 147\u003c\/p\u003e \u003cp\u003eCommunicating What You Really Need 149\u003c\/p\u003e \u003cp\u003eWhat Else Would Help the Project Team? 150\u003c\/p\u003e \u003cp\u003eData Integration Challenges 151\u003c\/p\u003e \u003cp\u003eAssess Organizational Motivation 151\u003c\/p\u003e \u003cp\u003eComplete Picture of the Data 152\u003c\/p\u003e \u003cp\u003eWhat If No One Is Asking? 152\u003c\/p\u003e \u003cp\u003ePractical Techniques for Gathering Requirements 153\u003c\/p\u003e \u003cp\u003eInterview Session Characteristics 153\u003c\/p\u003e \u003cp\u003eIndividual Interviews 153\u003c\/p\u003e \u003cp\u003eGroup Interviews 153\u003c\/p\u003e \u003cp\u003eProject Team Participation 154\u003c\/p\u003e \u003cp\u003eInterview Tips 154\u003c\/p\u003e \u003cp\u003eWho Needs to Be Included? 155\u003c\/p\u003e \u003cp\u003eSetting a Good Example 156\u003c\/p\u003e \u003cp\u003ePreparing for Interview Sessions 157\u003c\/p\u003e \u003cp\u003eConducting the Interview Sessions 157\u003c\/p\u003e \u003cp\u003eCapturing Content: Notes vs. Tapes 157\u003c\/p\u003e \u003cp\u003eRunning the Interview 158\u003c\/p\u003e \u003cp\u003eConcluding the Interview 158\u003c\/p\u003e \u003cp\u003ePutting the Pieces Together 158\u003c\/p\u003e \u003cp\u003eIndividual Interview Documentation 159\u003c\/p\u003e \u003cp\u003eResponsibilities 159\u003c\/p\u003e \u003cp\u003eBusiness Themes 159\u003c\/p\u003e \u003cp\u003eBusiness Data 160\u003c\/p\u003e \u003cp\u003eConsolidated Requirements Documentation 161\u003c\/p\u003e \u003cp\u003eExecutive Summary 161\u003c\/p\u003e \u003cp\u003eConsolidated Business Themes 162\u003c\/p\u003e \u003cp\u003eCandidate Business Analyses 162\u003c\/p\u003e \u003cp\u003eConsolidated Business Data Requirements 162\u003c\/p\u003e \u003cp\u003eIdentification of Non-Data Warehouse Requirements 163\u003c\/p\u003e \u003cp\u003eCommon Requirements Gathering Challenges 163\u003c\/p\u003e \u003cp\u003eSifting Through Reports 163\u003c\/p\u003e \u003cp\u003eListing Data Elements 164\u003c\/p\u003e \u003cp\u003eDeveloping Functional Specifications 164\u003c\/p\u003e \u003cp\u003eMoving Beyond Immediate 164\u003c\/p\u003e \u003cp\u003eLack of Requirements 165\u003c\/p\u003e \u003cp\u003eThe Cynic 165\u003c\/p\u003e \u003cp\u003eSetting Attainable Goals 166\u003c\/p\u003e \u003cp\u003eExploring Alternatives 167\u003c\/p\u003e \u003cp\u003eSetting Priorities 168\u003c\/p\u003e \u003cp\u003eIn Real Life 170\u003c\/p\u003e \u003cp\u003eA Glimpse into Giant Company 170\u003c\/p\u003e \u003cp\u003eInsight from Agile, Inc. 170\u003c\/p\u003e \u003cp\u003eSummary 171\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Three Dealing with the Data 173\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Modeling the Data for your Business 175\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Purpose of Dimensional Models 176\u003c\/p\u003e \u003cp\u003eEase of Use 176\u003c\/p\u003e \u003cp\u003eQuery Performance 177\u003c\/p\u003e \u003cp\u003eUnderstanding Your Data 177\u003c\/p\u003e \u003cp\u003eWhat Is a Dimensional Model? 178\u003c\/p\u003e \u003cp\u003eDimensions 178\u003c\/p\u003e \u003cp\u003eFacts 180\u003c\/p\u003e \u003cp\u003eUsing Both Parts of the Model 180\u003c\/p\u003e \u003cp\u003eImplementing a Dimensional Model 181\u003c\/p\u003e \u003cp\u003eDiagramming Your Dimensional Model 182\u003c\/p\u003e \u003cp\u003eThe Business Dimensional Model 182\u003c\/p\u003e \u003cp\u003eBusiness Dimensions 183\u003c\/p\u003e \u003cp\u003eFact Groups 184\u003c\/p\u003e \u003cp\u003eA Call Center Case Study 186\u003c\/p\u003e \u003cp\u003eCall Center Dimensions 187\u003c\/p\u003e \u003cp\u003eDate Dimension 187\u003c\/p\u003e \u003cp\u003eTime Dimension 187\u003c\/p\u003e \u003cp\u003eCustomer Dimension 189\u003c\/p\u003e \u003cp\u003eEmployee Dimension 191\u003c\/p\u003e \u003cp\u003eCall Dimension 191\u003c\/p\u003e \u003cp\u003eCall Outcome Dimension 194\u003c\/p\u003e \u003cp\u003eEmployee Task Dimension 195\u003c\/p\u003e \u003cp\u003eCall Center Fact Groups 196\u003c\/p\u003e \u003cp\u003eCalls Fact Group 196\u003c\/p\u003e \u003cp\u003eCall Center Time Tracking Fact Group 196\u003c\/p\u003e \u003cp\u003eCall Forecast Fact Group 198\u003c\/p\u003e \u003cp\u003eWorking with the Model 199\u003c\/p\u003e \u003cp\u003eBusiness Dimensional Model Index 200\u003c\/p\u003e \u003cp\u003eEnterprise Considerations 200\u003c\/p\u003e \u003cp\u003eConformed Dimensions 200\u003c\/p\u003e \u003cp\u003eConformed Facts 202\u003c\/p\u003e \u003cp\u003ePractical Guidelines 202\u003c\/p\u003e \u003cp\u003eGuidelines for a Single Dimension 202\u003c\/p\u003e \u003cp\u003eGuidelines for a Single Fact Group 203\u003c\/p\u003e \u003cp\u003eCharacteristics of the Model across the Enterprise 204\u003c\/p\u003e \u003cp\u003eBusiness Participation in the Modeling Process 205\u003c\/p\u003e \u003cp\u003eCreating the First Draft 205\u003c\/p\u003e \u003cp\u003ePreparing for Modeling Sessions 205\u003c\/p\u003e \u003cp\u003eBrainstorming the Framework 206\u003c\/p\u003e \u003cp\u003eDrafting the Initial Dimensions 206\u003c\/p\u003e \u003cp\u003eDrafting the Initial Fact Groups 207\u003c\/p\u003e \u003cp\u003eDocumenting the Model 208\u003c\/p\u003e \u003cp\u003eLogging Questions and Issues 208\u003c\/p\u003e \u003cp\u003eBuilding the Business Measures Worksheet 209\u003c\/p\u003e \u003cp\u003ePreliminary Source to Target Data Map 211\u003c\/p\u003e \u003cp\u003eCompleting or Fleshing Out the Model 211\u003c\/p\u003e \u003cp\u003eWorking Through the Issues 211\u003c\/p\u003e \u003cp\u003eCompleting the Documentation 212\u003c\/p\u003e \u003cp\u003eWorking Through All the Data Elements 212\u003c\/p\u003e \u003cp\u003eRefining the Model 213\u003c\/p\u003e \u003cp\u003eBusiness Reviews of the Model 213\u003c\/p\u003e \u003cp\u003eSmall Business Reviews 214\u003c\/p\u003e \u003cp\u003eWhen Are You Done? 214\u003c\/p\u003e \u003cp\u003eGaining Final Commitment 215\u003c\/p\u003e \u003cp\u003eExpanding Business Data Over Time 215\u003c\/p\u003e \u003cp\u003eEnhancing Dimensions 215\u003c\/p\u003e \u003cp\u003eAdding More Fact Groups 215\u003c\/p\u003e \u003cp\u003eReflecting on Business Realities: Advanced Concepts 216\u003c\/p\u003e \u003cp\u003eSupporting Multiple Perspectives: Multiple Hierarchies 216\u003c\/p\u003e \u003cp\u003eTracking Changes in the Dimension: Slowly Changing Dimensions 216\u003c\/p\u003e \u003cp\u003eDepicting the Existence of a Relationship: Factless Fact Tables 218\u003c\/p\u003e \u003cp\u003eLinking Parts of a Transaction: Degenerate Dimensions 219\u003c\/p\u003e \u003cp\u003ePulling Together Components: Junk Dimensions 221\u003c\/p\u003e \u003cp\u003eMultiple Instances of a Dimension: Role Playing 222\u003c\/p\u003e \u003cp\u003eOther Notation 224\u003c\/p\u003e \u003cp\u003eDimension Connectors 224\u003c\/p\u003e \u003cp\u003eClusters of Future Attributes 225\u003c\/p\u003e \u003cp\u003eNotation Summary 225\u003c\/p\u003e \u003cp\u003eTaking the Model Forward 225\u003c\/p\u003e \u003cp\u003eTranslating the Business Dimensional Model 226\u003c\/p\u003e \u003cp\u003eDimension Table Design 226\u003c\/p\u003e \u003cp\u003eTranslating Fact Groups 227\u003c\/p\u003e \u003cp\u003ePhysical Database Design 228\u003c\/p\u003e \u003cp\u003eIn Real Life 228\u003c\/p\u003e \u003cp\u003eA Glimpse into Giant Co. 229\u003c\/p\u003e \u003cp\u003eInsight from Agile, Inc. 229\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 Managing Data As a Corporate Asset 231\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Information Management? 232\u003c\/p\u003e \u003cp\u003eInformation Management Example—Customer Data 235\u003c\/p\u003e \u003cp\u003eIM Beyond the Data Warehouse 239\u003c\/p\u003e \u003cp\u003eMaster Data Management 240\u003c\/p\u003e \u003cp\u003eMaster Data Feeds the Data Warehouse 242\u003c\/p\u003e \u003cp\u003eFinding the Right Resources 242\u003c\/p\u003e \u003cp\u003eData Governance 243\u003c\/p\u003e \u003cp\u003eData Ownership 243\u003c\/p\u003e \u003cp\u003eWho Really Owns the Data? 244\u003c\/p\u003e \u003cp\u003eYour Responsibilities If You Are ‘‘the Owner’’ 246\u003c\/p\u003e \u003cp\u003eWhat are IT’s Responsibilities? 247\u003c\/p\u003e \u003cp\u003eChallenges with Data Ownership 247\u003c\/p\u003e \u003cp\u003eData Quality 248\u003c\/p\u003e \u003cp\u003eProfiling the Data 249\u003c\/p\u003e \u003cp\u003eHow Clean Does the Data Really Need to Be? 250\u003c\/p\u003e \u003cp\u003eMeasuring Quality 250\u003c\/p\u003e \u003cp\u003eQuality of Historical Data 251\u003c\/p\u003e \u003cp\u003eCleansing at the Source 253\u003c\/p\u003e \u003cp\u003eCleaning Up for Reporting 254\u003c\/p\u003e \u003cp\u003eManaging the Integrity of Data Integration 254\u003c\/p\u003e \u003cp\u003eQuality Improves When It Matters 256\u003c\/p\u003e \u003cp\u003eExample: Data Quality and Grocery Checkout Scanners 257\u003c\/p\u003e \u003cp\u003eExample: Data Quality and the Evaluation of Public Education 257\u003c\/p\u003e \u003cp\u003eRealizing the Value of Data Quality 258\u003c\/p\u003e \u003cp\u003eImplementing a Data Dictionary 259\u003c\/p\u003e \u003cp\u003eThe Data Dictionary Application 259\u003c\/p\u003e \u003cp\u003ePopulating the Data Dictionary 261\u003c\/p\u003e \u003cp\u003eAccessing the Data Dictionary 263\u003c\/p\u003e \u003cp\u003eMaintaining the Data Dictionary 263\u003c\/p\u003e \u003cp\u003eGetting Started with Information Management 264\u003c\/p\u003e \u003cp\u003eUnderstanding Your Current Data Environment 264\u003c\/p\u003e \u003cp\u003eWhat Data Do You Have? 265\u003c\/p\u003e \u003cp\u003eWhat Already Exists? 266\u003c\/p\u003e \u003cp\u003eWhere Do You Want to Be? 267\u003c\/p\u003e \u003cp\u003eDevelop a Realistic Strategy 268\u003c\/p\u003e \u003cp\u003eSharing the Information Management Strategy 269\u003c\/p\u003e \u003cp\u003eSetting Up a Sustainable Process 270\u003c\/p\u003e \u003cp\u003eEnterprise Commitment 270\u003c\/p\u003e \u003cp\u003eThe Data Governance Committee 270\u003c\/p\u003e \u003cp\u003eRevising the Strategy 271\u003c\/p\u003e \u003cp\u003eIn Real Life 271\u003c\/p\u003e \u003cp\u003eA Glimpse into Giant, Co. 272\u003c\/p\u003e \u003cp\u003eInsight from Agile, Inc. 272\u003c\/p\u003e \u003cp\u003eSummary 274\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Four Building the Project 275\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Architecture, Infrastructure, and Tools 277\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Architecture? 278\u003c\/p\u003e \u003cp\u003eWhy Do We Need Architecture? 278\u003c\/p\u003e \u003cp\u003eMaking Architecture Work 281\u003c\/p\u003e \u003cp\u003eData Architecture 282\u003c\/p\u003e \u003cp\u003eRevisiting DW Goals 283\u003c\/p\u003e \u003cp\u003eComponents of DW Data Architecture 285\u003c\/p\u003e \u003cp\u003eA Closer Look at Common Data Warehouse Architectures 286\u003c\/p\u003e \u003cp\u003eBottom-Up Data Architecture 286\u003c\/p\u003e \u003cp\u003eTop-Down Data Architecture 290\u003c\/p\u003e \u003cp\u003ePublish the Data: Data Marts 294\u003c\/p\u003e \u003cp\u003eAdopting an Architecture 295\u003c\/p\u003e \u003cp\u003eTechnical Architecture 297\u003c\/p\u003e \u003cp\u003eTechnical Architecture Basics 298\u003c\/p\u003e \u003cp\u003eComponents of Technical Architecture 299\u003c\/p\u003e \u003cp\u003eInfrastructure 300\u003c\/p\u003e \u003cp\u003eTechnical Architecture in Action 300\u003c\/p\u003e \u003cp\u003eWhat You Need to Know about Technical Architecture 301\u003c\/p\u003e \u003cp\u003eNavigating the Technology Jungle 302\u003c\/p\u003e \u003cp\u003eWeighing Technology Options 303\u003c\/p\u003e \u003cp\u003eBest of Breed 303\u003c\/p\u003e \u003cp\u003eEnd-to-End Solutions 303\u003c\/p\u003e \u003cp\u003eDeciding Not to Buy a Tool 304\u003c\/p\u003e \u003cp\u003eFinding the Right Products 304\u003c\/p\u003e \u003cp\u003eRequests for Information or Proposals 305\u003c\/p\u003e \u003cp\u003eBusiness Participation in the Selection Process 305\u003c\/p\u003e \u003cp\u003eUnderstanding Product Genealogy 306\u003c\/p\u003e \u003cp\u003eUnderstanding Value and Evaluating Your Options 306\u003c\/p\u003e \u003cp\u003eCutting through the Marketing Hype 308\u003c\/p\u003e \u003cp\u003eThe Value of References 309\u003c\/p\u003e \u003cp\u003eMaking Architecture Work for You 310\u003c\/p\u003e \u003cp\u003eJust-In-Time Architecture 311\u003c\/p\u003e \u003cp\u003eIn Real Life 311\u003c\/p\u003e \u003cp\u003eArchitecture at Giant 311\u003c\/p\u003e \u003cp\u003eAgile Ignores the Need for Architecture 312\u003c\/p\u003e \u003cp\u003eSummary 313\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Implementation: Building the Database 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExtract, Transform, and Load (ETL) Fundamentals 315\u003c\/p\u003e \u003cp\u003eWhat Work Is Being Done? 315\u003c\/p\u003e \u003cp\u003eETL System Functionality 317\u003c\/p\u003e \u003cp\u003eExtraction 318\u003c\/p\u003e \u003cp\u003eTransformation 318\u003c\/p\u003e \u003cp\u003eLoad 322\u003c\/p\u003e \u003cp\u003eThe Business Role in ETL 323\u003c\/p\u003e \u003cp\u003eWhy Does the Business Need to Help? 323\u003c\/p\u003e \u003cp\u003eDefining Business Rules 324\u003c\/p\u003e \u003cp\u003eDefining Expected Results—The Test Plan 325\u003c\/p\u003e \u003cp\u003eDevelopment Support 326\u003c\/p\u003e \u003cp\u003eTesting the ETL System—Is the data Right? 326\u003c\/p\u003e \u003cp\u003eWhy Does It Take So Long and Cost So Much? 327\u003c\/p\u003e \u003cp\u003eBalancing Requirements and Data Reality 329\u003c\/p\u003e \u003cp\u003eDiscovering the Flaws in Your Current Systems 330\u003c\/p\u003e \u003cp\u003eApplying New Business Rules 331\u003c\/p\u003e \u003cp\u003eWorking Toward Long-Term Solutions 332\u003c\/p\u003e \u003cp\u003eManually Including Business Data 333\u003c\/p\u003e \u003cp\u003eTracking Progress—Are We There Yet? 333\u003c\/p\u003e \u003cp\u003eWhat Else Can You Do to Help? 334\u003c\/p\u003e \u003cp\u003eEncouragement and Support 334\u003c\/p\u003e \u003cp\u003eEnsuring Continued Business Participation 335\u003c\/p\u003e \u003cp\u003eProactive Communication 336\u003c\/p\u003e \u003cp\u003eIn Real Life 337\u003c\/p\u003e \u003cp\u003eBuilding the Data Warehouse at Giant, Co. 337\u003c\/p\u003e \u003cp\u003eAgile, Inc., Builds a Data Warehouse Quickly 338\u003c\/p\u003e \u003cp\u003eSummary 339\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 Data Delivery: What you Finally See 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat Is Business Intelligence? 341\u003c\/p\u003e \u003cp\u003eBusiness Intelligence without a DW 342\u003c\/p\u003e \u003cp\u003eBI in Action 343\u003c\/p\u003e \u003cp\u003eTabular Reports 343\u003c\/p\u003e \u003cp\u003eParameter-Driven Reports 343\u003c\/p\u003e \u003cp\u003eInteractive Reports—Drilling Down and Across 344\u003c\/p\u003e \u003cp\u003eException Reports 344\u003c\/p\u003e \u003cp\u003eOther BI Capabilities 345\u003c\/p\u003e \u003cp\u003eComplex Analysis 345\u003c\/p\u003e \u003cp\u003eBI Building Blocks 346\u003c\/p\u003e \u003cp\u003eData Content—Understanding What You Have 346\u003c\/p\u003e \u003cp\u003eNavigation—Finding What You Need 347\u003c\/p\u003e \u003cp\u003ePresentation—How Do You Want to See Results? 347\u003c\/p\u003e \u003cp\u003eDelivery—How Do You Receive the Results? 351\u003c\/p\u003e \u003cp\u003eSupporting Different Levels of Use 352\u003c\/p\u003e \u003cp\u003eConstruction of the BI Solution 354\u003c\/p\u003e \u003cp\u003ePlanning for Business Change 354\u003c\/p\u003e \u003cp\u003eDesign—What Needs to Be Delivered? 355\u003c\/p\u003e \u003cp\u003eDevelopment 357\u003c\/p\u003e \u003cp\u003eTesting BI Applications and Validating Data 358\u003c\/p\u003e \u003cp\u003eAdditional Responsibilities 359\u003c\/p\u003e \u003cp\u003eSecurity—Who Can Look at the Data? 359\u003c\/p\u003e \u003cp\u003eSystem Controls—Who Can Change What? 360\u003c\/p\u003e \u003cp\u003ePlanning a Successful Launch 361\u003c\/p\u003e \u003cp\u003eMarketing the Solution 361\u003c\/p\u003e \u003cp\u003eLearning to Use the Data without a Technical Degree 362\u003c\/p\u003e \u003cp\u003eLearning about the Data 362\u003c\/p\u003e \u003cp\u003eLearning about the BI Tool\/Application 362\u003c\/p\u003e \u003cp\u003eEnsuring That the Right Help Is Available 363\u003c\/p\u003e \u003cp\u003eIn Real Life 364\u003c\/p\u003e \u003cp\u003eBI at Giant Company 364\u003c\/p\u003e \u003cp\u003eAgile, Inc. Dives into BI 365\u003c\/p\u003e \u003cp\u003eSummary 366\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart Five Next Steps—Expanding On Success 367\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 Managing the Production Data Warehouse 369\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFinishing the Project 369\u003c\/p\u003e \u003cp\u003eRecapping the BI Application Launch 369\u003c\/p\u003e \u003cp\u003ePost-Implementation Review 370\u003c\/p\u003e \u003cp\u003eLooking Back—Did you Accomplish Your Objectives? 371\u003c\/p\u003e \u003cp\u003eAdopting the Solution 371\u003c\/p\u003e \u003cp\u003eTracking Data Warehouse Use 372\u003c\/p\u003e \u003cp\u003eGetting the Rest of the Business Community on Board 372\u003c\/p\u003e \u003cp\u003eBusiness Process Change 374\u003c\/p\u003e \u003cp\u003eChanging How Data Is Used 374\u003c\/p\u003e \u003cp\u003eStreamlining Business Processes 374\u003c\/p\u003e \u003cp\u003eEncouraging Change 375\u003c\/p\u003e \u003cp\u003eThe Production Data Warehouse 375\u003c\/p\u003e \u003cp\u003eStaffing Production Activities 376\u003c\/p\u003e \u003cp\u003eMaintaining the Environment 376\u003c\/p\u003e \u003cp\u003eKeeping Up with Technology 376\u003c\/p\u003e \u003cp\u003eMonitoring Performance and Capacity Planning 378\u003c\/p\u003e \u003cp\u003eMaintaining the Data Warehouse 380\u003c\/p\u003e \u003cp\u003eMaintaining the ETL System 380\u003c\/p\u003e \u003cp\u003eMaintaining the BI Application 381\u003c\/p\u003e \u003cp\u003eTracking Questions and Problems 382\u003c\/p\u003e \u003cp\u003eFixing Bugs 384\u003c\/p\u003e \u003cp\u003eWhen the Data Warehouse Falls Short 384\u003c\/p\u003e \u003cp\u003eCommon Causes for a Stalled Warehouse 385\u003c\/p\u003e \u003cp\u003eJump-Starting a Stalled Data Warehouse 388\u003c\/p\u003e \u003cp\u003eConducting an Assessment 388\u003c\/p\u003e \u003cp\u003eDetermining What Can Be Salvaged 389\u003c\/p\u003e \u003cp\u003eDeveloping a Plan to Move On 390\u003c\/p\u003e \u003cp\u003eAligning DW Objectives with Business Goals 391\u003c\/p\u003e \u003cp\u003eGetting It Right This Time 392\u003c\/p\u003e \u003cp\u003eLaunching the Improved Data Warehouse and BI Solution 393\u003c\/p\u003e \u003cp\u003eIn Real Life 394\u003c\/p\u003e \u003cp\u003eLack of Support for the Production DW at Giant Co. 394\u003c\/p\u003e \u003cp\u003eUnleashing BI at Agile, Inc. 395\u003c\/p\u003e \u003cp\u003eSummary 396\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Achieving Long-Term Success 397\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003ePlanning for Expansion and Growth 397\u003c\/p\u003e \u003cp\u003eExploring Expansion Opportunities 398\u003c\/p\u003e \u003cp\u003ePrioritization of Feedback 399\u003c\/p\u003e \u003cp\u003eManaging Enterprise DW Resources 400\u003c\/p\u003e \u003cp\u003eCreating an Enterprise Data Warehouse Team 400\u003c\/p\u003e \u003cp\u003eThe Centralized Enterprise Data Warehouse Team 401\u003c\/p\u003e \u003cp\u003eThe Virtual Enterprise Data Warehouse Team 401\u003c\/p\u003e \u003cp\u003eEnterprise DW Team Responsibilities 403\u003c\/p\u003e \u003cp\u003eFunding the Enterprise DW Team 404\u003c\/p\u003e \u003cp\u003ePushing into the Future 405\u003c\/p\u003e \u003cp\u003eEmbedded Business Intelligence 405\u003c\/p\u003e \u003cp\u003eOperational Business Intelligence 406\u003c\/p\u003e \u003cp\u003eReal-Time Data Warehousing 407\u003c\/p\u003e \u003cp\u003eUnstructured Data 408\u003c\/p\u003e \u003cp\u003eMonitoring Industry Innovation 409\u003c\/p\u003e \u003cp\u003eMoving Toward Business Value 410\u003c\/p\u003e \u003cp\u003eMeasuring Success One Step at a Time 410\u003c\/p\u003e \u003cp\u003eAdjusting Expectations to Reality 412\u003c\/p\u003e \u003cp\u003eKeeping the Momentum Going 413\u003c\/p\u003e \u003cp\u003eCelebrating Progress 416\u003c\/p\u003e \u003cp\u003eSuccess Can Be Attained 417\u003c\/p\u003e \u003cp\u003eConclusion 419\u003c\/p\u003e \u003cp\u003eGlossary 421\u003c\/p\u003e \u003cp\u003eIndex 429\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":53515415028055,"sku":"9780470176382","price":45.12,"currency_code":"GBP","in_stock":true}],"url":"https:\/\/bookcurl.com\/products\/a-managers-guide-to-data-warehousing-9780470176382","provider":"Book Curl","version":"1.0","type":"link"}