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

VIDEO 1: SSRS INSTALLATION, CONFIGURATION

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

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
  • Report Timeout Options and Tool Box Options, Report Data
  • Initial Catalog For Report Sources, Static/Dynaic Properties

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 and 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
  • Column Groups - Advance Mode - Fixed Attributes, Fields
  • Repeating Header on Every Page & RepeatPage Options
  • Working with Report Globals for Metadata, Report Properties

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
  • Linking Report Parameters to Dataset Parameters and Filters

VIDEO 5: REPORT DESIGN - IV

  • Chart Reports - Design Options, Properties and Usage
  • Series Values Selection - with / without Category Groups
  • Report Categories with Series Groups - Differences, Usage
  • Data Visualization Types: Trend & Discrete Chart Reports
  • Clustered / NonClustered Legend Attributes. Position Options
  • Series Lables : Properties, Number Formatting Options, Visibiity
  • Series Actions : Series Properties, Multi - Valued Parameters
  • Report Actions : URL / Reports, Setting for Report Filters
  • Axis Values - Possible Issues with Multiple Axis Items, Solutions
  • Dashboard Creations, Usage. Multiple Chart Areas, Legends
  • Dashboard Exports with Filters (Static, Parameterized)
  • Chart Series Properties and Options, Report Markers & Grid Values
  • Chart Areas with Multiple Toolbox Items, Properties & Limitations
  • 3-Dimensional Report Options - Properties, Visibility Options
  • Range & Pie Charts, Line Reports, Data Bars, Area Charts
  • Report Actions with Parameter Values - Report Filter Joins
  • Exploring Toobox Filters with Type Conversions & Expressions
  • Common Report Errors with DataSet / Report Filters, Solutions
  • Using Shared DataSources and Shared DataSets - Advantages
  • Data Bar Reports and Sparline Reports - Stacked Reports - Usage
  • Multiseries Charts, Dynamic Chart Size, Axis Display Control

VIDEO 6: REPORT DESIGN - V

  • Gauge Reports: Purpose and End User Access Options
  • Gauge Report Types - Radial and Linear Gauges
  • Adding Data to Gauge Report - Default Indicators
  • Gauge Data Versus Chart Data - Pointer Options
  • Scale Properties: Maximum, Minimum Dynamic Ranges
  • Browser Compatability and Offline Report Access
  • Gauge Properties, Gauge Panel Properties and Filters
  • Master Reprots and Detailed Reports - Sub Reports
  • Adding Scale - Properties, Values and Label Options
  • Adding Pointers - Properties, Scale Limits, Format Options
  • Adding Ranges - Report Items, Properties, Needle Options
  • Adding Labels - Properties, Scale Limits, Format Options
  • Adding Multiple Gauges - Dashboard Design, Dynamic Size
  • Parameterized Gauge Reports - Dataset Level and Filters
  • Indicator Reports : Value and State Expressions
  • Indicator Repors and Gauge Panel Optinos with Filters
  • Report Design with Multiple Gague & Indicator Reports
  • Missing Values and States in Indicator Versus Gauge
  • Dynamic Report Parameters and Filter Expressions
  • Rendering Format Limitations & Real-world Considerations

VIDEO 7: REPORT DESIGN - VI

  • Report Builder Tool - 2016, 2014, 2008 R2 Installation
  • Installation Verification Options, msi File Configuration
  • DataSource and DataSet. Local - Report Specific Entities
  • Dataset Design with Parameters and Filters. Usage Options
  • Query Designer Options with Report Builder, Table Selection
  • Column Aggregates and Auto Group BY. Query Edit Options
  • Adhoc Reports Design with Tabilx Wizard - Report Layouts
  • Report Design with Sub Totals, Drill-down & Column Groups
  • Chart Report using Report Builder - Line Reports & Options
  • Dataset Design with Parameters and Filters. Usage Options
  • Line Reports and XValue Options using Report Builder Tool
  • Trend Analysis and Continuous Data Reports - OLTP / DWH
  • Map Reports - Map Layers, Map Report Items and Options
  • Map Gallery, ESRI Share Files and SQL Server Spatial data
  • Defining Geo Spatial Data for Business Analysis Dashboards
  • Working with Polygon, Tile, Line and Point Map Layers
  • Map Visualization Options and Bubble Map Reports Usage
  • Data Fields, Display Labels and Visualization Indicators

VIDEO 8: REPORT DEPLOYMENT & SUBSCRIPTIONS

  • Report Deployment Options - Report Builds, Config Files
  • Data Source, Data Set Folders, Report Server URL Targets
  • Report Deployment - UI & Command Line. RSKey Config
  • Report Server URL and Report Manager (Web Portal) URL
  • Report Home, Site Settings & Properties. Report Settings
  • Data Sources: Properties, Security Options, Access Options
  • DataSets: Properties, Security Options, Dependent Items
  • Reports: Properties, Security Options, Edits, Downloads
  • Security Roles: Content Manager, Browser, Report Builder
  • MyReports Role, Report Publisher Role. Report User/Groups
  • Report Linking and Default/Hidden Parameter Options
  • Report Tuning: Caching Options, Cache Refresh - Cautions
  • Report Tuning: Snapshot Options and Snapshot Schedules
  • Report Tuning: Off-the-Shelf Reports and Linked Reports
  • Local and Global Schedules, History Management, Jobs
  • Report Builder Connections and Reusability Options
  • Report Parts and RS Storage Options. Paginated Reports
  • Report Delivery & Schedules, File Share Subscriptions
  • Accessing and Controlling Reports, Email Subscriptions
  • Encryption Keys & RS Config Files, RS Execution Accounts

VIDEO 9: SCALE-OUT, CUBE REPORTS, POWER BI INTEGRATION

  • Scale-Out Deployments and Remote Report Databases
  • Remote Report Database Connections, Recovery Options
  • Scale-Out Joins and Waits. Report Configuration Keys
  • Multi-Report Server Configurations, Execution Accounts
  • Report Designer Versus Report Builder - Advantages
  • Cube Reports with SSRS - MDX Queries. Advantages
  • Cube Reports with MDX Parameters & Filters. Performance
  • Cube Reports with MDX Expressions, YTD, QTD Calculations
  • Reports with SSAS KPIs and Cube Aggregations - MOLAP
  • Cube Reports with Tabular Data Sources. Hierarchy Levels
  • Sub Reports, Dashboards, Action Reports with Report Builder
  • Drill-Up and Drill-Down Reports, Drill Through Reports
  • Report Actions @ SSAS 2016 OLAP Databases. Limitations
  • Power BI Reports with SSRS - Desktop / Mobile Editions
  • Power BI PBX Reports with RDL Sources, Vice Versa
  • Power BI Reports with SSRS and SSAS Connections, Options
  • Power View and Power Pivot Extensions, Usage Examples
  • New SSRS Tuning Features in 2016, Report Migrations


VIDEO 10: Real-time Project @ ERP

End-to-End Reporting Solutions, Builds,
Deployments, Subscriptions, Tuning,
Jobs, Audit Logs and more..!

Versions: SSRS 2014 and SSRS 2016
Environment: SSDT 2013, SSDT 2017
Database Size: 250 GB
No. Of Tables: 74
Platform: ERP

 

 

 


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.

SQL School Phone IndiaIndia: +91 (0)9666440801
SQL School Phone USAUSA: +1(510) 400-4845
 

WHY CHOOSE US:

Microsoft Partner (ID# 4338151)

100% Real-Time and Practical

ISO 9001:2008 Certified

24/7 LIVE Server Access

Real Time Projects

Theory Material in Advance

Weekly Mock Interviews

Placement Assistance

Job Support

OFFICE 1:

#108/2RT, Road #1, Beside SR Nagar Bus Stop, Ameerpet, Hyd-38

India: 0091 (0)9666440801

Map
OFFICE 2:

Sai Anu Avenue, Street #3,
Patrika Nagar, HITEC City, Hyd - 81

India: 0091 (0)9666440801

Map

OUR RATINGS

Google: 4.7/5

Facebook: 4.8/5

Sulekha: 4.8/5

JustDial: 4.7/5

MouthShut: 5/5

UrbanPro: 5/5

Yet5: 5/5

 
 

©2008-2017 SQL School, Regd®: Sequelgate (I) Technologies Pvt. Ltd™

Sql School is an Authorized Microsoft Training Partner (ID# 4338151)

SequelGate (I) Technologies Pvt.Ltd. is rated 4.8/5 by www.facebook.com/Sqlschool based on 107 reviews

FOLLOW US:
social
social
social
social
social
social