Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Reporting Services > Visualizing Data with SQL 2008 R2 and Report Builder 3.0 Training

Visualizing Data with SQL 2008 R2 and Report Builder 3.0 Training

Course#: 50555

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.

What you will learn

After completing this course, students will be able to:

  • 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.

Prerequisites

Before attending this course, students should have:

  • Experience in developing analytical reports.

Duration

2 Days

Outline of 50555 Visualizing Data with SQL 2008 R2 and Report Builder 3.0 Training

Module 1: Overview of Visualizations

Lessons

  • Goals of reporting
  • Types of reports
  • Audiences
  • Attack of the images

Lab : 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 data New SQL 2008 Charts
  • Chart Properties
  • Sparklines Databars and Indicators Advanced Techniques
  • Formatting

Lab : 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 : Gauges

  • Linear Gauges
  • Radial Gauges
  • Multiple Gauges

Module 4: Maps

Lessons

  • Spatial Data
  • Basic maps
  • Analyzing with color
  • Geography display
  • Color points

Lab : Maps

  • Mapping
  • Bing Maps
  • Properties
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.