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

Type:Course
Audience(s):IT Professionals
Technology:Microsoft SQL Server
Level:200
This Revision:A
Delivery method:
Instructor-led (classroom)
Length:2 days
Language(s):English

First published:

30 September 2011
Overview
About this course
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.
At course completion
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.
Course details
Course OutlineModule 1: Overview of VisualizationsLessons
  • Goals of reporting
  • Types of reports
  • Audiences
  • Attack of the images
Lab : Overview of VisualizationsModule 2: ChartsLessons
  • 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 : ChartsModule 3: GaugesLessons
  • Matching gauges to the data
  • Variations of gauges
  • Selecting a gauge type
  • Linear gauges
  • Radial Gauges
Lab : GaugesModule 4: MapsLessons
  • Spatial Data
  • Basic maps
  • Analyzing with color
  • Geography display
  • Color points
Lab : Maps
Prerequisites
Before attending this course, students should have:
  • Experience in developing analytical reports.
Community

Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.

Preparing for an exam now? Find your Microsoft Certification Study Group.

Talk to us on these social networks:

Find a Microsoft Learning Partner near you