India : +91 9502991277
    VOIP: +1 408 876 4444
Email : online@mindqsystems.com
Latest Online Courses >> Microsoft .net and sharepoint
Follow us on :

SSRS

During this Microsoft Business Intelligence [MSBI] training program, you will dive into Designing an ETL Solution Architecture Using Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL Server Integration Services. In addition, we will extensively cover how to Design an Analysis Solution Architecture Using Microsoft SQL Server Analysis Services and Implement and Maintain Microsoft SQL Server Analysis Services. You will expand your knowledge on MDX Queries and learn how to create complex reports employing expressions, global collections, and conditional formatting using SQL Server Reporting Services.

Overview

Pre-Requisites

Course Content

SQL Server Reporting Services

Introducing SQL Server Reporting Services

  • Tour of Features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions
  • Taking Reporting Services for a Spin

Pre-Requisites:

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture.

Software Needed on Each Student PC

  • Windows Server 2003 or 2012, Windows XP Professional, with at least 1GB RAM
  • SQL Server 2012/2005 and Business Intelligence Components

Creating Reports

  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch

Calculations and Formatting

  • Creating Expressions
  • Using the Global Collections
  • Formatting Items
  • Conditional Formatting

Grouping and Sorting

  • Creating Groups
  • Calculating Totals and Percentages
  • Interactive Sorting
  • Creating Drill-Down Reports

Report Parameters

  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues

Creating Matrix Reports and Charts

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities

Managing Reporting Services

  • Deploying Reports and Data Sources
  • Exporting Reports and Printing
  • Using the Web-Based Report Manager
  • Using SQL Server Management
  • Studio-based Reporting Services Manager

Reporting Services Security

  • Two Parts to Reporting Services
  • Security
  • Securing Access to Reports
  • Data Source Security

Programming Reporting Services

  • The Many Reporting Services APIs
  • Integrating Reporting Services into
  • Applications using URL Access
  • Using the Report Viewer Controls

Advanced Reporting Services Programming

  • Using the Reporting Services Web
  • Service
  • Working with Custom Assemblies

Snapshots and Subscriptions

  • Caching and Snapshots
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Managing Subscriptions

Ad-Hoc Reporting with Report Builder

  • The Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder

* For all the above topics there will be a Demo and Lab session. Case studies will be provided based on the scenario.

For Detailed Course Contents Click here
For Upcoming Class Room Batches Click here

For Registration      

  • Firehouse
  • Chloe nightclub
  • Firehouse bar
  • Firehouse chloe club fishtank
  • Firehouse restaurant
  • Firehouse