SSRS online Training

 >>  SSRS online Training

SSRS online Training


 (5) | 750 Ratings


Introduction


SSRS online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 25 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Introduction To SSRS & Usage

  • SSRS Architecture and Tools
  • Three-Phase Report Life Cycle
  • Reporting Services Configurations
  • Report Server Database and TempDB
  • SSRS 2012 and Web Service URLs
  • SSRS 2014 and Web Service URLs
  • Communication Ports & Encryptions
  • Execution Accounts and Usage
  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • RSCONFIG Tool and Limitations

Report Planning And Design

  • SSRS Report Authoring Options
  • Data Sources (RDS) Connections
  • Credentials and Security Options
  • Toolbox Items and Dataset Options
  • Table Reports and Matrix Reports
  • Report Images, Textbox and Globals
  • Dynamic Expressions and Options
  • Reporting Functions and Formatting
  • Report Headers and Report Footers
  • Enterprise and Ad-hoc Reports

Report DataSets And Joins

  • Working with Multiple DataSets
  • Joining Local and Shared Datasets
  • Configuring Dynamic DataSets
  • Working with Remote Datasets
  • Reusing XML and Shared Datasets
  • Dataset Import Options in RDL
  • LOOKUP Functions – Limitations
  • Sub-Reports and Report Actions
  • Joining Rectangle & List Reports

Report Design And SubReports

  • Designing Wizard based Reports
  • Custom Reports and Report Groups
  • Row Drilldown and Column Grouping
  • Advanced and Static Options in SSRS
  • Chart Based Reports and Images
  • Using SSRS Expressions & Globals
  • Accessing and Controlling Reports

Report Parameters & Usage

  • Report Parameters & Properties
  • Dynamic Report Parameters and Filters
  • Dependent Parameters & Usage
  • Multi-Valued Nullable Parameters
  • Report Filters – Options and Types
  • Toolbox Filters and Limitations
  • Sub-Reports and Report Actions
  • Parent-Child Report Parameters

Enterprise Reports In SSRS

  • Gauge Reports, Indicator Reports
  • Pie Charts, Bars and Spark Lines
  • Report Testing and Auto Refresh
  • Map Reports and Report Dashboards
  • Multiple Chart Areas in Dashboards
  • Report Dashboard & Limitations
  • Report Scorecards with SQL Queries
  • Exporting RDL Reports in SSRS

Map Reports And Cube Reports

  • Map Reports and Stored Procedures
  • Indicators with Map Reports
  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries with Cube Reports
  • MDX Filters with Sub-Reports
  • Scorecards with MDX and DAX
  • Sub-Reports versus Report Actions
  • Accessing and Controlling Reports

Report Builder & Power View

  • Designing DataSets in Report Builder
  • Chart and Map Wizard in Report Builder
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Publishing Report Parts with RB
  • Stored Procedures with Report Builder
  • Report Downloads and Edit Options
  • Power Pivot & PowerView Addins
  • Power View for RDLX Reports
  • Understanding Data Models
  • Tables, Charts and Data Bars
  • SparkLines and Data-Mashup
  • Report Builder Vs PowerView

Report Management Options

  • Report Manager Configurations
  • SSRS Report Builds and Deployment
  • Managing Data Source Security
  • Exporting and Importing Reports
  • Snapshot Management & Schedules
  • ReportServer Tempdb Usage & Tuning
  • Linked Reports & Null Parameters
  • Report Caching and Memory Refresh
  • Managing Reporting Engine & Tuning
  • Report Execution Audits & Events
  • Tuning SSRS Reports & Memory Options

Subscriptions and Report Builder

  • Global and Shared Schedules
  • Report Subscriptions and Advantages
  • Email and Fileshare Subscriptions
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Data Source Credential Store Options
  • Subscription & Logging Options
  • Report Uploads and Downloads
  • Report Parts and Sub Reports
  • Report Sites and Parameter Options
  • Report Builder Connections & Caching
  • Report Builder Reports to RDL Entries

Report Security And Upgrades

  • Data Source Security Credentials
  • Report Server Security Levels
  • Security Options and Report Users
  • Content Manager and My Reports
  • Cloning Report Roles and Schedules
  • Report Browser and Report Publisher
  • Report (RDL) Configuration Options
  • Managing Configurations Files
  • RSConfig & Encryption (snk) Keys
  • SSRS Reports Upgradations
  • Scale-out Deployments in SSRS

Power View With SSRS

  • Managing RDL and RDLX Reports
  • Comparing PowerView and Report Builder
  • Drillthrough Report Management Options
  • Migrating Reports with SSRS and Excel

Practice Test & Interview Questions

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Introduction To SSRS & Usage

  • SSRS Architecture and Tools
  • Three-Phase Report Life Cycle
  • Reporting Services Configurations
  • Report Server Database and TempDB
  • SSRS 2012 and Web Service URLs
  • SSRS 2014 and Web Service URLs
  • Communication Ports & Encryptions
  • Execution Accounts and Usage
  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • RSCONFIG Tool and Limitations

Report Planning And Design

  • SSRS Report Authoring Options
  • Data Sources (RDS) Connections
  • Credentials and Security Options
  • Toolbox Items and Dataset Options
  • Table Reports and Matrix Reports
  • Report Images, Textbox and Globals
  • Dynamic Expressions and Options
  • Reporting Functions and Formatting
  • Report Headers and Report Footers
  • Enterprise and Ad-hoc Reports

Report DataSets And Joins

  • Working with Multiple DataSets
  • Joining Local and Shared Datasets
  • Configuring Dynamic DataSets
  • Working with Remote Datasets
  • Reusing XML and Shared Datasets
  • Dataset Import Options in RDL
  • LOOKUP Functions – Limitations
  • Sub-Reports and Report Actions
  • Joining Rectangle & List Reports

Report Design And SubReports

  • Designing Wizard based Reports
  • Custom Reports and Report Groups
  • Row Drilldown and Column Grouping
  • Advanced and Static Options in SSRS
  • Chart Based Reports and Images
  • Using SSRS Expressions & Globals
  • Accessing and Controlling Reports

Report Parameters & Usage

  • Report Parameters & Properties
  • Dynamic Report Parameters and Filters
  • Dependent Parameters & Usage
  • Multi-Valued Nullable Parameters
  • Report Filters – Options and Types
  • Toolbox Filters and Limitations
  • Sub-Reports and Report Actions
  • Parent-Child Report Parameters

Enterprise Reports In SSRS

  • Gauge Reports, Indicator Reports
  • Pie Charts, Bars and Spark Lines
  • Report Testing and Auto Refresh
  • Map Reports and Report Dashboards
  • Multiple Chart Areas in Dashboards
  • Report Dashboard & Limitations
  • Report Scorecards with SQL Queries
  • Exporting RDL Reports in SSRS

Map Reports And Cube Reports

  • Map Reports and Stored Procedures
  • Indicators with Map Reports
  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries with Cube Reports
  • MDX Filters with Sub-Reports
  • Scorecards with MDX and DAX
  • Sub-Reports versus Report Actions
  • Accessing and Controlling Reports

Report Builder & Power View

  • Designing DataSets in Report Builder
  • Chart and Map Wizard in Report Builder
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Publishing Report Parts with RB
  • Stored Procedures with Report Builder
  • Report Downloads and Edit Options
  • Power Pivot & PowerView Addins
  • Power View for RDLX Reports
  • Understanding Data Models
  • Tables, Charts and Data Bars
  • SparkLines and Data-Mashup
  • Report Builder Vs PowerView

Report Management Options

  • Report Manager Configurations
  • SSRS Report Builds and Deployment
  • Managing Data Source Security
  • Exporting and Importing Reports
  • Snapshot Management & Schedules
  • ReportServer Tempdb Usage & Tuning
  • Linked Reports & Null Parameters
  • Report Caching and Memory Refresh
  • Managing Reporting Engine & Tuning
  • Report Execution Audits & Events
  • Tuning SSRS Reports & Memory Options

Subscriptions and Report Builder

  • Global and Shared Schedules
  • Report Subscriptions and Advantages
  • Email and Fileshare Subscriptions
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Data Source Credential Store Options
  • Subscription & Logging Options
  • Report Uploads and Downloads
  • Report Parts and Sub Reports
  • Report Sites and Parameter Options
  • Report Builder Connections & Caching
  • Report Builder Reports to RDL Entries

Report Security And Upgrades

  • Data Source Security Credentials
  • Report Server Security Levels
  • Security Options and Report Users
  • Content Manager and My Reports
  • Cloning Report Roles and Schedules
  • Report Browser and Report Publisher
  • Report (RDL) Configuration Options
  • Managing Configurations Files
  • RSConfig & Encryption (snk) Keys
  • SSRS Reports Upgradations
  • Scale-out Deployments in SSRS

Power View With SSRS

  • Managing RDL and RDLX Reports
  • Comparing PowerView and Report Builder
  • Drillthrough Report Management Options
  • Migrating Reports with SSRS and Excel

Practice Test & Interview Questions

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry