SSRS Training in pune

SSRS

Overview:

Reporting Services is a server-based reporting platform that provides a full range of ready-to-use tools and services to help people throughout your organization create, deploy, manage, and use reports quickly and easily. With Reporting Services, you can retrieve data from relational, multidimensional, and XML-based data sources; publish reports that can be viewed in various formats; and centrally manage report security and subscriptions. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application.

Course Objectives:

  • To gain understanding of how to develop, format and manage
  • To understand the Complete SSRS
  • To create reports using Wizard, Report Designer and Report
  • To understand and use different report items like Table, Matrix, List, Image, Textbox, Line
  • To enhance the report with formatting Grouping and summarizing the
  • To understand and use Data visualization items like Chart, Gauge, Sparkline, Data bar
  • To use expression, Collections, Global
  • To use single valued, Multi-valued, cascading
  • To use sub report and Dill down report, Drill through
  • To use interactive Sorting, Document map, Custom
  • To Deploy, publish the reports and configure report server and report manager Url and Report server database.
  • To work with report Manager for managing folders, Configuring Data Source, Data set properties and Security.
  • To learn Caching, Report snapshot, Report history, Site setting, Subscription, Report

Pre-requisite / Target Audience: Before opting this course the student should have general familiarity with relational database concepts and writing basic SQL SELECT statement.

SSRS Syllabus

Module 1:- SSRS Introduction

In this module, you will learn about Importance of Reporting Solutions, Overview of Reporting Service and Reporting Life Cycle. How to use report server. How to Install Reporting Services and what are Reporting Services Components that

  • What is SSRS
  • Why SSRS
  • Advantages of SSRS
  • What are the different Report Access Types
  • General Reporting Life Cycle
  • SSRS Life Cycle
  • What is Report Server Database
  • What is Report Designer and How to design Report
  • What is Report Builder and How to use
  • What is Report Server
  • How to Work with Report Server Configuration
  • Report Builder Vs Report Designer

Module 2:- Creating Reports

In this chapter, you will learn about how to create your first report. How to work with SQL Server Data Tools  (SSDT) to create a data connection (data source), define a simple query (dataset), and configure a data region to contain your data that

  • Steps for Creating Report Project
  • What is Data Source
  • How to give Connection to the Data base
  • What is Data Set and Data Set Fields
  • How to Create Reports using Wizards
  • How to generate Table and Matrix Reports

Module 3:- Working with Tablix

In this module, you will get knowledge on Tablix, how to use Tablix and Expressions, what is drill down report and drill through report. How to add header, footer section, how to add images to reports and how to create matrix that

  • What is Tablix
  • How to use Tablix
  • Tablix Contain what
  • What is Table and Matrix
  • How to Add Image and taking action on image click in Table
  • How to Add Rectangle, Line in Table
  • What is Expression and How to use Expression
  • How to Add Table, Footer row
  • How Add textbox, Align text in textbox
  • What is Grouping and Drill Down in Table
  • How to Create Row Groups and Column Groups in Matrix
  • How to add subtotal for Column and Row Groups
  • What is List
  • Advantages of using List
  • Difference Between List, Table and Matrix

Module 4:-Working with Parameter

In this module, you will learn about the Parameters in SSRS, how to use parameters, advantages of parameters and different types of parameters in SSRS. How to filter the data and how to create sub reports. How to create drill through report that

  • What is Parameter in SSRS and How to use Parameter
  • What are the Different types of Parameters Present in SSRS
  • What is single valued static parameter and how to use in Reports
  • What is multi valued static parameter and how to use in Reports
  • How to use Dataset for Report parameter values
  • How to sort the data by using parameter
  • What is cascading parameter
  • How to filter the data by using parameter
  • What is Drill Through Report and sub Report
  • Difference between Drill Through Report and sub Report

Module 5:- Data Visualization

In this module, you will learn about data visualization. i.e, Charts, Data Bars and Sparkline etc. How the visualization will look with your data, and what kind of data works well in each visualization. How to create charts, data bars and Sparkline that

  • What is Chart
  • How to use Charts
  • Advantages of Charts
  • Different types of Sections in Chart
  • How to Create Chart Report
  • What is Data Bar
  • How to use Data Bar
  • Properties of Chart Report
  • Advantages of Data Bar
  • How to Creating Data Bar Report
  • What is Sparkline
  • Advantages of Sparkline
  • How to Sparkline Report
  • What is Gauge
  • Advantages of Gauge
  • What are the Different types of Gauge
  • How to Create Gauge Report
  • Charts Vs Gauge and Sparkline Vs Data Bars

Module 6:-Other Features

In this chapter you will learn about how to implement document map, how to do sorting, How to use page break and how to create templates for the Report. How to implement sorting and how to hide some pages if that is an another format that

  • What is interactive sorting
  • How to do interactive sorting
  • What is Document map
  • How to Create Document map
  • Advantages of Document map
  • How to add Unique group values to document map
  • How to add Report item to document map
  • What is Page Layout
  • How to set Fixed Header For Matrix
  • What is Soft Page Break
  • How to Insert Soft Page Break
  • What is Logical Page Break
  • How to Hide the page footer if Export Format in Excel or any other format
  • Advantages of custom functions
  • How to Create Template for the Report

Module 7:-Report Management

In this module, you will learn about Deployment, how many ways we can deploy the reports, execution of the reports. How to provide security to the report, how to give subscription and advantages of deployment. Configuring the data sources that

  • What is Deployment
  • Advantages of Deployment
  • How to Deploy all reports in Project
  • How to Deploy individual Reports
  • What is Report Manager
  • How to do Configuring the Data Source
  • What are the different types of properties in Data Source
  • How to publish the Report
  • How to deploy report using report manager
  • What are the Report Properties
  • What is Caching
  • What is Cache option
  • What is Cache Report Option
  • What is snapshot option
  • What is Report builder
  • What is Report Parts
  • What is Linked Report
  • What is Query Parameter
  • What is Subscription
  • Different types of Subscription
  • How to Create Standard Subscription
  • How to Create Data driven Subscription

At the end of the course participants will be able to:

  1. Create parameter reports.
  2. Create list
  3. Format reports with complex
  4. Add images and sub
  5. Add drilldown and drill through
  6. Add spark lines, data bars, and

Upcoming Batches Schedule

03rd SepRegular7.30 am To 9.30 am
08th SepWeekend10.30 am To 02.30pm
17th SepRegular7.30 am To 9.30 am
22nd SepWeekend10.30 am To 02.30pm
This table shows all the upcoming batches for the month of Septemer 2018.