Synopses & Reviews
There's more to data warehousing than you think, so start right here!
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.
Know your stuff — understand what a data warehouse is, what should be housed there, and what data assets are
Get a handle on technology — learn about column-wise databases, hardware assisted databases, middleware, and master data management
The intelligent view — see how business intelligence and data warehousing work together
Ask the right questions — explore data mining and learn to find what you need
Do the groundwork — choose your project team and apply best development practices to your data warehousing projects
Keep the user in mind — involve your users in defining business needs through testing, and learn how to get valuable feedback
Fix or replace? — learn how to review and upgrade existing data storage to make it serve your needs
Buyer beware — be prepared when dealing with data warehousing product vendors
Open the book and find:
What to expect from your data warehouse
The difference between data warehouses and data marts
All about specialty database technologies
What to look for in a consultant
How your data warehouse feeds dashboards and scorecards
Secrets for managing a successful data warehouse project
How to effectively capture business needs and requirements
Ten signs your project is in trouble
Data Warehousing For Dummies,2nd Edition provides need-to-know information about the structure, interrelationships, and technologies of data warehouses, operational data stores, and data marts, including strengths and weaknesses of the top-down and bottom-up data warehousing approaches and capturing metadata for master data management. This book shows how data warehouses interact with tools for data visualization, online analytical processing (OLAP), data mining, and business intelligence. Finally, the book takes you through the process of implementing a data warehouse step-by-step, from understanding the process to defining and preparing for important decision points such as building the team, capturing requirements, analyzing data stores, and involving end users in the process.
- Making data warehousing understandable to readers, this revised edition provides need-to-know information about the structure, interrelationships, and technologies of data warehouses
- Reviews the strengths and weaknesses of the top-down and bottom-up data warehousing approaches, and methods for capturing metadata for master data management
- Offers a clear--and even irreverent--explanation of how data warehouses interact with tools for data visualization, online analytical processing, data mining, and business intelligence
- Walks readers step by step through the process of building a team, capturing requirements, analyzing data stores, and involving end users in the process
Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition.
Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to:
- Analyze top-down and bottom-up data warehouse designs
- Understand the structure and technologies of data warehouses, operational data stores, and data marts
- Choose your project team and apply best development practices to your data warehousing projects
- Implement a data warehouse, step by step, and involve end-users in the process
- Review and upgrade existing data storage to make it serve your needs
- Comprehend OLAP, column-wise databases, hardware assisted databases, and middleware
- Use data mining intelligently and find what you need
- Make informed choices about consultants and data warehousing products
Data Warehousing For Dummies, 2nd Edition also shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track. You’ll find it’s the most useful source of data on the topic!
About the Author
Thomas C. Hammergren 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. Alan R. Simon is a data warehousing expert and author of many books on data warehousing.
Table of Contents
Part I: The Data Warehouse: Home for Your Data Assets.
Chapter 1: What’s in a Data Warehouse?
Chapter 2: What Should You Expect from Your Data Warehouse?
Chapter 3: Have It Your Way: The Structure of a Data Warehouse.
Chapter 4: Data Marts: Your Retail Data Outlet.
Part II: Data Warehousing Technology.
Chapter 5: Relational Databases and Data Warehousing.
Chapter 6: Specialty Databases and Data Warehousing.
Chapter 7: Stuck in the Middle with You: Data Warehousing Middleware.
Part III: Business Intelligence and Data Warehousing.
Chapter 8: An Intelligent Look at Business Intelligence.
Chapter 9: Simple Database Querying and Reporting.
Chapter 10: Business Analysis (OLAP).
Chapter 11: Data Mining: Hi-Ho, Hi-Ho, It’s Off to Mine We Go.
Chapter 12: Dashboards and Scorecards.
Part IV: Data Warehousing Projects: How to Do Them Right.
Chapter 13: Data Warehousing and Other IT Projects: The Same but Different.
Chapter 14: Building a Winning Data Warehousing Project Team.
Chapter 15: You Need What? When? — Capturing Requirements.
Chapter 16: Analyzing Data Sources.
Chapter 17: Delivering the Goods.
Chapter 18: User Testing, Feedback, and Acceptance.
Part V: Data Warehousing: The Big Picture.
Chapter 19: The Information Value Chain: Connecting Internal and External Data.
Chapter 20: Data Warehousing Driving Quality and Integration.
Chapter 21: The View from the Executive Boardroom.
Chapter 22: Existing Sort-of Data Warehouses: Upgrade or Replace?
Chapter 23: Surviving in the Computer Industry (and Handling Vendors).
Chapter 24: Working with Data Warehousing Consultants.
Part VI: Data Warehousing in the Not-Too-Distant Future.
Chapter 25: Expanding Your Data Warehouse with Unstructured Data.
Chapter 26: Agreeing to Disagree about Semantics.
Chapter 27: Collaborative Business Intelligence.
Part VII: The Part of Tens.
Chapter 28: Ten Questions to Consider When You’re Selecting User Tools.
Chapter 29: Ten Secrets to Managing Your Project Successfully.
Chapter 30: Ten Sources of Up-to-Date Information about Data Warehousing.
Chapter 31: Ten Mandatory Skills for a Data Warehousing Consultant.
Chapter 32: Ten Signs of a Data Warehousing Project in Trouble.
Chapter 33: Ten Signs of a Successful Data Warehousing Project.
Chapter 34: Ten Subject Areas to Cover with Product Vendors.