Course 50555-A: Visualizing Data with SQL 2008 R2 and Report Builder 3.0

Microsoft

Course 50555-A: Visualizing Data with SQL 2008 R2 and Report Builder 3.0

Share This Learning Path

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 reporting tools that integrates the development of reports with visualizations.

Audience Profile

Report developers, power users and those interested in visualizations in reporting. This course is designed to enhance the skills of those that are generating reports using SSRS by adding graphs, gauges and maps.

Prerequisites

Course outline

Module 1: Overview of Visualizations

Module Overview

In this module stdents will examine some of the considerations for reporting in general and for visualizations specifically.

Lessons

Goals of reporting
Types of reports
Audiences
Attack of the images

Lab Sessions

Overview of Visualizations

Lab Lessons

Using Business Intelligence Design Studio
Using Report Builder 3.0

After completing this module, students will be able to:

Decide whether to use Business Intelligence Development Studio or Report Builder 3.0 to develop reports.

Module 2: Charts

Module Overview

This module describes Charts.

Lessons

Matching the chart to the data
Choosing a type of chart to display the data New SQL 2008 Charts
Chart Properties
Sparklines Databars and Indicators Advanced Techniques
Formatting

Lab Sessions

Charts

Lab Lessons

Create each of the major types
Sparklines, Databars, Indicators
Formatting

After completing this module, students will be able to:

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.

Module 3: Gauges

Module Overview

This module describes Gauges.

Lessons

Matching gauges to the data
Variations of gauges
Selecting a gauge type
Linear gauges
Radial Gauges

Lab Sessions

Gauges

Lab Lessons

Linear Gauges
Radial Gauges
Multiple Gauges

After completing this module, students will be able to:

Add gauges to reports and understand the variances between linear and radial gauges and the limitations of those gauges.

Module 4: Maps

Module Overview

This module describes Maps.

Lessons

Spatial Data
Basic maps
Analyzing with color
Geography display
Color points

Lab Sessions

Maps

Lab Lessons

Mapping
Bing Maps
Properties

After completing this module, students will be able to:

Deploy reports that contain graphics.

Book Your Seat

Find Learning Paths

Course 20703-1-B: Administering System Center Configuration Manager

Join our community of certified professionals

About Us

ICTC is the leader in technical certification courses and exams. Our labs consist of a latest tech PCs and our instructors are certified from each vendor

Learn

View all the provided certifications and there relevant courses. Book online for a certification exam.

Contact Us

International Computer Training Center