Unlocking Olap With Microsoft SQL Server and Excel 2000

by Freeze, Wayne S.

• ISBN13: 9780764545870
• ISBN10: 0764545876
• Edition: CD
• Format: Paperback
• Copyright: 2000-07-01
• Publisher: John Wiley & Sons Inc

Summary

There2s so much information inside your database, but how do you get at it and use it successfully? With this guide to Online Analytical Processing (OLAP) tools, you can forego programming and custom data warehousing and tap into the power of Microsoft SQL Server technology. You can build your own data warehouse using the Enterprise Manager tool in SQL Server and pull out what you need using SQL Server Query Analyzer and English Query tools. What2s more, Excel 2000, in tandem with these tools, serves up your data in multidimensional, mission-specific reports. The CD-ROM includes extensive sample databases and an evaluation edition of Microsoft SQL Server 7.0.

Author Biography

Wayne S. Freeze has more than 20 years of experience as an IT professional, most recently as Manager of Systems Programming at the University of Maryland.

Table of Contents

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