+44 20 3490 4211 | info@pradiconsulting.co.uk

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 Dashboads
  • 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

  • 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 Management Options

  • Report Manager Configurations
  • SSRS Report Builds and Deployment
  • Managing Data Source Security
  • Exporting and Importing Reports
  • Snapshot Management & Schedules
  • ReportServerTempdb 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