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
- About the Author
I. The Essentials of Data Warehousing
1. Gaining Data Warehouse Success
1.1. The Essentials of Data Warehousing
- 1.1.1. What Is a Data Warehouse?
- 1.1.2. Why Build a Data Warehouse?
- 1.1.3. The Value of Data Warehousing
1.2. The Promises of Data Warehousing
1.2.1. Keys to Success
- 220.127.116.11. Developing and Maintaining Strong Business and Technology Partnerships
- 18.104.22.168. Identifying True Business Requirements
- 22.214.171.124. Shifting to a Global Perspective
- 126.96.36.199. Overcoming Unrealistic Expectations
- 188.8.131.52. Providing Clear Communication
- 184.108.40.206. Treating Data As a Corporate Asset
- 220.127.116.11. Effectively Leveraging Technology
1.2.2. Roadblocks to Success
- 18.104.22.168. Believing the Myth: "If You Build It, They Will Come"
- 22.214.171.124. Falling into the Project Deadline Trap
- 126.96.36.199. Failing to Uphold Organizational Discipline
- 188.8.131.52. Lacking Business Process Change
- 184.108.40.206. Narrowing the Focus Too Much
- 220.127.116.11. Resting on Your Laurels
- 18.104.22.168. Relying on the Technology Fix
- 22.214.171.124. Getting the Right People Involved
- 126.96.36.199. Finding Lost Institutional Knowledge
- 1.2.1. Keys to Success
- 1.3. Summary
- 1.1. The Essentials of Data Warehousing
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
- 3.1. Assessing Your Current State
- 3.2. Understanding Your Existing Reporting Environment
- 3.3. Introducing the Case Studies
- 3.4. Summary
4. Successful IT–Business Partnerships
- 4.1. What a Partnership Really Means
- 4.2. What the Business Partners Should Expect to Do
- 4.3. What You Should Expect from IT
- 4.4. Tips for Building and Sustaining a Partnership
- 4.5. Effective Communication
- 4.6. Partnerships Beyond a Project
- 4.7. In Real Life
- 4.8. Summary
5. Setting Up a Successful Project
- 5.1. Defining the Project
- 5.2. Starting the Project
- 5.3. Managing a Successful Project
- 5.4. In Real Life
- 5.5. Summary
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.4.1. Interview Session Characteristics
- 6.4.2. Who Needs to Be Included?
- 6.4.3. Preparing for Interview Sessions
- 6.4.4. Conducting the Interview Sessions
6.5. Putting the Pieces Together
- 6.5.1. Individual Interview Documentation
- 6.5.2. Consolidated Requirements Documentation
- 6.5.3. Common Requirements Gathering Challenges
- 6.6. Setting Attainable Goals
- 6.7. In Real Life
- 6.8. Summary
- 3. Understanding Where You Are and Finding Your Way
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.5.1. Call Center Dimensions
- 7.5.2. Call Center Fact Groups
- 7.5.3. Working with the Model
- 7.5.4. Business Dimensional Model Index
- 7.6. Enterprise Considerations
7.7. Business Participation in the Modeling Process
- 7.7.1. Creating the First Draft
- 7.7.2. Preparing for Modeling Sessions
- 7.7.3. Completing or Fleshing Out the Model
- 7.7.4. Business Reviews of the Model
- 7.7.5. Expanding Business Data Over Time
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
- 188.8.131.52. Profiling the Data
- 184.108.40.206. How Clean Does the Data Really Need to Be?
- 220.127.116.11. Measuring Quality
- 18.104.22.168. Quality of Historical Data
- 22.214.171.124. Cleansing at the Source
- 126.96.36.199. Cleaning Up for Reporting
- 188.8.131.52. Managing the Integrity of Data Integration
- 184.108.40.206. Quality Improves When It Matters
- 220.127.116.11. Example: Data Quality and Grocery Checkout Scanners
- 18.104.22.168. Example: Data Quality and the Evaluation of Public Education
- 22.214.171.124. Realizing the Value of Data Quality
- 8.4. Implementing a Data Dictionary
8.5. Getting Started with Information Management
- 8.5.1. Understanding Your Current Data Environment
- 8.5.2. Where Do You Want to Be?
- 8.5.3. Develop a Realistic Strategy
- 8.5.4. Setting Up a Sustainable Process
- 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.3.1. Revisiting DW Goals
- 9.3.2. Components of DW Data Architecture
9.3.3. A Closer Look at Common Data Warehouse Architectures
- 126.96.36.199. Bottom-Up Data Architecture
- 188.8.131.52. Top-Down Data Architecture
- 184.108.40.206. Publish the Data: Data Marts
- 220.127.116.11. Adopting an Architecture
- 9.4. Technical Architecture
9.5. Navigating the Technology Jungle
- 9.5.1. Weighing Technology Options
- 9.5.2. Finding the Right Products
- 9.5.3. Understanding Value and Evaluating Your Options
- 9.5.4. The Value of References
- 9.6. Making Architecture Work for You
- 9.7. In Real Life
- 9.8. Summary
10. Implementation: Building the Database
- 10.1. Extract, Transform, and Load (ETL) Fundamentals
- 10.2. The Business Role in ETL
- 10.3. Balancing Requirements and Data Reality
- 10.4. Tracking Progress–Are We There Yet?
- 10.5. What Else Can You Do to Help?
- 10.6. In Real Life
- 10.7. Summary
11. Data Delivery: What you Finally See
- 11.1. What Is Business Intelligence?
- 11.2. BI Building Blocks
- 11.3. Supporting Different Levels of Use
- 11.4. Construction of the BI Solution
- 11.5. Planning a Successful Launch
- 11.6. In Real Life
- 11.7. Summary
- 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.3.1. Staffing Production Activities
- 12.3.2. Maintaining the Environment
- 12.3.3. Maintaining the Data Warehouse
- 12.3.4. Tracking Questions and Problems
- 12.3.5. Fixing Bugs
12.4. When the Data Warehouse Falls Short
- 12.4.1. Common Causes for a Stalled Warehouse
- 12.4.2. Jump-Starting a Stalled Data Warehouse
- 12.4.3. Launching the Improved Data Warehouse and BI Solution
- 12.5. In Real Life
- 12.6. Summary
13. Achieving Long-Term Success
- 13.1. Planning for Expansion and Growth
- 13.2. Managing Enterprise DW Resources
- 13.3. Pushing into the Future
- 13.4. Moving Toward Business Value
- 13.5. Conclusion
- 12. Managing the Production Data Warehouse
- Title: A Manager's Guide to Data Warehousing
- Release date: May 2009
- Publisher(s): Wiley
- ISBN: 9780470176382