Thursday, 17 November 2016

SSRS Online Training

MICROSOFT TOOLS
SSRS ONLINE TRAINING @ VIVANTA IT LABS
An online course designed to make you an expert in SSRS Online Training to learn Report Design, Development, Testing, Tuning and Delivery of Enterprise / Adhoc Reports, Report Builder Options, Snapshots and Email Subscriptions including Power View and Power Pivot Dash Boards.
SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). While SSAS enables users to construct special databases for fast analysis of very large amounts of data, and while SSIS enables users to integrate data from many sources outside Microsoft SQL Server, 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 also provides a ‘Report Builder’ tool for less technical IT workers to format SQL reports of lesser complexity. 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 includes programming features that enable you to extend and customize your reporting functionality.

SSRS Online TRAINING OVERVIEW



SSRS Training starts by explaining what SQL Server Reporting Services is, how it fits in with the other Microsoft SQL Server tools and gives an example to show how it might be used. You will then be given step-by-step instructions to create projects, reports, data sources and datasets. 
You will create various types of report, both static and dynamic, and also parent/child 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).
In SSRS Training you will learn how to create interactive business intelligence reports using SQL Server 2012 Reporting Services, and help facilitate real-time decision making throughout the enterprise. This SSRS Online training is ideal for experienced SQL Server developers, whether you’re new to Reporting Services or upgrading from an earlier version.
What you’ll learn :
  • Use the latest features, including the Power View ad hoc reporting tool
  • Design reports by understanding how your audience accesses and uses data
  • Add interactive features to help end users sort and filter data
  • Create rich data visualization with charts, gauges, indictors, and data maps
  • Configure your report server, provide security, and monitor report contents
  • Use SharePoint or Report Manager to search and access reports online
  • Create a library of report parts that clients can use for ad hoc reporting
  • Build and manage reports using Reporting Services as a development platform

SSRS Training Curriculum

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

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

FEEL FREE TO CONTACT US


Your feedback is valuable to us. Please send us your suggestions.

USA OFFICE

INDIA OFFICE

Posted by at No comments:
Subscribe to: Comments (Atom)