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.
Introduction xxiii
Part One The Essentials of Data Warehousing 1
Chapter 1 Gaining Data Warehouse Success 3
The Essentials of Data Warehousing 3
What Is a Data Warehouse? 4
Differences Between Operational and DW Systems 4
The Data Warehousing Environment 4
What Is a Data Model? 6
Understanding Industry Perspectives 7
Design and Development Sequence 8
Why Build a Data Warehouse? 11
The Value of Data Warehousing 12
The Promises of Data Warehousing 15
Keys to Success 16
Developing and Maintaining Strong Business and Technology Partnerships 17
Identifying True Business Requirements 17
Shifting to a Global Perspective 18
Overcoming Unrealistic Expectations 19
Providing Clear Communication 20
Treating Data As a Corporate Asset 21
Effectively Leveraging Technology 21
Roadblocks to Success 22
Believing the Myth: ‘‘If You Build It, They Will Come’&aml£²