SSRS Training

Course Overview

Micorsoft SQL Server Reporting Services Training or SSRS Training enables students to implement reporting services solutions to perform data analysis in an organization. This course discusses about creating reports using SSRS, build graphs, charts and other visualizations. You’ll become comfortable in building tables, lists, matrices, and deploying to SSRS server.

Highlights

10 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

4.6

4.5

4.6

4.7

SSRS Modes of Training

Self Paced Learning

30 Hrs of Pre-recorded videos
e-learning content

Life-time LMS Access

100% Practical Approach

Labs and Practicals included

Watch & Learn at your own pace

Online Classroom

30 Hrs of Instructor-Led Live Training

Doubts solving with Trainers

Upcoming Batches

23 Apr - 23 May

01:30 AM IST

Weekdays

27 Apr - 27 May

02:30 AM IST

Weekend

29 Apr - 29 May

02:30 AM IST

Weekdays

04 May - 04 Jun

02:30 AM IST

Weekday

Years EdTech experience

Freelance expert trainers

Career boosting courses

For Corporates

A customized learning experience for the global corporate workforce. A tailored approach to deliver a trending skillset.

Choose the learning mode that suits you:

Live online training
Self-paced training
On-premises offline training

Course customization to meet project needs.

Best in class trainers for latest and niche courses.

SSRS Course Content

SSRS INSTALLATION, CONFIGURATION

Need For Reporting Solutions (SSRS) and Tools
Reporting Engine Architecture and Report Databases
SSRS Installation, Tools and Database Configuration Process
SSRS 2016: Installation and Report Databases
SSRS 2014: Installation and Report Databases
Report Server URL - Purpose, Test Connection, Usage
Report Manager URL - Purpose, Test Connection, Usage
Report Portal URL in SSRS 2016 - Usage, Web Service
Three-Phase Report Life Cycle in Reports (End-End)
Report Server Database and Report TempDB Configuration
Virtual Directories (VD) in Web Services - Settings, Options
Communication Ports and Data Encryption For Web Portal URL
Report Design and Work Flow Diagram - Lab Plan, Data Sources
Report Design with Report Designer & Report Builder Tools
Report Builder Versus Report Designer - Basic Differences
SSDT (VS): SQL Server Data Tools Installation, Verification
SSDT 2015 and SSDT 2013 Installation, Test Connection
SSRS 2016 Report Portals and Accessibility

REPORT DESIGN - I

Working with Visual Studio - SQL Server Data Tools
Report Templates and Basic Usage. Project, Solution
Designing Basic Reports - Understanding Entities
Working with Report Project Wizard - Usage, Reports
Defining Data Source Connections, Source Databases
Query Designer Options, Query Builder & Import Options
Table Reports and Matrix Reports with Report Wizard
Layout and Format Options - Drilldown Reports, Blocks
Stepped Reports and Multi Field Drilldown Options
Report Project Template - Designing Dataset, Reports
Report Toolbox and ReportData Options, Textbox Usage
Table Headers, Formatting Options, MATH Expressions
Alternate Row Colors, Using Report Globals, Expressions
Report Formatting Styles, Expressions and Reusability
Reporting Functions: IIF, Format, Ceiling, Round, Concat
Alternate Row Colors and Dynamic Formatting Options
Textbox Properties - Date & Time Formats, Numbers, Styles
Report Timeout Options and Tool Box Options, Report Data
Initial Catalog For Report Sources, Static/Dynamic Properties

REPORT DESIGN - II

Grouping Operations: Row Groups, Column Groups
Table Report - Row Groups, Parent-Child Groups
Adding Groups to Existing Rows and New Rows
Group Headers and Group Footers - Usage, Sub Totals
Group Field Visibility and Toggle Options @ Parent
Row Group Properties, Header/Footer Properties
Column Groups for Table Reports, Advanced Options
Repeat-On-New-Page Options and Report Properties
Column Groups for Matrix Reports, Data Grouping
Drill-down Reports using Row Groups and Visibility
Drill-down Reports using Column Groups, Visibility
Table Reports Vs Matrix Reports - Technical Differences
Adding Images to Reports. Tooltip and Size Options
Report Headers and Report Footers - Globals, Expressions
Merging Report Fields, Sub Totals and Grand Totals
Group Edits, Removing Group Totals, Adding Group Headers
Column Groups - Advance Mode - Fixed Attributes, Fields
Repeating Header on Every Page & RepeatPage Options
Working with Report Globals for Metadata, Report Properties

REPORT DESIGN - III

Report Parameters - Purpose, Benefits, and Usage
Creating Parameters using Dataset Query Conditions
Creating Parameters using Report Properties, Report Data
Single Value Parameters and Multi-Value Parameters
Dynamic Parameter Values, Dependency Options, Queries
Defining Datasets with Parameters, Dynamic Conditions
Dataset Links to Parameters, Value Options from List, Query
Multi-Value Parameter Options: Data Types, Null, Empty Values
Reports using Multiple Data Sets. Performance Issues
Advanced Options: Auto Refresh, Manual Refresh Options
Dataset Filters, Toolbox Filters - Purpose, and Usage
Filters versus Parameters - Differences with Performance
Using Filter Condition at Dataset Level, Toolbox Level
Data Type Conversions with Filters, Expressions & Computations
Deciding Parameters and Filters - When to use which, why?
SSRS Expressions and Global Fields For Report Parameters
JOIN, FIELDS, LABEL and Formatting Options with Parameters
Linking Report Parameters to Dataset Parameters and Filters

REPORT DESIGN - IV

Chart Reports - Design Options, Properties, and Usage
Series Values Selection - with/without Category Groups
Report Categories with Series Groups - Differences, Usage
Data Visualization Types: Trend & Discrete Chart Reports
Clustered / NonClustered Legend Attributes. Position Options
Series Labels: Properties, Number Formatting Options, Visibility
Series Actions: Series Properties, Multi-Valued Parameters
Report Actions: URL / Reports, Setting for Report Filters
Axis Values - Possible Issues with Multiple Axis Items, Solutions
Dashboard Creations, Usage. Multiple Chart Areas, Legends
Dashboard Exports with Filters (Static, Parameterized)
Chart Series, Report Markers Chart Areas & Limitations
3-Dimensional Report Options - Properties, Visibility Options
Range & Pie Charts, Line Reports, Data Bars, Area Charts
Report Actions with Parameter Values - Report Filter Joins
Exploring Toolbox Filters with Type Conversions & Expressions
Using Shared DataSources and Shared DataSets - Advantages
Data Bar Reports and Sparkline Reports - Stacked Reports - Usage
Multi-series Charts, Dynamic Chart Size, Axis Display Control

Hands-on Projects

Complete
SSRS Projects

Practical oriented projects and use-cases will help you experience how the skills learned will solve real-time problems.

At least two projects.

Assisted lab setup to practice skills.

SSRS On-Job Support (Remote Work Support)

Tekslate
Remote-Job Assist service

The Tekslate On-Job Assist service is offered in partnership with Global Tech Community. The service provides Tech support for IT Professionals or Freshers to complete tasks.

We understand that every IT project has tedious and time-consuming tasks within deadlines. Tekslate has 100+ SMEs on various technologies, and they assist newbies, Freshers, or experienced professionals in completing challenging project tasks. Users can choose any of the following plans to meet their custom needs:

Pay Per Hour
Pay Per Week
Monthly

Earn a TekSlate SSRS Certification & Exam

Upon completion of the training you’ll be provided a course completion certificate which adds weightage to your resume and increases your chances of getting hired.

Benefits:

Certification Assistance

Certification Sample Questions

Course Overview

Highlights

SSRS Modes of Training

For Corporates