SSRS Training

Rating(4.7) -
Enrolled -
120

Gain essential skills taught by industry experts with our custom tailored curriculum. Work on projects that add weightage to your resume and get job ready.

placement
banner

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

Key Highlights tekslate courses
10 Hrs Instructor Led Training
Key Highlights tekslate courses
Self-paced Videos
Key Highlights tekslate courses
20 Hrs Project & Exercises
Key Highlights tekslate courses
Certification
Key Highlights tekslate courses
Job Assistance
Key Highlights tekslate courses
Flexible Schedule
Key Highlights tekslate courses
Lifetime Free Upgrade
Key Highlights tekslate courses
Mentor Support
4.6
switch
4.5
trust
4.6
courserating
4.7
googlerating

SSRS Modes of Training

Self Paced Learning
greentick
30 Hrs of Pre-recorded videos
e-learning content
greentick
Life-time LMS Access
greentick
100% Practical Approach
greentick
Labs and Practicals included
greentick
Watch & Learn at your own pace
Online Classroom
greentick
30 Hrs of Instructor-Led Live Training
greentick
Doubts solving with Trainers
View More
Upcoming Batches

21 Apr - 21 May
01:30 AM IST
Weekend
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
+
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.

zealousys
consagous
codiant
appscrip

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
     
  • 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
     
  • 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 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
     
  • 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
     
Show More

Contact Us

By providing us with your details, We wont spam your inbox.

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.
projectlogo

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 completion certificate

    SSRS Course Objectives

    What are the SSRS training course objectives?

    By the end of SSRS training, you will be able to:

    • Use SSDT (SQL Server Data Tools) in detail for development of SSRS Project.
    • Gain an understanding of how to develop, format, and manage reports
    • Understand the Complete SSRS lifecycle
    • Create reports using Wizard, Report Designer, and Report Builder
    • Understand and use different report items like Table, Matrix, list, Image, Textbox, Line etc.
    • Enhance the report with formatting, grouping and summarizing the data
    • Understand and use data visualization items like Chart, Gauge, Sparkline, DataBar, etc.
    • Use expression, Collections, Global Collection
    • Use single-valued, multi-valued, cascading parameters
    • Use subreport and Drill down the report, Drill through the report
    • Use interactive sorting, document map, Custom function.
    • Deploy, publish the reports and configure report server and report manager Url and Report server database
    • Work with report Manager for managing folders, Configuring Data Source, Data Set properties, and Security
    • Learn to cache, report snapshot, report history, site setting, subscription, report part.
       

    Why should you learn SSRS course?

    • There are numerous job openings for SSRS professionals with high salary packages.
    • Top multinational companies are hiring certified SSRS professionals worldwide
    • The average salary of a certified SSRS professional is around $103.875 USD per annum.
       

    Who should attend SSRS training?

    • Business intelligence professionals
    • Analytics professionals 
    • Reporting professionals
    • Aspirants who are willing to build their career in the administrative field.
       

    What are the prerequisites for learning SSRS training?

    The following are the prerequisites for learning SSRS course:

    • Basics of RDBMS concepts with skills to write queries
    • Working experience on any RDBMS would be an added advantage.

    The following job roles will get benefited by taking up this course:

    • Analytics professionals 
    • Reporting professionals
       

    What projects are included in this SSRS training course?

    The tutor will take care of handling the projects. We will provide two real-time projects with a highly-skilled guide who can assist you throughout the project.
     

    SSRS Online Training Reviews

    The Trainer was a master of all the concepts in SSRS training. Great to learn at Tekslate!!

    link

    Nirosha

    4.5

    FAQs about SSRS Course

    Who are the trainers?

    We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth. 
     

    What if I miss a class?

    We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.
     

    How will I execute the practical?

    Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.
     

    Is this live training or pre-recorded videos training?

    We provide all the training sessions LIVE using either GoToMeeting or WebEx, thus promoting one-on-one trainer student Interaction.
     

    What is the difference between live online and pre-recorded videos training?

    Live training uncovers distinct benefits as they are mighty to reach your desired audience converting your prospects into customers in less time. Pre-recorded videos offer plenty of advantages for entrepreneurs to educate entertain and inspire your audience as long as you want.
     

    Authorized Partners

    TekSlate is an authorized learning and training partner the following tech giants to deliver skills and gain excellence in respective courses. Get the best out of TekSlate as we provide authentic learning resources and training from expert mentors to help you explore and enhance update your skills from the partner network.

    ranorexfinal
    Microsoftfinal
    EDBfinal
    Datadogfinal
    AWSfinal
    banner

    Relevant Microsoft Courses

    1/11

    Business Intelligence and Analytics Courses

    View All

    1/8