SSRS Training Videos from SQL School

SSRS Training Videos with Online Lab

On demand Training Videos accessible your comfortable timings. Our SSRS Video Training Service (Course Code: VC07) offers complete realtime practical knowledge transfer services for aspiring and working SQL BI / Report Developers. Study and Practice Material with Realtime Case Study, Free LIVE Server Access for online Lab are included in this course. Register for SSRS Video Training

Pre-requisites: Participant should have knowledge on SQL Server T-SQL Queries & Tuning to join this Real-time Practical SSRS Training Course.


SSRS Video Training - How it works?

Real-time, Practical Training Videos, accessible 24x7. Study, Practice Material and Lab Work for every video. Trainer available for doubts clarifications and support. Theory Material to be provided in Advance.

Type: 100% Practical & Example Based, Real-time
No. of Videos: 10 Videos (Duration: 80 mins per video)
Course Fee: INR 6000/- (USD 100) payable in 2 installments

This Video Course includes one Real-time Project. Download Brochure
Program Highlights & Trainer Profile

  • Completely Real-time and Practical
  • Video wise Lab Work and Tasks
  • One Real-time Case Study
  • Certifications & Interview Guidance
  • Interview FAQs & Resume Guidance
  • 24x7 LIVE Server with Lab, Support

Trainer: Mr Sai Phanindra T     Register Today !
 


Basic SSRS Development & Report Authoring Advanced SSRS Development & Deployments

SSRS VIDEO 1: SSRS INSTALLATION, CONFIGURATION

  • Need For Reporting Solutions (SSRS) and Tools
  • Reporting Engine Architecture & Databases
  • SSRS Installation & 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

SSRS VIDEO 2: REPORT DESIGN - I

  • 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 Formattig Options
  • Textbox Properties - Date & Time Formats, Numbers, Styles

SSRS VIDEO 3: REPORT DESIGN - II

  • 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, Visibility
  • Drill-down Reports using Column Groups, Visibility
  • Table Reports Vs Matrix Reorts - 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

SSRS VIDEO 4: REPORT DESIGN - III

  • 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, Dependancy 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

SSRS Video 5: Report Design - IV

  • Designing Chart Based Reports
  • Chart Series Properties and Options
  • Chart Legend - Properties and Placement
  • Chart Areas with Multiple Toolbox Items
  • Chart Area Properties & Limitations
  • Report Label Properties and Markers
  • Axis Titles and Labels, Grid Marks
  • Working with 3-Dimensional Reports
  • Pie Charts, Data Bars and Area Charts
  • Category Groups and Series Category Groups
  • Item Properties - Actions, Visibility & Options
  • Report Actions - Parameters, Limitations
  • Report Actions and Dynamic Parameters
  • Data Type Conversions in SSRS
  • Exploring Filters with Type Conversions
  • Common Report Errors and Solutions

Real-time Case Study

  • A real-world Report Requirement, Solution
  • Exploring Report Toolbox Items
  • Report Calcualations and Expressions

  • SSRS Video 6: Report Design - V

    • Gauge Reports - Purpose and Design
    • Gauge Report Types and Options
    • Scale and Pointer Specifications
    • Range Specifications, Width, Scale
    • Gauge Properties and Filters
    • Parameterized Gauge Reports (RB)
    • Indicator Reports - Purpose and Design
    • Working with Range and Indicator Filters
    • Indicators Value and States (Expressions)
    • Dynamic Report Options and Parameters
    • Working with SSAS Cube (MDX) Reports
    • Parameters with MDX Reports
    • Identifying KPIs and Measures
    • Cube Report Design with Filters
    • SSRS Reports versus Excel Reports
    • Tuning MDX Cube Reports in SSRS

    SSRS Video 7: Report Design - VI

    • Installing Report Builder Tool
    • Report Builder Versions and Limitations
    • DataSource and DataSet Creation
    • Datasets with Parameters and Filters
    • Toolbox Options and Format Options
    • Tablix Reports with Report Builder
    • Report Datasets and Set Parameters
    • Designing Geographical Queries
    • Query Buider Options and Text Options
    • Map Reports with Stored Procedures
    • Map Reports with Indicators, Labels
    • Analytical Data Reports and Usage
    • Creating RDL Files with Report Builder
    • Report Design with SPs - Benefits
    • Internal Parameters in SSRS (SPs)

    SSRS Video 8: Report Design - VII

    • Working with Multiple Datasets
    • Joining Datasets and LOOKUP
    • Local versus Shared Datasets
    • Databar Report Design Options
    • Sparkline Reports and Usage
    • Adding Chart Areas and Options
    • Adding Chart Series and Options
    • Report Dashboards - Importance
    • Dashboard Reports Creation Process
    • Query Techniques for Reporting
    • Report Chart Types and Usage
    • Series Cluster Usage Options
    • Category Groups and Options
    • Item List Reports and Usage
    • Sub Reports Design & Parameters
    • Auto-size and RS Format Options

    SSRS Video 9: Report Deployment & Management

    • Report Manager Configurations
    • Managing Data Sources Security
    • Security Roles and Content Management
    • Exporting and Importing Reports (RDL)
    • Snapshot Usage and Storage Management
    • Report / Local and Global Schedules
    • ReportServerTempdb Usage and Tuning
    • Tuning SSRS - Report Performance
    • Report Builder Connections and Reuse
    • Creating SSRS Subscriptions & Emails
    • Report Designer Vs Report Builder
    • Report Parts and RS Storage Options
    • Publishing Report Parts in Report Builder
    • Stored Procedures in Report Builder
    • Report Delivery Options & Schedules
    • Accessing and Controlling Reports
    • Email Subscriptions and Options
    • Encryption Keys and RS Config Files
    • Working with RS Execution Accounts
    • SSRS Configurations & Report Properties

    SSRS Video 10: Scale-Out Deployments, SMDL, PowerView

    • Scale-out Deployment Options in SSRS
    • Configuring SSRS for Scale-Out Options
    • Creating SMDL Report Templates
    • Deploying SMDL Templates in Report DB
    • Using SMDL Templates for Reporting
    • Power Pivot Configurations in Excel
    • Power View Report Configurations
    • Power View for RDLX Reports
    • Tables, Charts and Data Bars
    • Cube Reports and MDX Queries
    • Cube Reports with MDX Parameters
    • Drillthrough Report Management Options
    • Migrating Reports with SSRS - Options

    SSRS Video 11: New Features in SSRS 2016

    • New ReportBuilder Extensions
    • ReportBuilder Mobile Edition
    • PowerBI with SSRS - Desktop
    • PowerBI with SSRS - Mobile
    • Using ReportPortal URL Links
    • New SSRS Tuning Features in 2016
    • Migrating Reports from 2014 to 2016

    Compeltely Practical, Trainers available for doubts Clarifications. One Real-time Project for this SSRS Video Course.

    Why choose SQL School™ Training Institute:

    • Completely Practical and Realtime
    • Video Wise Tasks and Assignments
    • Labwork and Material for each video
    • On Job Support even after the course
    • 24x7 Server LIVE Online Lab
    • Mock Interviews and Certification Guidance

     


    • Microsoft Learning Partner Verify Link
    • ISO Certified Training Instittue

    SSRS Video Training Course Highlights:

    • SSRS 2016 & SSRS 2014 Configuration
    • Table, Matrix Reports, Drilldown Parameters
    • Map, Indicator, Gauge Reports, Dashboards
    • Dynamic Dependant Report Parameters, Filters
    • Tuning Reports - Proactive Caching, Snapshots
    • Deploy & Test (UAT) for Multi Users, Report Parts
    • RSConfig Files & Report Security with RSKeys
    • Deploy, Deliver SSRS Reports, Subscriptions
    • SSRS Scale-Out Deployments (SSRS 2016)

     

     

    Click Here for Free Demo Video and Video Training Registration

     

    Please find the Guidelines for Video Based Training (VBT) - Online


    1. How does Video Training Works

    > Videos are accessible 24x7. You can opt to access any number of videos each day or same video for multiple days.
    > Video Course to be completed within 3 months from the date of registration.
    > A Technical Test / Mock Interview is conducted and a Course completion certificate to be issued upon completion of the course.

     

    2. Access the videos

    > Each video is for duration of 80 - 90 minutes, can be paused/replayed for writing running notes and understanding.
    > Each video can be accessible multiple times before you proceed with the next video. Any time, any day.
    > To ensure secured delivery of our services the participant shall connect to our video cloud in a secured environment.

     

    3. Study Material, Practice and Doubts/clarifications

    > Study Material and Practice examples used in every video to be provided on email.
    > Software Installation Assistance and access to our 24x7 LIVE Server to be provided for duration of the course.
    > Trainers are available for doubts clarifications. On Skype, Email as well as on Call.

     

    Register today for SSRS Video Training

     

     

     

    To download SSRS Practical Video Training Course Curriculum : Click here

     

    Who can benefit from this SSRS Video Training course?

    This course is helpful for aspiring MSBI Developers, BI Architects, SQL Developers, Database Testers, BI Analysts, DB Architects and .NET Professionals. All training videos are completely practical and realtime. Session Material and LIVE Server with Lab included in the course.

    Register Today For Free Demo