Unlocking OLAP with Microsoft SQL Server and Excel 2000

Overview

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

Read More