Synopses & Reviews
Unlocking OLAP with Microsoft
® SQL Server
and Excel 2000 How do you get at the mission-critical information trapped inside your databases? This unique guide explains how to take advantage of sophisticated OLAP (Online Analytical Processing) tools, without spending lots of time and money on a custom data warehousing system, and without any programming. Using concrete examples and step-by-step instructions, author Wayne S. Freeze shows you how to set up your own data warehouse with Microsoft SQL Server and then harness the OLAP tools that come with Microsoft SQL Server and Excel 2000 to slice and dice your data into revealing multi-dimensional reports. Working Solutions for Data Analysis Challenges
- Understand the relationship between databases, data warehouses, OLAP, and Excel
- Build a data warehouse using the Enterprise Manager tool in SQL Server
- Clean up data from existing databases and transfer it to the data warehouse with Microsoft SQL Server Data Transformation Services
- Use the Microsoft SQL Server Query Analyzer and English Query tools to collect information from your data warehouse
- Learn how to perform sophisticated analysis with OLAP data modeling
- Create multi-dimensional OLAP cubes from the data in your warehouse
- Build a database of OLAP cubes with the Microsoft SQL Server OLAP Manager
- Analyze geographic data visually with Microsoft MapPoint 2000
- Construct Excel PivotTables and PivotCharts to the information in your OLAP database
CD-ROM includes:
- Extensive example database
- Microsoft SQL Server 7.0 120-Day Evaluation Edition
www.idgbooks.com System Requirements: Windows NT Server 4.0 SP4 or higher; 32MB RAM, 210MB available hard disk space
Synopsis
There's 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. What's 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.
Description
System requirements for accompanying computer disc: Windows NT Server 4.0 SP4 or higher.
About the Author
About the Author 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. His many books include The SQL Programmer's Reference and Hands On SQL Server 7 with Visual Basic 6.
Table of Contents
Preface.
Acknowledgment.
PART I: Introduction to OLAP.
Chapter 1: Introducing OLAP.
Chapter 2: What Is a Relational Database?
Chapter 3: Introducing Data Warehousing.
Chapter 4: Introducing Microsoft's OLAP Tools.
Chapter 5: Introducing Microsoft's Data Warehousing Framework.
PART II: Creating a Data Warehouse.
Chapter 6: Identifying the Data Requirements.
Chapter 7: Designing the Data Warehouse.
Chapter 8: Building the Data Warehouse.
Chapter 9: Using Data Transformation Services.
Chapter 10: Securing the Data Warehouse.
PART III: Using the Data Warehouse with Query Analyzer.
Chapter 11: Creating Simple Queries with Query Analyzer.
Chapter 12: Writing Complex Queries.
Chapter 13: Using Query Analyzer for Other Tasks.
PART IV: Analyzing Data with English Query and MapPoint 2000.
Chapter 14: Teaching English Query about Your Database.
Chapter 15: Polishing Your English Query Application.
Chapter 16: Mapping Data with MapPoint 2000.
PART V: Understanding OLAP Databases.
Chapter 17: The OLAP Data Model.
Chapter 18: The Language of OLAP: Creating Cubes.
Chapter 19: The Language of OLAP: Querying Cubes.
PART VI: Creating an OLAP Database.
Chapter 20: Using OLAP Manager to Build Cubes.
Chapter 21: Using OLAP Manager to Browse Cubes.
Chapter 22: Performance Considerations.
Chapter 23: Security Considerations.
PART VII: Analyzing the OLAP Database with Microsoft Excel.
Chapter 24: Creating Basic Excel Worksheets.
Chapter 25: Building Simple PivotTables.
Chapter 26: Extracting Information from PivotTables.
Chapter 27: Charting Information from PivotTables.
Chapter 28: Interactive Data Analysis on the Web.
Appendix A.
Index.
End-User Agreement.
CD-ROM Installation.