Details

<p>Introduction 1</p> <p><b>Part I: The Data Warehouse: Home for Your Data Assets 7</b></p> <p>Chapter 1: What’s in a Data Warehouse? 9</p> <p>Chapter 2: What Should You Expect from Your Data Warehouse? 25</p> <p>Chapter 3: Have It Your Way: The Structure of a Data Warehouse 37</p> <p>Chapter 4: Data Marts: Your Retail Data Outlet 59</p> <p><b>Part II: Data Warehousing Technology 71</b></p> <p>Chapter 5: Relational Databases and Data Warehousing 73</p> <p>Chapter 6: Specialty Databases and Data Warehousing 85</p> <p>Chapter 7: Stuck in the Middle with You: Data Warehousing Middleware 95</p> <p><b>Part III: Business Intelligence and Data Warehousing 113</b></p> <p>Chapter 8: An Intelligent Look at Business Intelligence 115</p> <p>Chapter 9: Simple Database Querying and Reporting 125</p> <p>Chapter 10: Business Analysis (OLAP) 135</p> <p>Chapter 11: Data Mining: Hi-Ho, Hi-Ho, It’s Off to Mine We Go 149</p> <p>Chapter 12: Dashboards and Scorecards 155</p> <p><b>Part IV: Data Warehousing Projects: How to Do Them Right 163</b></p> <p>Chapter 13: Data Warehousing and Other IT Projects: The Same but Different 165</p> <p>Chapter 14: Building a Winning Data Warehousing Project Team 179</p> <p>Chapter 15: You Need What? When? — Capturing Requirements 193</p> <p>Chapter 16: Analyzing Data Sources 203</p> <p>Chapter 17: Delivering the Goods 213</p> <p>Chapter 18: User Testing, Feedback, and Acceptance 225</p> <p><b>Part V: Data Warehousing: The Big Picture 231</b></p> <p>Chapter 19: The Information Value Chain: Connecting Internal and External Data 233</p> <p>Chapter 20: Data Warehousing Driving Quality and Integration 247</p> <p>Chapter 21: The View from the Executive Boardroom 263</p> <p>Chapter 22: Existing Sort-of Data Warehouses: Upgrade or Replace? 271</p> <p>Chapter 23: Surviving in the Computer Industry (and Handling Vendors) 281</p> <p>Chapter 24: Working with Data Warehousing Consultants 291</p> <p><b>Part VI: Data Warehousing in the Not-Too-Distant Future 297</b></p> <p>Chapter 25: Expanding Your Data Warehouse with Unstructured Data 299</p> <p>Chapter 26: Agreeing to Disagree about Semantics 305</p> <p>Chapter 27: Collaborative Business Intelligence 311</p> <p><b>Part VII: The Part of Tens 317</b></p> <p>Chapter 28: Ten Questions to Consider When You’re Selecting User Tools 319</p> <p>Chapter 29: Ten Secrets to Managing Your Project Successfully 325</p> <p>Chapter 30: Ten Sources of Up-to-Date Information about Data Warehousing 331</p> <p>Chapter 31: Ten Mandatory Skills for a Data Warehousing Consultant 335</p> <p>Chapter 32: Ten Signs of a Data Warehousing Project in Trouble 339</p> <p>Chapter 33: Ten Signs of a Successful Data Warehousing Project 343</p> <p>Chapter 34: Ten Subject Areas to Cover with Product Vendors 347</p> <p>Index 351</p>

<p><b>Thomas C. Hammergren</b> has been involved with business intelligence and data warehousing since the 1980s. He has helped such companies as Procter & Gamble, Nike, FirstEnergy, Duke Energy, AT&T, and Equifax build business intelligence and performance management strategies, competencies, and solutions. <b>Alan R. Simon</b> is a data warehousing expert and author of many books on data warehousing.

<p><b><i>Learn to:</i></b> <ul> <li>Analyze top-down and bottom-up data warehouse designs</li> <li>Understand the structure and technologies of data warehouses, operational data stores, and data marts</li> <li>Implement a data warehouse, step by step</li> <li>Involve end-users in the process</li> </ul> <p><b>There's more to data warehousing than you think, so start right here!</b> <p>You don't need a forklift to work with a data warehouse, but you do need a hefty load of know-how to make wise decisions when setting one up. Data is probably your company's most important asset, so your data warehouse should serve your needs. Here's how to understand, develop, implement, and use data warehouses, plus a sneak peek into their future. <ul> <li><b>Know your stuff</b> — understand what a data warehouse is, what should be housed there, and what data assets are</li> <li><b>Get a handle on technology</b> — learn about column-wise databases, hardware assisted databases, middleware, and master data management</li> <li><b>The intelligent view</b> — see how business intelligence and data warehousing work together</li> <li><b>Ask the right questions</b> — explore data mining and learn to find what you need</li> <li><b>Do the groundwork</b> — choose your project team and apply best development practices to your data warehousing projects</li> <li><b>Keep the user in mind</b> — involve your users in defining business needs through testing, and learn how to get valuable feedback</li> <li><b>Fix or replace?</b> — learn how to review and upgrade existing data storage to make it serve your needs</li> <li><b>Buyer beware</b> — be prepared when dealing with data warehousing product vendors</li> </ul> <p><b>Open the book and find:</b> <ul> <li>What to expect from your data warehouse</li> <li>The difference between data warehouses and data marts</li> <li>All about specialty database technologies</li> <li>What to look for in a consultant</li> <li>How your data warehouse feeds dashboards and scorecards</li> <li>Secrets for managing a successful data warehouse project</li> <li>How to effectively capture business needs and requirements</li> <li>Ten signs your project is in trouble</li> </ul>

US