Smart business intelligence solutions with Microsoft SQL Server 2008 / Lynn Langit ... [et al.].

Format:

Book

Author/Creator:

Kevin S. Goff Lynn Langit Davide Mauri, Sahil, author.

Contributor:

Langit, Lynn.

Language:

English

Subjects (All):

SQL server.

Relational databases.

Client/server computing.

Business intelligence.

OLAP technology.

Physical Description:

1 online resource (1 v. (unpaged) ) ill. ;

Edition:

1st edition

Place of Publication:

Redmond, Wash. : Microsoft Press, c2009.

System Details:

text file

Summary:

Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it. Discover how to: Manage the development life cycle and build a BI team Dig into SQL Server Analysis Services, Integration Services, and Reporting Services Navigate the Business Intelligence Development Studio (BIDS) Write queries that rank, sort, and drill down on sales data Develop extract, transform, and load (ETL) solutions Add a source code control system Help secure packages for deployment via encryption and credentials Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models Create and implement custom objects using .NET code View reports in Microsoft Office Excel and Office SharePoint Serverook

Contents:

Cover

Copyright page

Dedication

Contents at a Glance

Table of Contents

Foreword

Acknowledgments

Lynn Langit

Davide Mauri

Sahil Malik

Introduction

Who This Book Is For

What This Book Is About

Part I, "Business Intelligence for Business Decision Makers and Architects"

Part II, "Microsoft SQL Server 2008 Analysis Services for Developers"

Part III, "Microsoft SQL Server 2008 Integration Services for Developers"

Part IV, "Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence"

Prerelease Software

Hardware and Software Requirements

Find Additional Content Online

Support for This Book

Questions and Comments

Part I: Business Intelligence for Business Decision Makers and Architects

Chapter 1: Business Intelligence Basics

Business Intelligence and Data Modeling

OLTP and OLAP

Online Transactional Processing

Online Analytical Processing

Common BI Terminology

Data Warehouses

Data Marts

Cubes

Decision Support Systems

Data Mining Systems

Extract, Transform, and Load Systems

Report Processing Systems

Key Performance Indicators

Core Components of a Microsoft BI Solution

SQL Server 2008 Analysis Services

SQL Server 2008 Reporting Services

SQL Server 2008

SQL Server 2008 Integration Services

Optional Components of a Microsoft BI Solution

Query Languages used in BI Solutions

MDX

DMX

XMLA

RDL

Summary

Chapter 2: Visualizing Business Intelligence Results

Matching Business Cases to BI Solutions

Top 10 BI Scoping Questions

Components of BI Solutions

Understanding Business Intelligence from a User's Perspective

Demonstrating the Power of BI Using Excel 2007

Understanding Data Mining via the Excel Add-ins

Viewing Data Mining Structures Using Excel 2007.

Elements of a Complete BI Solution

Reporting-Deciding Who Will Use the Solution

ETL-Getting the Solution Implemented

Data Mining-Don't Leave It Out

Common Business Challenges and BI Solutions

Measuring the ROI of BI Solutions

Chapter 3: Building Effective Business Intelligence Processes

Software Development Life Cycle for BI Projects

Microsoft Solutions Framework

Microsoft Solutions Framework for Agile Software Development

Applying MSF to BI Projects

Phases and Deliverables in the Microsoft Solutions Framework

Skills Necessary for BI Projects

Required Skills

Optional Skills

Forming Your Team

Roles and Responsibilities Needed When Working with MSF

Chapter 4: Physical Architecture in Business Intelligence Solutions

Planning for Physical Infrastructure Change

Creating Accurate Baseline Surveys

Assessing Current Service Level Agreements

Determining the Optimal Number and Placement of Servers

Considerations for Physical Servers

Considerations for Logical Servers and Services

Understanding Security Requirements

Security Requirements for BI Solutions

Backup and Restore

Backing Up SSAS

Backing Up SSIS

Backing Up SSRS

Auditing and Compliance

Auditing Features in SQL Server 2008

Source Control

Chapter 5: Logical OLAP Design Concepts for Architects

Designing Basic OLAP Cubes

Star Schemas

Denormalization

Back to the Star

Other Design Tips

Modeling Snowflake Dimensions

More About Dimensional Modeling

Understanding Fact (Measure) Modeling

Other Considerations in BI Modeling

Part II: Microsoft SQL Server 2008 Analysis Services for Developers

Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler

Core Tools in SQL Server Analysis Services

Baseline Service Configuration.

SSAS in SSMS

How Do You Query SSAS Objects?

Using MDX Templates

Using DMX Templates

Using XMLA Templates

Closing Thoughts on SSMS

Chapter 7: Designing OLAP Cubes Using BIDS

Using BIDS

Offline and Online Modes

Working in Solution Explorer

Data Sources in Analysis Services

Data Source Views

Roles in Analysis Services

Using Compiled Assemblies with Analysis Services Objects

Building OLAP Cubes in BIDS

Examining the Sample Cube in Adventure Works

Understanding Dimensions

Attribute Hierarchies

Attribute Relationships

Translations

Using Dimensions

Measure Groups

Beyond Star Dimensions

Building Your First OLAP Cube

Selecting Measure Groups

Adding Dimensions

Chapter 8: Refining Cubes and Dimensions

Refining Your First OLAP Cube

Translations and Perspectives

Actions

Calculations (MDX Scripts or Calculated Members)

Using Cube and Dimension Properties

Time Intelligence

SCOPE Keyword

Account Intelligence and Unary Operator Definitions

Other Wizard Options

Currency Conversions

Advanced Cube and Dimension Properties

Chapter 9: Processing Cubes and Dimensions

Building, Processing, and Deploying OLAP Cubes

Differentiating Data and Metadata

Working in a Disconnected Environment

Working in a Connected Environment

Understanding Aggregations

Partitioning

Choosing Storage Modes: MOLAP, HOLAP, and ROLAP

OLTP Table Partitioning

Other OLAP Partition Configurations

Implementing Aggregations

Aggregation Design Wizard

Usage-Based Optimization Wizard

SQL Server Profiler

Aggregation Designer: Advanced View

Implementing Advanced Storage with MOLAP, HOLAP, or ROLAP

Proactive Caching

Notification Settings for Proactive Caching.

Fine-Tuning Proactive Caching

ROLAP Dimensions

Linking

Writeback

Cube and Dimension Processing Options

Chapter 10: Introduction to MDX

The Importance of MDX

Writing Your First MDX Queries

MDX Object Names

Other Elements of MDX Syntax

MDX Core Functions

Filtering MDX Result Sets

Calculated Members and Named Sets

Creating Objects by Using Scripts

The TopCount Function

Rank Function and Combinations

Head and Tail Functions

Hierarchical Functions in MDX

Date Functions

Using Aggregation with Date Functions

About Query Optimization

Chapter 11: Advanced MDX

Querying Dimension Properties

Looking at Date Dimensions and MDX Seasonality

Creating Permanent Calculated Members

Creating Permanent Calculated Members in BIDS

Creating Calculated Members Using MDX Scripts

Using IIf

About Named Sets

About Scripts

Understanding SOLVE_ORDER

Creating Key Performance Indicators

Creating KPIs Programmatically

Additional Tips on KPIs

Using MDX with SSrS and PerformancePoint Server

Using MDX with SSRS 2008

Using MDX with PerformancePoint Server 2007

Chapter 12: Understanding Data Mining Structures

Reviewing Business Scenarios

Categories of Data Mining Algorithms

Working in the BiDS Data Mining Interface

Understanding Data Types and Content Types

Setting Advanced Data Properties

Choosing a Data Mining Model

Picking the Best Mining Model Viewer

Mining Accuracy Charts and Prediction

Data Mining Algorithms

Microsoft Naïve Bayes

Microsoft Decision Trees Algorithm

Microsoft Linear Regression Algorithm

Microsoft Time Series Algorithm

Microsoft Clustering Algorithm

Microsoft Sequence Clustering

Microsoft Association Algorithm

Microsoft Neural Network Algorithm

Microsoft Logistic Regression.

The Art of Data Mining

Chapter 13: Implementing Data Mining Structures

Implementing the CRISP-DM Life Cycle Model

Building Data Mining Structures Using BIDS

Adding Data Mining Models Using BIDS

Processing Mining Models

Validating Mining Models

Lift Charts

Profit Charts

Classification Matrix

Cross Validation

Data Mining Prediction Queries

DMX Prediction Queries

DMX Prediction Functions

Data Mining and Integration Services

Data Mining Object Processing

Data Mining Clients

Part III: Microsoft SQL Server 2008 Integration Services for Developers

Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services

Overview of Integration Services Architecture

Integration Services Packages

Tools and Utilities for Developing, Deploying, and Executing Integration Services Packages

The Integration Services Object Model and Components

Control Flow

Data Flow

Variables

Expressions

Connection Managers

Event Handlers and Error Handling

The Integration Services Runtime

The Integration Services Data Flow Engine

Data Flow Buffers

Synchronous Data Flow Outputs

Asynchronous Data Flow Outputs

Log Providers

Deploying Integration Services Packages

Package Configurations

Package Deployment Options

Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio

Integration Services in Visual Studio 2008

Creating New SSIS Projects with the Integration Services Project Template

Viewing an SSIS Project in Solution Explorer

Using the SSIS Package Designers

Working with the SSIS Toolbox

Choosing from the SSIS Menu

Standard Database Connection Managers

Other Types of Connection Managers

Control Flow.

Control Flow Tasks.

Notes:

Includes index.

Title from resource description page.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735636446

0735636443

9780735638341

0735638349

OCLC:

457242725