|
Delivering Business Intelligence with SQL Server 2005; Utilize Microsoft's Data Warehouseing Tools
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.
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 Charts
|
