Delivering Business Intelligence with Microsoft SQL Server 2008

by Larson, Brian

• ISBN13: 9780071549448
• ISBN10: 0071549447
• Edition: 2nd
• Format: Paperback
• Copyright: 2008-12-10
• Publisher: McGraw-Hill Education

Summary

Maximize the Business Intelligence Tools in Microsoft SQL Server 2008Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization. Understand the goals and benefits of business intelligence Design and create relational data marts and OLAP cubes Manage Analysis Services databases using BI Development Studio Cleanse data and populate data marts with SQL Server Integration Services Take advantage of the flexibility of the Unified Dimensional Model Manipulate and analyze data using MDX scripts and queries Use data mining to identify data patterns, correlations, and clustering Develop and distribute interactive reports with SQL Server 2008 Reporting Services Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

Author Biography

Brian Larson, MCSD, served as a member of the Reporting Services development team and contributed to the code base. He is the chief of technology for Superior Consulting Services (SCS), a Microsoft Certified Partner.

Table of Contents

Business Intelligence

Equipping the Organization for Effective Decision Making

Making the Most of What You've Got

Using Business Intelligence

Seeking the Source

The Source of Business Intelligence

One-Stop Shopping

The Unified Dimensional Model

First Steps

Beginning the Development of Business Intelligence

Defining Business Intelligence Structures

Building Foundations

Creating Data Marts

Transformers

Integration Services Structure and Components

Fill'er Up

Using Integration Services for Populating Data Marts

Analyzing Cube Content

Cubism

Measures and Dimensions

Bells and Whistles

Special Features of OLAP Cubes

Writing a New Script

MDX Scripting

Pulling It Out and Building It Up

MDX Queries

Mining

Panning for Gold

Introduction to Data Mining

Building the Mine

Working with the Data Mining Model

Spelunking

Exploration Using Data Mining

Delivering

On Report

Delivering Business Intelligence with Reporting Systems

Falling into Place

Managing Reporting Systems Reports

Let's Get Together

Excel Pivot Tables and Pivot Charts

Index

Table of Contents provided by Publisher. All Rights Reserved.