SSRS TRAINING COURSE CONTENTS

dwnld

SSRS Training Course Contents

SSIS Training In Pune & SSIS Training In Vishrantwadi

SSIS provides Data Extraction, Consolidation and Loading Options (ETL), SQL Server Coding enhancements, Data Warehousing and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts. In our LIVE Online Training, we deal with complete SSIS Design and Development including SCD, Profiling, Tuning and Customizations. All sessions are completely practical and realtime.

Program Objectives

  • Leverage SQL Server Integration Services to produce BI solutions
  • Create OLAP cubes and automate maintenance with XMLA scripts
  • Extend hierarchies and exploit advanced dimension relationships
  • Build custom solutions with MDX
  • Implement key performance indicators to monitor business objectives
  • Make smarter business decisions with data-mining techniques

Enosis Learning Advantage

  • More than 6 Years of experience in SSIS Training
  • Trained 1000+ Students so far.
  • Strong Theoretical & Practical Knowledge
  • SSIS certified Professionals
  • Certified Trainers from the IT industry with rigorous understanding of specialized domain.
  • Lecture contents prepared by Industry expert
  • Live Projects to work on with IT industry standards.
  • Focus on cross cultural and various onshore and offshore client oriented trainings
  • Weekly workshop from industry experts
  • An innovative teaching methodology delivers in- depth knowledge with quality tailored programs that maximize a return on your investment.
  • Strategic Association for global certification

Eligibility

  • SQL Server T-SQL Queries

Program Structure

The course will have regular classroom Lectures, Practical Sessions, Seminars, Tutorials, Case Studies, Assignments and Exams.

Duration

3 Months

Syllabus

Introduction to SSRS


  • SQL Server Reporting Services Architecture
  • Architecture of SQL Server Reporting Services
  • Components behind SQL Server Reporting Services
  • Creating a basic report using the SQL Server Reporting Services Wizard
  • Creating Wizard Reports
  • SSRS Objects - Definition
  • Data Source & Data Sets
    • -Shared sources
  • Graphical Query Designer
  • Create a tabular report from scratch
  • Steps for creating tabular reports
  • Understanding RDL File
  • Understanding Different types of Reports
  • Adding controls to reports
  • Tablix and Data Regions
    • -Table
    • -Matrix
    • -Lists
  • Fixed & Dynamic ‐ columns and rows
  • Adding Calculations in Reports
  • Report Parameters
    • -Creating Parameters
    • -Linking Parameters with Reports
    • -Types of Parameters
    • -Available & Default values
    • -Multiselect parameters
    • -Cascading parameters
  • Groups
    • -What is Grouping of Reports
    • -Creating Groups in Reports
  • Drill‐down facility
    • -Adding Drilldown to Reports
    • -Visibility option
  • Subreports
    • -What is Sub Report
    • -Creating Sub Report
    • -Using in a table
    • -Drill -down in a subreport
  • Navigations
    • -Drill‐through
    • -Hypertext links
  • Types of Charts in SSRS
    • -What is a Chart
    • -Features of Charts
    • -Adding Charts to Reports
    • -Line Charts
    • -Bar Charts
    • -Pie Charts
    • -Exploring advance options in charting
    • -Gauges
    • -Images
    • -Data Bar
    • -Indicator & Sparkling Report Items
  • Calculations and Expressions


  • Creating expressions in reports
  • Creating Custom functions
  • Using VB.NET expressions to ‐ control properties, calculate values & specify a dataset query
  • Discover the Various global collections that you can reference in your expressions
  • Formatting report items using formatting toolbars, the Properties window, and the Textbox Properties dialog box
  • Formatting
    • Rich formatting
    • Page layout
    • Page breaks
  • Headers and Footers
    • Multiline header and footers
  • Interactive Sorting
  • Ad Hoc reporting
    • Using Report Builder
    • Report parts deployment
  • Reports from Analysis Service Cube

Deployment & Management of Reports


  • Overview of SSRS Report Server
  • Architecture of SSRS Deployment
  • Components of SSRS Deployment Server
  • Databases of SSRS Deployment Server
  • Plan and configuring for deployment
  • Deploying Reporting Services projects and individual reports and data sources
  • Changing Data Sources in Deployment Server.
  • Exporting reports to a variety of formats
  • Managing Reporting Services projects using Report Manager
    • Accessing reports from browser
    • Subscriptions
    • Data Driven subscriptions
    • Snapshots
    • Report History
    • Managing Security

Programming Reporting Services


  • Exploring application programming interfaces of Reporting Services
  • Using URL to integrate Reporting Services reports into your applications
  • Explore the use of the Report Viewer controls to create Web pages and Windows Forms that render Reporting Services reports in place