Microsoft® SQL Server 2008 R2 Analytics & Data Visualization

Home >
Browse >
Microsoft® SQL Server 2008 R2 Analytics & Data Visualization

Microsoft® SQL Server 2008 R2 Analytics & Data Visualization

Authors: Doug Harts, Jim Dugan and Tricia Almas

Published: September 2010

eISBN: 9780071643603 0071643605 | ISBN: 9780071601436

Contents

Foreword

Acknowledgments

Introduction

Chapter 1 Charts in SQL Server Reporting Services 2008

Determining the Appropriate Chart for the Type of Data Being Displayed

Choosing a Chart Type

New Graph Types and Features Available in SSRS 2008

New Reporting Services 2008 R2 Chart Features

What to Watch Out for When Upgrading from SSRS 2005

Step-by-Step Creation of an SSRS Chart Report Using the Report Designer

The Query Designer Toolbar

Adding a Chart to a Report

In-Depth Examination of Chart Properties

Using Visibility Properties to Enhance the Report

Set the Report Header and Footer

Sparkline Reports

Basic Report Types and Examples

Report Parameters

Advanced Topics, Including Calculated Fields, Visibility Expressions, and Combination Charts

Examples of Calculated Series

Adding Strip Lines, aka Interlacing

Range Chart Types and Examples

Shape Charts: Pyramids, Funnels, Pies, Doughnuts, Collected Pie

Handling Missing Data and Statistical Formula Support

Line Charts, Special Charts, and More on Calculated Series

Area, Polar, and Radar Charts

Multiple Chart Areas and Series Groupings

Formatting Charts for Presentation

Differences Between Dundas Controls and Native Microsoft Charts

Wrap-Up

Chapter 2 Gauges in SQL Server Reporting Services 2008

Determining the Appropriate Gauge for the Type of Data Being Displayed

Report Creation Tools in SQL Server 2008

Creating an SSRS Report Designer Report

SSRS Report Manager and the Report Builder 3.0 Interface

Selecting a Gauge Type

Creating the Bullet Graph Gauge

Setting the Pointer Properties

Bullet Graph Gauge Summary

Linear Gauge Varieties

Gauge Labels

Scale Number Formatting

Gauge Scale Pins

Radial Gauge Details

Create a Radial Gauge

Adding Scale Ranges to Radial Gauges

Setting the Gauge Frame Properties

Gauge Pointers and Formulas for Data Display

Interesting Component Behaviors

The Gauge Panel and Multiple Gauge Items

Putting Multiple Gauges into the Gauge Panel

Using Gauges in Reports and Dashboards

Adding a Gauge to the Sparkline Report

Wrap-Up

Chapter 3 SQL Server 2008 R2 Map Reports

Report Builder Maps: A New Feature with SQL Server Reporting Services

Designing a Basic U.S. Map from Report Builder Spatial Data

Adding Analytical Color to the Map Report

Fixing Some Common Map Report Data Source Errors

Modifying the Map Geography Display Elements

Adding Color Points to the Map Report

Designing a Simple World Map from SQL Server Spatial Data

Modifying the Map Geography Viewport

Adding Charts to the Map Report

Adding a Tooltip and Custom Point with Action to the Map Report

Wrap-Up

Chapter 4 Data Visualization Delivery

Consuming Visualizations

SQL Server Report Manager Overview

BIDS Report Deployment

Report Manager Object Types

Rendering Reports in Report Manager

Adding a Reporting Services Report to a SharePoint Page

Linked Report Explorer and Report Viewer Web Parts

Individual Report Viewer Web Part

Microsoft Office SharePoint Server 2007: Reporting Services Integrated Mode

Creating Dashboard Pages

Create a New Dashboard Page in the Reports Library

Create a New Web Part Page

Page Filters in SharePoint

PerformancePoint Server 2007

Creating a New Dashboard

Previewing and Publishing a PerformancePoint Dashboard

Publishing Dashboards to SharePoint

PerformancePoint Strategy Maps and Custom Indicators for Diagram Display

Using PerformancePoint Dashboard Items as SharePoint Web Parts

Putting It All Together: Using Charts and Gauges in Information Delivery

Best Practices and Special Tips for Intelligent Business Information Delivery

Wrap-Up

Chapter 5 Microsoft and the Cloud

So What Is the Cloud?

Software as a Service

Office Web Applications

BPOS (Business Productivity Online Standard Suite)

Platform as a Service: The Windows Azure Platform

Windows Azure

SQL Azure

Using Report Builder

Windows Azure Platform AppFabric

Project Dallas

Infrastructure as a Service

Wrap-Up

Chapter 6 Data Mining: Real-World Techniques

So What Is Data Mining Anyway?

So Where Can You Use Data Mining?

First Steps First: What Is the Data Mining Add-In?

Where Is the Excel Data Mining Add-In Available From?

Installing the Excel Data Mining Add-In

Why Don’t I Notice Anything Different?

Add-In: Analyze Key Influencers

Add-In Detecting Categories

Add-In Prediction Calculator

Add-In Fill from Example

Add-In Shopping Basket Analysis

Add-In Forecasting

Extended Data Mining Add-In

Extended Add-In Forecasting

Extended Add-In Explore Data

Extended Add-In Data Preparation

Extended Add-In Clustering Tool

Extended Add-In Browsing a Model

The Visio Add-In Tool

Wrap-Up

Chapter 7 Microsoft PowerPivot

Why Do We Need This Tool?

So What Is Powerpivot?

A Couple of New Things in Excel 2010 (PivotTables, Slicers, and Sparklines)

So Why Can’t We Just Do This in Excel?

So How Is PowerPivot Different?

Installing the PowerPivot Add-in

Using the PowerPivot Add-in with Sample Data

Loading the Text Files

Joining the Tables

The PowerPivot Home Ribbon

The Design Ribbon

Adding a Slicer

Customizing the Chart

Enhancing Charting with PowerPivot

Changing PivotTable Options

Placing Slicers

Sharing PowerPivot

Extending PowerPivot with DAX

What Is DAX?

Where Would We Use DAX?

Wrap-Up

Chapter 8 SQL Server 2008 R2 Analytic Design Techniques

Report Builder Elements: An Overview of Matrix, Chart, and Map Objects with SQL Server Reporting Services

Creating an OLAP Data Source for Our Model Report

What Is an OLAP Cube?

Continuing with the Data Source and Datasets

Creating a Matrix for Our Model Report

Creating a Chart for Our Model Report

Creating a Map for Our Model Report

Creating a Gauge for Our Model Report

Creating a Parameter Dataset for Our Model Report

Creating a Parameter for Our Model Report

Adding the Parameter to the Dataset for Our Model Report

Model Report First Draft and Changes

Naming Conventions

Modifying the Display Elements for the Model Report

Modifying the Data Display for the Model Report

Report Element Display and Position Changes to the Model Report

Formatting Report Objects

Color Adjustment of the Report Objects

Wrap-Up

Index