Warning: DOMDocument::loadXML(): Start tag expected, '<' not found in Entity, line: 1 in /home/sitctrai/public_html/sqldbaonlinetraining/wp-content/plugins/premium-seo-pack/modules/title_meta_format/init.social.php on line 483
Contact Us :info@spectoittraining.com, India :+91-9533456356,USA :+1-847-787-7647

MSBI SSRS Online Training

MSBI SSRS Online Training Course Content

Introduction to SSRS & Usage

  • Need For Reporting Solutions
  • Data Sources and Data Stages

Reporting Services Architecture

  • Three-Phase Report Life Cycle
  • Reporting Engine Architecture
  • SSRS 2012 and Web Service URLs
  • SSRS 2014 and Web Service URLs
  • Communication Ports & Encryptions

Introduction to Report Tools

  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • RSCONFIG Tool and Limitations

Report Planning and Design

  • SSRS Report Planning
  • Data Sources & Options
  • Optimizing Data Sources
  • Dynamic Expressions and Options
  • Reporting Functions and Formatting
  • Images and Textbox
  • Report Headers and 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 based Datasets

Report Design and SubReports

  • Designing Wizard based Reports
  • Designing Custom Reports
  • Using Tables and Matrix
  • Chart Based Reports and Images
  • Using SSRS Expressions & Globals

Report Parameters & Usage

  • Parameters and Properties
  • Dynamic Parameters & Usage
  • Dependent Parameters & Usage
  • Multi-valued Null Parameters
  • Report Filters in Data Sets
  • Report Filters in Toolbox
  • Sub Reports and Parameters
  • Parent-Child Report Parameters

Enterprise Report Styles

  • Gauge Reports, Indicator Reports
  • Pie Charts and Data Bars
  • Rectangle and List Reports
  • Report Testing and auto Refresh
  • Map Reports and Dashboards
  • Report Scorecards with T-SQL
  • Exporting Reporting Data
  • LOOKUP Functions and Options

SSRS using OLAP Cubes

  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries in Cube Reports
  • Report Scorecards with MDX

Delivering SSRS Reports

  • Report Delivery Options & Schedules
  • Accessing and controlling reports
  • Leveraging RS Web services

Report Builder Reports

  • Using Report Builder Wizards
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Need for Report Parts
  • Publishing Report Parts
  • DataSets in Report Builder
  • SPs with Report Builder
  • Report Downloads and Edits

Managing Reports

  • Report Manager Configurations
  • Managing Data Sources Security
  • Exporting and Importing Reports
  • Creating Global Schedules
  • Snapshot Management & Schedules
  • ReportServerTempdb Usage
  • Managing Reporting Engine
  • System Events and Audits
  • Fine-Tuning SSRS Reports

SSRS Logging and Events

  • Benefit of SSRS Logging (Server)
  • SSRS 2012 Logging Options
  • Report Execution Audits & Events

Report Builder & Report Manager Options

  • Report Parts Options
  • Report Sites and Parameters
  • Report Builder Connections

Scheduling and Subscriptions

  • Creating Standard Subscriptions
  • Data-Driven Subscriptions
  • Subscription & Logging Options

SSRS Report Security

  • Report Data Source Security
  • Report Server Security Levels
  • Report Server DB Security

SSRS Configurations

  • Report (RDL) Configurations
  • Managing Configurations Files
  • Choosing correct Config Values

Report Server Upgrades

  • SSRS Reports Upgrades
  • SSRS Database Upgrades
  • Scale-out Deployments in SSRS