Book Categories

Description of Unlocking OLAP with Microsoft® SQL ServerTM and Excel 2000

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

Title Information

ISBN:

9780764545870

Pages:

504 pages

Format:

Paperback

Product Code:

154808

Publisher:

John Wiley & Sons Ltd

Published:

09/05/2000

Write a review of this book

Customer Reviews from Amazon

About Wayne S. Freeze

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.