Mindmajix
For individuals


Self-Paced Learning

  • Learn at your own convenience
  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • Industry ready curriculum
  • Fast-track / Regular / Weekend


For business


Corporate training solutions

  • Blended learning delivery model ( self-paced e-learning and/or instructor-led options)
  • Course, category, and all-access pricing
  • Enterprise-class learning management system (LMS)
  • Enhanced reporting for individuals and teams
  • 24x7 teaching assistance and support

Course Details

Mindmajix SSRS Training – SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. SSRS enables users to quickly and easily generate reports from Microsoft SQL Server databases.

The SSRS service provides a unique interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. SSRS provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. Reporting Services include programming features that enable you to extend and customize your reporting functionality.

SSRS Training Overview

Our SSRS Training begins by explaining what SQL Server Reporting Services is, how it fits in with the other Microsoft SQL Server tools. You will then be given step-by-step instructions to create projects, reports, data sources and datasets. You will also create various types of reports that enable users to drill down to detailed information from a summary page. Report items covered include tables, matrices, text boxes, parameters, charts and sparklines (in-line charts).

This SSRS Online training is ideal for experienced SQL Server developers, whether you’re new to Reporting Services or upgrading from an earlier version.

SSRS Online Training Curriculum

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

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

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

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 & 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

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

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

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

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

Managing RDL and RDLX Reports

Comparing PowerView and Report Builder

Drillthrough Report Management Options

Migrating Reports with SSRS and Excel

Faqs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

  • SSRS Training in Washington, DC
  • SSRS Training in Virginia
  • SSRS Training in New Jersey
  • SSRS Training in Illinois
  • SSRS Training in North Carolina
  • SSRS Training in California
  • SSRS Training in Maryland
  • SSRS Training in Georgia
  • SSRS Training in Texas
  • SSRS Training in New York
  • SSRS Training in San Francisco
  • SSRS Training in Oregon
  • SSRS Training in Ohio
  • SSRS Training in Florida
  • SSRS Training in Seattle
  • SSRS Training in Chicago
  • SSRS Training in Dallas
  • SSRS Training in Los Angeles
  • SSRS Training in Baltimore
  • SSRS Training in Houston
  • SSRS Training in San Diego
  • SSRS Training in Santa Clara
  • SSRS Training in Columbus
  • SSRS Training in Towson
  • SSRS Training in Salt Lake City
  • SSRS Training in Austin
  • SSRS Training in Sunnyvale
  • SSRS Training in Franklin
  • SSRS Training in Orlando
  • SSRS Training in Boston
  • SSRS Training in San Jose
  • SSRS Training in St. Louis

SEND A QUERY

Course Reviews

4.5

152 ratings
  • 5106
  • 423
  • 315
  • 26
  • 12

Drop Us A Query


Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.