Sign in  |  Register
Advanced search
Publication Cover

CITATION

Larson, Brian. Delivering Business Intelligence with Microsoft SQL Server 2008. US: McGraw-Hill Osborne Media, 2008.

Delivering Business Intelligence with Microsoft SQL Server 2008

Authors: Brian Larson

Published:  November 2008

eISBN: 9780071549455 0071549455 | ISBN: 9780071549448
Open eBook
  • Contents
  • Acknowledgments
  • The Maximum Miniatures Databases and Other Supporting Materials
  • Part I: Business Intelligence
  • Chapter 1 Equipping the Organization for Effective Decision Making
  • Effective Decision Making
  • Keys to Effective Decision Making
  • Business Intelligence
  • Chapter 2 Making the Most of What You’ve Got—Using Business Intelligence
  • What Business Intelligence Can Do for You
  • Business Intelligence at Many Levels
  • Maximum Miniatures, Inc.
  • Building the Foundation
  • Chapter 3 Seeking the Source—The Source of Business Intelligence
  • Seeking the Source
  • The Data Mart
  • Snowflakes, Stars, and Analysis Services
  • Chapter 4 One-Stop Shopping—The Unified Dimensional Model
  • Online Analytical Processing
  • The Unified Dimensional Model
  • Tools of the Trade
  • Chapter 5 First Steps—Beginning the Development of Business Intelligence
  • The Business Intelligence Development Studio
  • The SQL Server Management Studio
  • Don Your Hardhat
  • Part II: Defining Business Intelligence Structures
  • Chapter 6 Building Foundations—Creating Data Marts
  • Data Mart
  • Designing a Data Mart
  • Table Compression
  • The Benefits of Integration
  • Chapter 7 Transformers—Integration Services Structure and Components
  • Integration Services
  • Package Items
  • Getting Under the Sink
  • Chapter 8 Fill ’er Up—Using Integration Services for Populating Data Marts
  • Package Development Features
  • Putting Integration Services Packages into Production
  • Change Data Capture
  • Loading a Fact Table
  • Meanwhile, Back at the Unified Dimensional Model (UDM)
  • Part III: Analyzing Cube Content
  • Chapter 9 Cubism—Measures and Dimensions
  • Building in Analysis Services
  • Measures
  • Dimensions
  • You Are Special
  • Chapter 10 Bells and Whistles—Special Features of OLAP Cubes
  • Where No Cube Has Gone Before
  • Additional Cube Features
  • More Sophisticated Scripting
  • Chapter 11 Writing a New Script—MDX Scripting
  • Terms and Concepts
  • Putting MDX Scripting to Work
  • Extracting Data from Cubes
  • Chapter 12 Pulling It Out and Building It Up—MDX Queries
  • The MDX SELECT Statement
  • Additional MDX Syntax
  • Can You Dig It?
  • Part IV: Mining
  • Chapter 13 Panning for Gold—Introduction to Data Mining
  • What Is Data Mining?
  • Data Mining Algorithms
  • Grab a Pick Axe
  • Chapter 14 Building the Mine—Working with the Data Mining Model
  • Data Mining Structure
  • Mining Model Viewer
  • Reading the Tea Leaves
  • Chapter 15 Spelunking—Exploration Using Data Mining
  • Mining Accuracy Chart
  • Mining Model Prediction
  • Data Mining Extensions
  • Special Delivery
  • Part V: Delivering
  • Chapter 16 On Report—Delivering Business Intelligence with Reporting Services
  • Reporting Services
  • Report Serving Architecture
  • Creating Reports Using the Tablix Data Region
  • Get Me the Manager
  • Chapter 17 Falling into Place—Managing Reporting Services Reports
  • Report Manager
  • Managing Reports on the Report Server
  • Ad Hoc Reporting
  • Putting It All Together
  • Chapter 18 Let’s Get Together—Integrating OLAPwith Your Applications
  • ADOMD.NET
  • Using Reporting Services Without the Report Manager
  • Ready-Made Solution
  • Chapter 19 Another Point of View—Excel Pivot Tablesand Pivot Charts
  • Excel
  • Great Capabilities, Great Opportunities
  • Index