Building a Data Warehouse: With Examples in SQL Server

Front Cover
Apress, Dec 27, 2007 - Computers - 523 pages
0 Reviews

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

What you’ll learn A detailed understanding of what it takes to build a data warehouse The implementation code in SQL Server to build the data warehouse Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management Who this book is for

There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

III
1
IV
4
V
5
VI
6
VII
7
VIII
8
IX
10
X
11
XCIII
266
XCIV
269
XCV
270
XCVI
271
XCVII
273
XCVIII
274
XCIX
277
C
290

XI
12
XII
13
XIII
14
XVI
15
XVII
16
XVIII
17
XX
18
XXI
19
XXII
20
XXIII
23
XXIV
24
XXVI
25
XXVII
26
XXVIII
27
XXX
29
XXXI
33
XXXII
35
XXXIII
38
XXXIV
39
XXXV
42
XXXVI
44
XXXVII
47
XXXVIII
49
XXXIX
54
XL
59
XLI
61
XLII
62
XLIII
63
XLIV
65
XLV
67
XLVI
70
XLVII
71
XLVIII
76
XLIX
77
L
80
LI
83
LII
89
LIII
94
LIV
96
LV
101
LVI
102
LVII
106
LVIII
111
LIX
113
LX
120
LXI
123
LXII
128
LXIII
139
LXIV
157
LXV
161
LXVI
162
LXVII
166
LXVIII
171
LXIX
173
LXX
174
LXXI
177
LXXII
180
LXXIV
181
LXXV
185
LXXVI
186
LXXVII
187
LXXIX
190
LXXX
191
LXXXI
200
LXXXII
208
LXXXIII
214
LXXXIV
215
LXXXV
216
LXXXVI
218
LXXXVII
219
LXXXVIII
228
LXXXIX
235
XC
242
XCI
249
XCII
250
CI
291
CII
293
CIII
296
CIV
298
CV
300
CVI
301
CVII
303
CVIII
308
CIX
313
CX
318
CXI
320
CXII
323
CXIII
324
CXIV
325
CXV
327
CXVI
329
CXVII
332
CXVIII
334
CXIX
340
CXX
342
CXXI
356
CXXII
357
CXXIII
362
CXXIV
366
CXXV
370
CXXVII
372
CXXVIII
374
CXXIX
375
CXXX
377
CXXXI
380
CXXXII
381
CXXXIII
394
CXXXIV
396
CXXXV
397
CXXXVI
399
CXXXVII
405
CXXXVIII
409
CXXXIX
411
CXL
412
CXLI
413
CXLII
416
CXLIII
432
CXLIV
437
CXLV
438
CXLVI
439
CXLVII
441
CXLVIII
442
CXLIX
447
CL
450
CLI
454
CLII
460
CLIII
463
CLIV
464
CLV
465
CLVI
466
CLVII
467
CLVIII
474
CLIX
477
CLX
478
CLXI
480
CLXII
482
CLXIII
485
CLXIV
486
CLXV
487
CLXVII
489
CLXVIII
491
CLXIX
492
CLXX
495
CLXXI
498
CLXXII
499
CLXXIII
501
CLXXIV
505
CLXXV
509
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

A bio is not available for this author.

Bibliographic information