| Preface |
|
xiii | |
| Acknowledgments |
|
xv | |
| About the Author |
|
xvii | |
|
|
|
1 | (8) |
|
|
|
2 | (1) |
|
Challenges in Data Warehousing |
|
|
3 | (1) |
|
|
|
4 | (1) |
|
|
|
5 | (1) |
|
Current Status of Strategic Alignment Research |
|
|
6 | (1) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
Organization of Remaining Chapters |
|
|
8 | (1) |
|
Benefits of a Data Warehouse |
|
|
9 | (10) |
|
Evolution of Information Technology |
|
|
9 | (1) |
|
Evolution of Information Systems |
|
|
10 | (2) |
|
Benefits of a Data Warehouse |
|
|
12 | (6) |
|
|
|
12 | (1) |
|
|
|
13 | (2) |
|
|
|
15 | (1) |
|
|
|
16 | (1) |
|
|
|
17 | (1) |
|
|
|
17 | (1) |
|
|
|
18 | (1) |
|
Difference Between Data Warehouses and Traditional Operational Systems |
|
|
19 | (10) |
|
Features of a Data Warehouse |
|
|
19 | (2) |
|
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
20 | (1) |
|
|
|
21 | (1) |
|
|
|
21 | (1) |
|
Difference Between Data Warehouses and Traditional Operational Systems |
|
|
21 | (8) |
|
|
|
22 | (1) |
|
|
|
22 | (1) |
|
|
|
23 | (1) |
|
Online Analytical Processing |
|
|
23 | (1) |
|
|
|
24 | (1) |
|
|
|
24 | (1) |
|
Unpredictable Query Pattern |
|
|
25 | (1) |
|
Other Important Differences |
|
|
25 | (4) |
|
Data Warehouse Development Process |
|
|
29 | (24) |
|
|
|
30 | (1) |
|
|
|
30 | (12) |
|
Transforming Enterprise Data Model to Data Warehouse Model |
|
|
34 | (1) |
|
|
|
35 | (1) |
|
Add an Element of Time to the Key Structure |
|
|
35 | (1) |
|
Add Appropriate Derived Data |
|
|
35 | (1) |
|
Transform Data Relationships into Data Artifacts |
|
|
36 | (1) |
|
Accommodate Different Levels of Granularity |
|
|
37 | (2) |
|
Merge Like Data from Different Tables |
|
|
39 | (1) |
|
|
|
40 | (1) |
|
Separate Data Attributes by Stability Characteristics |
|
|
41 | (1) |
|
Data Extraction and Conversion |
|
|
42 | (4) |
|
|
|
43 | (1) |
|
|
|
43 | (1) |
|
Loading the Data Warehouse |
|
|
44 | (1) |
|
|
|
45 | (1) |
|
Data Warehouse Database Management System |
|
|
46 | (2) |
|
Differences between Relational and Multidimensional Designs |
|
|
47 | (1) |
|
Data Warehouse Administration |
|
|
48 | (1) |
|
Access and Business Intelligence Tools |
|
|
49 | (1) |
|
|
|
50 | (3) |
|
Data Warehouse Architectures |
|
|
53 | (4) |
|
Factors Influencing the Success of a Data Warehouse |
|
|
57 | (18) |
|
Organization Factors that Influence Success of a Data Warehouse |
|
|
58 | (6) |
|
User Factors that Influence Success of a Data Warehouse |
|
|
64 | (1) |
|
Technology Factors that Influence Success of a Data Warehouse |
|
|
65 | (2) |
|
Data Factors that Influence Success of a Data Warehouse |
|
|
67 | (8) |
|
|
|
68 | (1) |
|
|
|
69 | (1) |
|
|
|
70 | (1) |
|
|
|
71 | (1) |
|
Representational Data Quality |
|
|
71 | (4) |
|
|
|
75 | (16) |
|
Need for Strategic Alignment Between IT and Business |
|
|
76 | (2) |
|
The Strategic Alignment Model |
|
|
78 | (2) |
|
Developments in Strategic Alignment Research |
|
|
80 | (4) |
|
Alternatives to the Strategic Alignment Model |
|
|
84 | (2) |
|
Enablers of Business-IT Alignment |
|
|
86 | (3) |
|
|
|
87 | (1) |
|
|
|
87 | (1) |
|
|
|
87 | (1) |
|
|
|
88 | (1) |
|
|
|
89 | (1) |
|
|
|
89 | (2) |
|
Strategic Alignment of Data Warehouses |
|
|
91 | (24) |
|
|
|
91 | (2) |
|
Joint Responsibility between Data Warehouse and Business Managers |
|
|
93 | (7) |
|
Alignment between Business Plan and Data Warehouse Plan |
|
|
100 | (4) |
|
Business User Satisfaction |
|
|
104 | (5) |
|
|
|
109 | (3) |
|
|
|
112 | (3) |
|
Strategic Alignment at Nielsen Media Research |
|
|
115 | (20) |
|
|
|
115 | (1) |
|
|
|
115 | (2) |
|
|
|
116 | (1) |
|
Background of the Data Warehouse |
|
|
116 | (1) |
|
The Data Warehouse Development |
|
|
117 | (2) |
|
|
|
117 | (1) |
|
Data Warehouse Architecture Selection |
|
|
118 | (1) |
|
|
|
118 | (1) |
|
Strategic Alignment of the Data Warehouse at Nielsen Media Research |
|
|
119 | (14) |
|
Joint Responsibility between Business and Data Warehouse Managers |
|
|
120 | (1) |
|
Commitment and Involvement of Senior Management |
|
|
120 | (1) |
|
Involvement of Data Warehouse Managers in Corporate Strategy |
|
|
121 | (1) |
|
Alignment between Business and Data Warehouse Plans |
|
|
122 | (1) |
|
Architectural Alignment of the Data Warehouse |
|
|
122 | (1) |
|
|
|
123 | (1) |
|
Integration of Business and Data Warehouse Planning |
|
|
124 | (1) |
|
Communication between the Business and Data Warehouse Managers |
|
|
125 | (1) |
|
User Participation and Satisfaction, and Data Warehouse Success |
|
|
126 | (1) |
|
|
|
126 | (1) |
|
|
|
127 | (1) |
|
|
|
128 | (1) |
|
|
|
128 | (1) |
|
Technical Integration and Data Warehouse Alignment and Success |
|
|
129 | (1) |
|
|
|
129 | (1) |
|
|
|
130 | (1) |
|
Organizational Capability |
|
|
131 | (1) |
|
Flexibility in Data Warehouse Planning |
|
|
131 | (2) |
|
|
|
133 | (2) |
|
Strategic Alignment at Raymond James Financial |
|
|
135 | (22) |
|
|
|
135 | (1) |
|
|
|
135 | (2) |
|
|
|
136 | (1) |
|
|
|
136 | (1) |
|
|
|
137 | (1) |
|
Background of the Data Warehouse |
|
|
137 | (3) |
|
|
|
138 | (1) |
|
Data Warehouse Development |
|
|
138 | (1) |
|
|
|
138 | (1) |
|
|
|
139 | (1) |
|
|
|
139 | (1) |
|
|
|
139 | (1) |
|
Strategic Alignment of the Data Warehouse at Raymond James Financial |
|
|
140 | (16) |
|
Joint Responsibility Between Business and Data Warehouse Managers |
|
|
140 | (1) |
|
Commitment and Involvement of Senior Management in Data Warehouse Project |
|
|
140 | (1) |
|
Involvement of Data Warehouse Managers in Corporate Strategy |
|
|
141 | (1) |
|
Alignment between Business and Data Warehouse Plans |
|
|
142 | (1) |
|
Architectural Alignment of the Data Warehouse |
|
|
143 | (1) |
|
|
|
144 | (1) |
|
Integration of Business and Data Warehouse Planning |
|
|
145 | (1) |
|
Communication between the Business and Data Warehouse Managers |
|
|
146 | (1) |
|
Business User Participation and Satisfaction, and Data Warehouse Success |
|
|
147 | (1) |
|
|
|
147 | (1) |
|
|
|
148 | (1) |
|
|
|
149 | (1) |
|
|
|
150 | (1) |
|
Technical Integration and Data Warehouse Alignment and Success |
|
|
151 | (1) |
|
|
|
152 | (1) |
|
|
|
152 | (1) |
|
Organizational Capability |
|
|
153 | (1) |
|
Flexibility in Data Warehouse Planning |
|
|
154 | (2) |
|
|
|
156 | (1) |
|
How to Assess Strategic Alignment of a Data Warehouse |
|
|
157 | (12) |
|
Design of the Interview Instruments |
|
|
158 | (1) |
|
Design of Interview Instruments for Senior Business Managers |
|
|
158 | (2) |
|
Questions for Senior Business Managers |
|
|
159 | (1) |
|
Questions for Senior Business Managers Regrouped According to Main Questions |
|
|
159 | (1) |
|
Design of Interview Instruments for Data Warehouse Managers |
|
|
160 | (5) |
|
Questions for Data Warehouse Managers |
|
|
162 | (1) |
|
Questions for Data Warehouse Managers Regrouped According to Main Questions |
|
|
162 | (3) |
|
Design of Interview Instruments for Business Users |
|
|
165 | (4) |
|
Questions for Business Users |
|
|
165 | (1) |
|
Questions for Business Users Regrouped According to Main Questions |
|
|
165 | (4) |
|
|
|
169 | (8) |
|
|
|
169 | (1) |
|
|
|
170 | (4) |
|
Service Orientation of Data Warehouses |
|
|
174 | (1) |
|
|
|
175 | (2) |
| References |
|
177 | (14) |
| Index |
|
191 | |