search for books and compare prices
Tables of Contents for Unlocking Olap With Microsoft SQL Server and Excel 2000
Chapter/Section Title
Page #
Page Count
Preface
ix
Acknowledgment
xiii
Part I Introduction to OLAP
Introduction to OLAP
3
10
What Is a Relational Database?
13
12
Introducing Data Warehousing
25
14
Introducing Microsoft's OLAP Tools
39
14
Introducing Microsoft's Data Warehousing Framework
53
12
Part II Creating a Data Warehouse
Identifying the Data Requirements
65
12
Designing the Data Warehouse
77
14
Building the Data Warehouse
91
30
Using Data Transformation Services
121
18
Securing the Data Warehouse
139
16
Part III Using the Data Warehouse with Query Analyzer
Creating Simple Queries with Query Analyzer
155
16
Writing Complex Queries
171
18
Using Query Analyzer for Other Tasks
189
20
Part IV Analyzing Data With English Query and MapPoint 2000
Teaching English Query about Your Database
209
16
Polishing Your English Query Application
225
20
Mapping Data with MapPoint 2000
245
20
Part V Understanding OLAP Databases
The OLAP Data Model
265
12
The Language of OLAP: Creating Cubes
277
14
The Language of OLAP: Querying Cubes
291
8
Part VI Creating an OLAP Database
Using OLAP Manager to Build Cubes
299
20
Using OLAP Manager to Browse Cubes
319
14
Performance Considerations
333
14
Security Considerations
347
16
Part VII Analyzing the OLAP Database with Microsoft Excel
Creating Basic Excel Worksheets
363
16
Building Simple PivotTables
379
12
Extracting Information from PivotTables
391
14
Charting Information from PivotTables
405
18
Interactive Data Analysis on the Web
423
12
Appendix A
435
28
Index
463
11
End-User Agreement
474
4
CD-ROM Installation
478