Book description
Aimed 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.
Table of contents
- Copyright
- About the Author
- Credits
- Acknowledgments
- Introduction
-
I. The Essentials of Data Warehousing
-
1. Gaining Data Warehouse Success
- 1.1. The Essentials of Data Warehousing
-
1.2. The Promises of Data Warehousing
-
1.2.1. Keys to Success
- 1.2.1.1. Developing and Maintaining Strong Business and Technology Partnerships
- 1.2.1.2. Identifying True Business Requirements
- 1.2.1.3. Shifting to a Global Perspective
- 1.2.1.4. Overcoming Unrealistic Expectations
- 1.2.1.5. Providing Clear Communication
- 1.2.1.6. Treating Data As a Corporate Asset
- 1.2.1.7. Effectively Leveraging Technology
-
1.2.2. Roadblocks to Success
- 1.2.2.1. Believing the Myth: "If You Build It, They Will Come"
- 1.2.2.2. Falling into the Project Deadline Trap
- 1.2.2.3. Failing to Uphold Organizational Discipline
- 1.2.2.4. Lacking Business Process Change
- 1.2.2.5. Narrowing the Focus Too Much
- 1.2.2.6. Resting on Your Laurels
- 1.2.2.7. Relying on the Technology Fix
- 1.2.2.8. Getting the Right People Involved
- 1.2.2.9. Finding Lost Institutional Knowledge
-
1.2.1. Keys to Success
- 1.3. Summary
-
2. The Executive's FAQ for Data Warehousing
- 2.1. Question: What is the business benefit of a data warehouse?
- 2.2. Question: How much will it cost?
- 2.3. Question: How long will it take?
- 2.4. Question: How can I ensure success?
- 2.5. Question: Do other companies really build these in 90 days?
- 2.6. Question: How will we know we are doing this right?
- 2.7. Question: Why didn't this work last time? What is different this time?
- 2.8. Question: Do we have the right technology in place?
- 2.9. Question: Are we the only company with data warehouse problems?
- 2.10. Question: Will I get one version of the truth?
- 2.11. Question: Why can't we just use our current systems?
- 2.12. Question: Will the data warehouse replace our old systems?
- 2.13. Question: Who needs to be involved?
- 2.14. Question: Do we know where we are going? How will we know when we get there?
- 2.15. Question: How do we get started and stay focused?
- 2.16. Summary
-
1. Gaining Data Warehouse Success
-
II. The Business Side of Data Warehousing
- 3. Understanding Where You Are and Finding Your Way
- 4. Successful IT–Business Partnerships
- 5. Setting Up a Successful Project
-
6. Providing Business Requirements
- 6.1. What Requirements Are Needed?
- 6.2. Providing Business Requirements
- 6.3. Communicating What You Really Need
- 6.4. Practical Techniques for Gathering Requirements
- 6.5. Putting the Pieces Together
- 6.6. Setting Attainable Goals
- 6.7. In Real Life
- 6.8. Summary
-
III. Dealing with the Data
-
7. Modeling the Data for your Business
- 7.1. The Purpose of Dimensional Models
- 7.2. Understanding Your Data
- 7.3. What Is a Dimensional Model?
- 7.4. The Business Dimensional Model
- 7.5. A Call Center Case Study
- 7.6. Enterprise Considerations
- 7.7. Business Participation in the Modeling Process
-
7.8. Reflecting on Business Realities: Advanced Concepts
- 7.8.1. Supporting Multiple Perspectives: Multiple Hierarchies
- 7.8.2. Tracking Changes in the Dimension: Slowly Changing Dimensions
- 7.8.3. Depicting the Existence of a Relationship: Factless Fact Tables
- 7.8.4. Linking Parts of a Transaction: Degenerate Dimensions
- 7.8.5. Pulling Together Components: Junk Dimensions
- 7.8.6. Multiple Instances of a Dimension: Role Playing
- 7.8.7. Other Notation
- 7.9. Taking the Model Forward
- 7.10. In Real Life
- 7.11. Summary
-
8. Managing Data As a Corporate Asset
- 8.1. What Is Information Management?
- 8.2. Master Data Management
-
8.3. Data Governance
- 8.3.1. Data Ownership
-
8.3.2. Data Quality
- 8.3.2.1. Profiling the Data
- 8.3.2.2. How Clean Does the Data Really Need to Be?
- 8.3.2.3. Measuring Quality
- 8.3.2.4. Quality of Historical Data
- 8.3.2.5. Cleansing at the Source
- 8.3.2.6. Cleaning Up for Reporting
- 8.3.2.7. Managing the Integrity of Data Integration
- 8.3.2.8. Quality Improves When It Matters
- 8.3.2.9. Example: Data Quality and Grocery Checkout Scanners
- 8.3.2.10. Example: Data Quality and the Evaluation of Public Education
- 8.3.2.11. Realizing the Value of Data Quality
- 8.4. Implementing a Data Dictionary
- 8.5. Getting Started with Information Management
- 8.6. In Real Life
- 8.7. Summary
-
7. Modeling the Data for your Business
-
IV. Building the Project
-
9. Architecture, Infrastructure, and Tools
- 9.1. What Is Architecture?
- 9.2. Why Do We Need Architecture?
- 9.3. Data Architecture
- 9.4. Technical Architecture
- 9.5. Navigating the Technology Jungle
- 9.6. Making Architecture Work for You
- 9.7. In Real Life
- 9.8. Summary
- 10. Implementation: Building the Database
- 11. Data Delivery: What you Finally See
-
9. Architecture, Infrastructure, and Tools
-
V. Next Steps–Expanding on Success
-
12. Managing the Production Data Warehouse
- 12.1. Finishing the Project
- 12.2. Adopting the Solution
- 12.3. The Production Data Warehouse
- 12.4. When the Data Warehouse Falls Short
- 12.5. In Real Life
- 12.6. Summary
- 13. Achieving Long-Term Success
-
12. Managing the Production Data Warehouse
- Glossary
Product information
- Title: A Manager's Guide to Data Warehousing
- Author(s):
- Release date: May 2009
- Publisher(s): Wiley
- ISBN: 9780470176382
You might also like
book
Agile Data Warehousing for the Enterprise
Building upon his earlier book that detailed agile data warehousing programming techniques for the Scrum master, …
book
The Chief Data Officer Management Handbook: Set Up and Run an Organization’s Data Supply Chain
There is no denying that the 21st century is data driven, with many digital industries relying …
book
The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence
An unparalleled collection of recommended guidelines for data warehousing and business intelligence pioneered by Ralph Kimball …
book
Data Warehousing Fundamentals for IT Professionals
Cutting-edge content and guidance from a data warehousing expert—now expanded to reflect field trends Data warehousing …