Professional Microsoft SQL Server Analysis Services 2008 With Mdx

by Harinath, Sivakumar; Zare, Robert; Meenakshisundaram, Sethu; Carroll, Matt; Lee, Denny Guang-Yeu

• ISBN13: 9780470247983
• ISBN10: 0470247983
• Format: Paperback
• Copyright: 2009-03-16
• Publisher: Wrox

Summary

When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis. Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

Author Biography

Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was "Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks." Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Canada; National Center for Data Mining, University of Illinois at Chicago; and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and currently is a Senior Test Lead in the Analysis Services team. Siva's other interests include high - performance computing, distributed systems, and high-speed networking. Siva is married to Shreepriya and has twins, Praveen and Divya. His personal interests include travel, games, and sports (in particular carrom, chess, racquet ball, and board games). You can reach Siva at [e-mail].

Matt Carroll is currently a Senior Development Lead on the SQL Server Integration Services team at Microsoft. Prior to this, he spent 10 years working on the SQL Server Analysis Services team as a developer and then development lead. He's presented on Analysis Services at VSLive and compiled and edited the whitepaper "OLAP Design Best Practices for Analysis Services 2005."

Sethu Meenakshisundaram has more than 20 years of Enterprise System Software Development experience. Sethu spent a good portion of his career at Sybase Inc. in architecture, development, and management building world class OLTP and OLAP Database Systems. Sethu was instrumental in developing and leading highly complex clustered systems of Adaptive Server Enterprise. Early in the '90s, Sethu developed a version of Sybase Adaptive Server running on the Windows platform. Most recently he was an Architect in the SQL Server BI team driving technology and partner strategy. Prior to Microsoft, Sethu managed all of Server development as Senior Director at Sybase including building teams in the U.S., India, and China. He is currently a Vice President in charge of Technology Strategy at SAP Labs, USA.

Rob Zare is a program manager on the SQL Server development team. He's worked on the product since shortly before the first service pack of SQL Server 2000. During that time, he's focused primarily on Analysis Services, though for the next major release of SQL Server he'll be focused on Integration Services. He is the co-author of Fast Track to MDX and regularly speaks at major technical conferences around the world.

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of "SQL Server 2000 Data Warehousing with Analysis Services" and "Transforming Healthcare through Information [Ed. Joan Ash] (2008)". In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.

Table of Contents

Introduction

Introduction

Introduction to Data Warehousing and SQL Server 2008 Analysis Services

First Look at Analysis Services 2008

Introduction to MDX

Working with Data Sources and Data Source Views

Dimension Design

Cube Design

Administering Analysis Services

Advanced Topics

Advanced Dimension Design

Advanced Cube Design

Advanced Topics in MDX

Extending MDX Using External Functions

Data Writeback

Advanced Administration and Performance Optimization

Programmatic and Advanced Administration

Designing for Performance

Analyzing and Optimizing Query Performance

Integration with Microsoft Products

Data Mining

Analyzing Cubes Using Microsoft Office Components

Using Data Mining with Office 2007

Integration Services

Reporting Services

Scenarios

Designing Real-Time Cubes

Securing Your Data in Analysis Services

Inventory Scenarios

Financial Scenarios

Web Analytics

MDX Functions

Index

Table of Contents provided by Publisher. All Rights Reserved.