Delivering Business Intelligence with Microsoft SQL Server 2008

Name: Delivering Business Intelligence with Microsoft SQL Server 2008
Brand: McGraw-Hill
Price: 93.69 EUR
Availability: OnlineOnly

Brian Larson(Autor*in)

McGraw-Hill (Verlag)

1. Auflage

Erschienen am 19. November 2008

1028 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-07-154945-5 (ISBN)

93,69 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Microsoft® SQL ServerT 2008 DELIVERING BUSINESS INTELLIGENCE
Copyright Page
Dedication
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
Who Is a Decision Maker?
What Is an Effective Decision?
Keys to Effective Decision Making
Are We Going Hither or Yon?
Is Your Map Upside-Down?
Panicked Gossip, the Crow's Nest, or the Wireless
Business Intelligence
Business Intelligence and Microsoft SQL Server 2008
Chapter 2 Making the Most of What You've Got-Using Business Intelligence
What Business Intelligence Can Do for You
When We Know What We Are Looking For
Discovering New Questions and Their Answers
Business Intelligence at Many Levels
The Top of the Pyramid
Mid-Level
The Broad Base
Maximum Miniatures, Inc
Business Needs
Current Systems
Building the Foundation
Chapter 3 Seeking the Source-The Source of Business Intelligence
Seeking the Source
Transactional Data
The Data Mart
Features of a Data Mart
Data Mart Structure
Snowflakes, Stars, and Analysis Services
Chapter 4 One-Stop Shopping-The Unified Dimensional Model
Online Analytical Processing
Building OLAP-Out of Cubes
Features of an OLAP System
Architecture
Disadvantages
Read-Only
The Unified Dimensional Model
Structure
Advantages
Tools of the Trade
Chapter 5 First Steps-Beginning the Development of Business Intelligence
The Business Intelligence Development Studio
Visual Studio
Navigating the Business Intelligence Development Studio
Business Intelligence Development Studio Options
The SQL Server Management Studio
The SQL Server Management Studio User Interface
Don Your Hardhat
Part II Defining Business Intelligence Structures
Chapter 6 Building Foundations-Creating Data Marts
Data Mart
Who Needs a Data Mart Anyway?
Designing a Data Mart
Decision Makers' Needs
Available Data
Data Mart Structures
Creating a Data Mart Using the SQL Server Management Studio
Creating a Data Mart Using the Business Intelligence Development Studio
Table Compression
Types of Table Compression
The Benefits of Integration
Chapter 7 Transformers-Integration Services Structure and Components
Integration Services
Package Structure
Package Items
Control Flow
Data Flow
Getting Under the Sink
Chapter 8 Fill'er Up-Using Integration Services for Populating Data Marts
Package Development Features
Give It a Try
Programming in Integration Services Packages
Package Development Tools
Migrating from SQL Server 2000 DTS Packages
Putting Integration Services Packages into Production
Deploying Integration Services Packages
Change Data Capture
Change Data Capture Architecture
Loading a Data Mart Table from a Change Data Capture Change Table
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
Creating a Cube
Measures
Measure Groups
Made-up Facts-Calculated Measures
It Doesn't Add Up-Measure Aggregates Other Than Sum
Dimensions
Managing Dimensions
Relating Dimensions to Measure Groups
Types of Dimensions
Slowly Changing Dimensions
You Are Special
Chapter 10 Bells and Whistles-Special Features of OLAP Cubes
Where No Cube Has Gone Before
Deploying and Processing
Deploying from the Business Intelligence Development Studio
Deploying from the Analysis Services Deployment Wizard
Additional Cube Features
Linked Objects
The Business Intelligence Wizard
Key Performance Indicators
Actions
Partitions
Aggregation Design
Perspectives
Translations
More Sophisticated Scripting
Chapter 11 Writing a New Script-MDX Scripting
Terms and Concepts
Where Are We?
Getting There from Here
Putting MDX Scripting to Work
Cube Security
This Year to Last Year Comparisons and Year-to-Date Rollups
Extracting Data from Cubes
Chapter 12 Pulling It Out and Building It Up-MDX Queries
The MDX SELECT Statement
The Basic MDX SELECT Statement
Additional Tools for Querying
Additional Dimensions
Additional MDX Syntax
Operators
Functions
Can You Dig It?
Part IV Mining
Chapter 13 Panning for Gold-Introduction to Data Mining
What Is Data Mining?
Order from Chaos
Tasks Accomplished by Data Mining
Steps for Data Mining
Data Mining Algorithms
Microsoft Decision Trees
Microsoft Linear Regression
Microsoft Naïve Bayes
Microsoft Clustering
Microsoft Association Rules
Microsoft Sequence Clustering
Microsoft Time Series
Microsoft Neural Network
Microsoft Logistic Regression Algorithm
Grab a Pick Axe
Chapter 14 Building the Mine-Working with the Data Mining Model
Data Mining Structure
Data Columns
Data Mining Model
Training Data Set
Mining Model Viewer
Microsoft Decision Trees
Microsoft Naïve Bayes
Microsoft Clustering
Microsoft Neural Network
Microsoft Association Rules
Microsoft Sequence Clustering
Microsoft Time Series
Reading the Tea Leaves
Chapter 15 Spelunking-Exploration Using Data Mining
Mining Accuracy Chart
Column Mapping
Lift Chart
Profit Chart
Classification Matrix
Cross Validation
Mining Model Prediction
A Singleton Query
A Prediction Join Query
Data Mining Extensions
Prediction Query Syntax
Types of Prediction Queries
Special Delivery
Part V Delivering
Chapter 16 On Report-Delivering Business Intelligence with Reporting Services
Reporting Services
Report Structure
Report Delivery
Report Serving Architecture
Report Server
The Parts of the Whole
Reporting Services Installation Considerations
Creating Reports Using the Tablix Data Region
A Tablix Data Region Created with the Table Template
A Tablix Data Region Created with the Matrix Template
A Tablix Data Region Created with the List Template
The Chart Data Region
The Gauge Data Region
Get Me the Manager
Chapter 17 Falling into Place-Managing Reporting Services Reports
Report Manager
Folders
The Report Manager
Deploying Reports Using the Report Designer
Uploading Reports Using Report Manager
Printing from Report Manager
Managing Reports on the Report Server
Security
Linked Reports
Report Caching
Execution Snapshots
Report History
Standard Subscriptions
Data-Driven Subscriptions
Ad Hoc Reporting
Report Model
Report Builder Basics
Putting It All Together
Chapter 18 Let's Get Together-Integrating OLAPwith Your Applications
ADOMD.NET
ADOMD.NET Structure
ADOMD.NET Example
Using Reporting Services Without the Report Manager
URL Access
Web Service Access
The Report Viewer Control
Ready-Made Solution
Chapter 19 Another Point of View-Excel Pivot Tablesand Pivot Charts
Excel
Creating Pivot Tables and Pivot Charts
Pivot Table
Pivot Chart
Great Capabilities, Great Opportunities
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken