BI Solution Overview: MS SQL Server
Reporting Services Architecture (SSRS)
Design Tool: Report Builder Report
Types (Simple Table, Matrix, Charts, Gauges)

Workshop: Setting up the environment, overview

Creation wizard
Configuration of a data source
Editing queries
Using tablix / gauges
Calculation formulas
Formatting and style
Selection parameters (multiple choice lists, cascading lists, etc.)
Adding variable parameters
Using filters
Interactive sorts
Adding sub -states

Workshop: Design of reports with quality presentations – customization, calculations and sorting

Designing a report based on an Analysis Services source
Designing an MDX query
Adding variable parameters
Exploring data in a report (drill down-drill up)
Navigating from one report to another

Workshop: Editing of elaborate reports

Types of exports and renderings (XML, CSV, PDF, TIFF, PDF, Excel, Word, etc.)
Publication of reports
Creation of capture and report history
Management of a report cache
Subscription and distribution of reports

Workshop: Export of various reports and cache management

Overview of Configuration Manager
Managing Security and Defining Roles
Migrations and Integration of Reporting Services

Lab: Configuring and Managing Security in Reporting Services

Adding Custom Code to a
Web Services Report and
Querying Reports Querying Reports Remotely

Workshop: Demonstrations of querying reports