9780071549448

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

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.

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.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Amazon no longer offers textbook rentals. We do!

Delivering Business Intelligence with Microsoft SQL Server 2008

Delivering Business Intelligence with Microsoft SQL Server 2008

0071549447

Summary

Author Biography

Table of Contents

Supplemental Materials