Delivering Business Intelligence with Microsoft SQL Server 2005 (Paperback)

Description

Data warehouse administrators, Business Intelligence (BI) solution developers, and BI analysts will find out how to get the most out of Microsoft's powerful BI tools which are included free in SQL Server 2005.This practical, start-to-finish guide explains how to develop a comprehensive, secure, integrated, and highly available BI solution. Readers will learn to set up the database, mine and analyze data, and deliver the results.

 

Table of contents 

PART I: Business Intelligence
Chapter 1: Equipping the Organization for Effective Decision Making
Chapter 2: Making the Most of What You've Got -- Using Business Intelligence
Chapter 3: Searching for the Source -- The Source of Business Intelligence
Chapter 4: One-Stop Shopping -- The Unified Dimensional Model
Chapter 5: First Steps -- Beginning the Development of Business Intelligence

PART II: Defining Business Intelligence Structures
Chapter 6: Building Foundations -- Creating and Populating Data Marts
Chapter 7: Fill 'er up -- Using Integration Services for Populating Data Marts

PART III: Analyzing Cube Content
Chapter 8: Cubism -- Measures and Dimensions
Chapter 9: Bells and Whistles -- Special Features of OLAP Cubes
Chapter 10: Writing a New Script -- MDX Scripting
Chapter 11: Pulling It Out and Building It Up -- MDX Queries

PART IV: Mining
Chapter 12: Panning for Gold -- Introduction to Data Mining
Chapter 13: Building the Mine -- Working with the Data Mining Model
Chapter 14: Spelunking -- Exploration Using Data Mining

PART V: Delivering
Chapter 15: On Report -- Delivering Business Intelligence with Reporting Services
Chapter 16: Let's Get Together -- Integrating OLAP with Your Applications
Chapter 17: Another Point of View -- Excel Pivot Tables and Pivot Cha