MindQ are pioners in offering real time industrail experts hands MSBI(SSIS, SSAS, SSRS) training.
along with Real Time Project senarios. All the sessions are completely PRACTICAL.


SSRS Course Objectives

Module 1: Architecture and Introduction to SQL Server Reporting Services.

Understanding of Reports,
Introduction to SSRS,
Need for SSRS
Reporting Services
SSRS three phase Lifecycle
.
SSRS Architecture
Reporting components, Tools, Web Service Requirements and usage
SSRS and IIS, and SQL Server Web Services
Requirement for Virtual Directories

Module 2: Designing and Implementation of Reporting Services Projects

Report planning, Data Sources,
Enterprise and Adhoc-reports
Optimizing Data Sources
Configuring connection and Data providers
SSRS Expression,
Parameter and Multi valued Parameter
Filters in Data source
Report Designer: Wizard based reports, custom reportsUsing Table and Matrix
Chart based report and images
Sub Reports, Reporting Option,
Tabular Reports
Exporting Reporting data
Module 3: Use report models to implement reporting for business users

Understanding of Report models
Designing Report models
Identifying Entities
Identifying different Attributes
Numerical Aggregation,
Time Aggregation
Module 4: Configure report publishing and execution settings

Deployment Option
Build and Deploy, publishing reports
Configuration Option
Managing Configuration Files
Module 5: Implementing subscription for reports

Creating Standard Subscription
Data Driven Subscription
Subscription Logging options
Benefits of SSRS Logging
Server Level Logging Options
Report level logging
Audit reports execution

For any further details please contact +91-9502991277 or
visit www.mindqonline.com
Please mail your queries to online@mindqsystems.com

MindQ are pioners in offering real time industrail experts hands MSBI(SSIS, SSAS, SSRS) training.
along with Real Time Project senarios. All the sessions are completely PRACTICAL.

Aggregate Transformation, Sort Transformation, Percentage Sampling Transformation,
Row Sampling Transformation, Pivot Transformation, Unpivot Transformation
Other Transformation

Export Column, Import Column, Audit, Row Count,
Slowly Changing Dimension
Data Flow Task
Split and Join Transformation
Understanding of Extraction, Transformation, Loading
Conditional Split, Multicast, Merge, Merge Join, Union All, Lookup
Data Flow Sources
Data Quality Transformation

ADO NET Source, Excel Source
Flat File Source,
OLE DB Source,
XML Source
Fuzzy Lookup, Fuzzy Grouping

Data Mining Transformation

Data Mining Query, Term Extraction, Term Lookup

Synchronous and Asynchronous Transformation
SSIS Expression
Data Sources
Module 1: Debugging and Managing Package Execution
Debugging Control Flow
Debugging Data Flow
Debugging Script Task
Packaging Configuring
XML File Configuring
Multiple Configuring File,
Package Logging
Module 2: Detecting and Handling Processing Errors
Error Handling
Basic Error Detection and Handling
Understanding of Event Handler
Maintaining Data Consistency with Transactions
Checkpoint, Checkpoint Restarts and Transaction
Module 3: Securing and Deploying SSIS Packages
Creating Deployment Utility,
Securing Package
Role – Based Security,
Deployment Option
Monitoring Package Execution and Event Logs
Optimizing SSIS Packages

* Resume preparation and Interview assistance will be provided.

For any further details please contact +91-9502991277 or
visit www.mindqonline.com
Please mail your queries to online@mindqsystems.com

MindQ are pioners in offering real time industrail experts hands MSBI(SSIS, SSAS, SSRS) training. along with Real Time Project senarios. All the sessions are completely PRACTICAL.

SSRS Course Objectives

Module 1: Architecture and Introduction to SQL Server Reporting Services.

Understanding of Reports,
Introduction to SSRS,
Need for SSRS
Reporting Services
SSRS three phase Lifecycle
.
SSRS Architecture
Reporting components, Tools, Web Service Requirements and usage
SSRS and IIS, and SQL Server Web Services
Requirement for Virtual Directories

Module 2: Designing and Implementation of Reporting Services Projects

Report planning, Data Sources,
Enterprise and Adhoc-reports
Optimizing Data Sources
Configuring connection and Data providers
SSRS Expression,
Parameter and Multi valued Parameter
Filters in Data source
Report Designer: Wizard based reports, custom reportsUsing Table and Matrix
Chart based report and images
Sub Reports, Reporting Option,
Tabular Reports
Exporting Reporting data
Module 3: Use report models to implement reporting for business users

Understanding of Report models
Designing Report models
Identifying Entities
Identifying different Attributes
Numerical Aggregation,
Time Aggregation
Module 4: Configure report publishing and execution settings

Deployment Option
Build and Deploy, publishing reports
Configuration Option
Managing Configuration Files
Module 5: Implementing subscription for reports

Creating Standard Subscription
Data Driven Subscription
Subscription Logging options
Benefits of SSRS Logging
Server Level Logging Options
Report level logging
Audit reports execution

For any further details please contact +91-9502991277 or
visit www.mindqonline.com
Please mail your queries to online@mindqsystems.com