Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A

ISBN: 0072260904
EAN: 2147483647

Year: 2007
Pages: 112

Authors: Brian Larson

BUY ON AMAZON

Table of Contents
Back Cover
Delivering Business Intelligence with Microsoft SQL Server 2005
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 GotUsing Business Intelligence
What Business Intelligence Can Do For You
Business Intelligence at Many Levels
Maximum Miniatures, Inc.
Building the Foundation
Chapter 3: Searching for the SourceThe Source of Business Intelligence
Seeking the Source
The Data Mart
Snowflakes, Stars, and Analysis Services
Chapter 4: One-Stop ShoppingThe Unified Dimensional Model
Online Analytical Processing
The Unified Dimensional Model
Tools of the Trade
Chapter 5: First StepsBeginning 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 FoundationsCreating and Populating Data Marts
Data Mart
Designing a Data Mart
The Benefits of Integration
Chapter 7: Fill er UpUsing Integration Services for Populating Data Marts
Integration Services
Package Development Features
Putting Integration Services Packages into Production
Meanwhile, Back at the Unified Dimensional Model (UDM)
Part III: Analyzing Cube Content
Chapter 8: CubismMeasures and Dimensions
Where We ve Been and Where We re Going
Measures
Dimensions
You Are Special
Chapter 9: Bells and WhistlesSpecial Features of OLAP Cubes
Where No Cube Has Gone Before
Additional Cube Features
More Sophisticated Scripting
Chapter 10: Writing a New ScriptMDX Scripting
Terms and Concepts
Putting MDX Scripting to Work
Extracting Data from Cubes
Chapter 11: Pulling It Out and Building It UpMDX Queries
The MDX SELECT Statement
Additional MDX Syntax
Can You Dig It?
Part IV: Mining
Chapter 12: Panning for GoldIntroduction to Data Mining
What Is Data Mining?
Data Mining Algorithms
Grab a Pick Axe
Chapter 13: Building the MineWorking with the Data Mining Model
Data Mining Structure
Mining Model Viewer
Reading the Tea Leaves
Chapter 14: SpelunkingExploration Using Data Mining
Mining Accuracy Chart
Mining Model Prediction
Data Mining Extensions
Special Delivery
Part V: Delivering
Chapter 15: On ReportDelivering Business Intelligence with Reporting Services
Reporting Services
Report Serving Architecture
Report Creation
Report Manager
Managing Reports on the Report Server
Ad Hoc Reporting
Putting It All Together
Chapter 16: Let s Get TogetherIntegrating Olap with Your Applications
ADOMD.NET
Using Reporting ServicesWithout the Report Manager
Ready-Made Solution
Chapter 17: Another Point of ViewExcel Pivot Tables and Pivot Charts
Excel
New Capabilities, New Opportunities
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
List of Figures
List of Tables