Visualizing Data with SQL 2008R2 and Report Builder 3.0

Register Now

Length: 2 days Fee: $1,050 Course #: 50550

Course Description

This instructor led course provides students with the knowledge and skills to add graphs, gauges and maps to reports developed utilizing SQL Server 2008 R2 reporting services. The development of these visualizations focuses on the use of Report Builder 3.0. This tool is targeted to power users and report developers and is the first of a new generation of Microsoft reporting tools that integrates the development of reports with visualizations.

Course Objectives:

Decide whether to use Business Intelligence Development Studio or Report Builder 3.0 to develop reports.
* Understand and be able to articulate the difference between classifications of graphs and which type of graph is best utilized and targeted to the type of data to be represented.
* Fully develop reports with graphics and understand the methodology of working with the end users in the development of these reports.
* Add gauges to reports and understand the variances between linear and radial gauges and the limitations of those gauges.
* Deploy reports that contain graphics.

Course Audience:

This course is designed to enhance the skills of those that are generating reports using SSRS by adding graphs, gauges and maps into those reports.

Course Outline:

Module 0: Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information. Lessons

· Introduction

· Course Materials

· Facilities

· Prerequisites

· What We'll Be Discussing

Module 1: Overview of Visualizations Lessons

· Goals of reporting

· Types of reports

· Audiences

· Attack of the images

Lab 1: Overview of Visualizations

· Using Business Intelligence Design Studio

· Using Report Builder 3.0

Module 2: Charts Lessons

· Matching the chart to the data

· Choosing a type of chart to display the dataNew SQL 2008 Charts

· Chart Properties

· Sparklines Databars and Indicators Advanced Techniques

· Formatting

Lab 2: Charts

· Create each of the major types

· Sparklines, Databars, Indicators

· Formatting

Module 3: Gauges Lessons

· Matching gauges to the data

· Variations of gauges

· Selecting a gauge type

· Linear gauges

· Radial Gauges

Lab 3: Gauges

· Linear Gauges

· Radial Gauges

· Multiple Gauges

Module 4: Maps Lessons

· Spatial Data

· Basic maps

· Analyzing with color

· Geography display

· Color points

Lab 4: Maps

· Mapping

· Bing Maps

· Properties

Register Now