Skip to content
ictcLogo
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Menu
  • About
  • Training
  • Learning Paths
  • Training Center
  • News
  • Contact
Microsoft

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

  • Duration: 2 days
  • Job Role: Developer

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

Share This Learning Path

Need more info? Contact us

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

  • Experience in developing analytical reports.

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​

  • Search Paths

  • Vendors

Latest Learning Paths​

Microsoft

Course MB-920T00-A: Microsoft Dynamics 365 Fundamentals (ERP)

  • Dynamics-365
  • Beginner

Microsoft

Course PL-600T00-A: Power Platform Solution Architect

  • Power-Platform
  • Advanced

Microsoft

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

  • Windows
  • Advanced

Join our community of certified professionals

Sign Up to our newsletter, and stay always up to date with latest IT certifications

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

Facebook Linkedin

Learn

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

Explore

Contact Us

  • +30 211 500 29 00
  • info@ictc.gr
  • Lagoumitzi 24, Kallithea
ictcLogo

International Computer Training Center

  • Copyright reserved to ICTC
  • Proudly Crafted by GTP Works

Copyright reserved to ICTC. Proudly Crafted by GTP Works

Choose how to get more info...

Give as a call

211 500 2 900

Let us, call you

Send us an email