Data Visualizations with SSRS

About this Training

Microsoft SQL Server Reporting Services is a SQL Server component that facilitates the ability of building flexible, powerful reports. These reports can be delivered in a range of formats, and be presented using web or Windows-based applications.

In this course, you learn how to use the SSRS to extract business intelligence from your data, how to produce compelling reports with enhanced visualisation features, how to integrate parameters, filters and interactive components into reports, and also how to deploy these reports.

Audience Profile

This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for developing SSRS solutions.

Module 1 - Getting Started with SSRS

Creating new reports
Adding items to the report
Arranging items
Formatting items
Saving the report

Module 2 - Data Sources

Create a new datasource
map report to a dataset
create new table
embedded datasets

Module 3 - Controlling Header Rows

Making header rows appear in each page
Keeping header rows visible when scrolling

Module 4 - Numbers of Row per Page

Using RowNumber
Changing the page size
Creating groups
Changing the page size
Using parameters

Module 5 - Groups

Adding a parent group
Formatting
Nested Groups

Module 6 - Calculated Fields

Creating calculated fields
Conditional functions
Text function
Date functions
Concatenating text

Module 7 - Conditional Formatting

Using expressions to create conditions
Using IF and SWITCH

Module 8 - Gauges

Adding a Gauge to a table
Scales
Ranges and Pointers

Module 9 - SSRS Parameters

Parameter values
Drop down list parameters
Using nulls
Cascading parameters

Module 10 - SSRS Matrix

Create new matrix
Adding calculations
Adding sub groups

Contact Us

Latest courses

About Us

UpScale Analytics specializes in training solutions for organizations and individuals in the fields of data.

UpScale Analytics is also one of the largest platforms in the world for learning SQL by doing.

Data Visualizations with SSRS

About this Training

Audience Profile

Contact Us

Latest courses

About Us

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links