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

Course Modality

Instructor-led training

Course Level

Intermediate

Course Time

2 Days

Course Language

English

Course Overview

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.

Prerequisites

Before attending this course, students must have:

- - Experience in developing analytical reports.

Intended Audience

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.

Job role: Developer

Features: none

Why The DataTech Labs ?

Self-Paced Online Video

A 360-degree learning approach that you can adapt to your learning style

A 360-degree learning

Engage and learn more with these live and highly-interactive classes alongside your peers

24/7 Teaching Assistance

24/7 Teaching Assistance Keep engaged with integrated teaching

Online Practice Labs

Projects provide you with sample work to show prospective employers.

Applied Projects

Real-world projects relevant to what you’re learning throughout the program

Learner Social Forums

A support team focused on helping you succeed alongside a peer community

Skill Covered

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.

Get In Touch

Course Curriculum

Module 1

Overview of Visualizations

Lessons

Goals of reporting
Types of reports
Audiences
Attack of the images

Lab : Overview of Visualizations

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

Module 3

Gauges

Lessons

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

Lab : Gauges

Module 4

Maps

Lessons

Spatial Data
Basic maps
Analyzing with color
Geography display
Color points

Lab: Maps

Reviews

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.