Learn table and matrix report design, interactive OLAP reporting, executive dashboard & scorecard architecture for enterprise performance management applications, and effective delivery of Business Intelligence to end users though data visualization, interactivity, sub reports and report linking.

Report Authoring:
· Learn the basics of report design with Table Reports.
· Find out how to set up a database, Excel, OLAP Analysis Services data sources and datasets.
· Create easy to navigate reports by adding single-values or multi-valued prompts, adding drill-downs, document maps and drill throughs.
· Learn best practices to create page, report, and table headers and footers.
· Use expressions in a variety of report design situations: aggregating data, creating conditional formatting, and adding custom fields.
· Explore new features such as working with expressions, multi-value drop-down cascading report parameters, interactive sorting, and floating headers.

Discover Data Regions:
· Learn how to use table, matrix, list, subreport, and chart data regions as well as the practical application of each for delivering Business Intelligence.

Manipulating Datasets:
· Build parameterized reports using query and stored procedure parameters and filters.
· Discover how to use stored procedures and user defined functions to build dynamic reports.
· Learn to build reports that display recursive hierarchies.
· Create a report from an Analysis Services OLAP cube.
· Design multi-dimensional drill-down matrix and KPI Reports.
· Learn model design for the ad-hoc query builder tool.
· Master report deployment, publishing, subscription, email and shared folder distribution.

CD-ROM 1 - BI DELIVERY
1. Welcome to SQL Server Reporting Services
2. SSRS Architecture: Tour of Features
3. Report Server Components & Operation
4. Traditional & Interactive Web-based Reports
5. RS Vital Part of MS Business Intelligence Platform
6. Reporting Services Installation & Configuration
7. Report Builder - End User Authoring Tool
8. Navigating Reporting Services Design Studio
9. Report Designer's Report Wizard
10. Data Sources: SQL Server, OLAP, & OLE DB
11. Report Layouts & Various Rendering Formats
12. Enterprise BI: Executive Scorecard & Dashboard
13. Matrix Reports for OLAP Cube Reporting
14. Business Intelligence Development Studio
15. Reporting Services Report Manager
16. SQL Server Management Studio

CD-ROM 2 -REPORTING BASICS
1. BIDS Report Designer Tool
2. Developing a Reporting Solution
3. Evaluating Business Requirements
4. Designing for Reporting Services
5. Identifying Users & Preparing Specifications
6. Managing Shared & Private Data Sources
7. Designing Basic Reports from Scratch
8. Building Table Reports with Report Wizard
9. Experimenting with Formatting Options
10. Adding Table Headers and Footers
11. Adding Page Headers and Footers
12. Subtotals, Totals, Grand Totals & Formulas
13. Creating Chart Reports of Various Types
14. Lists - Free Form Data Presentation
15. Improving Usefulness with Paging & Sorting
16. Designing Reports from a Report Specification

CD-ROM 3 - FORMATTING REPORTS
1. Report Items and Graphical Elements
2. Basic Expressions & Global Collections
3. Including Custom VB Code in Reports
4. Formatting Fields & Conditional Formatting
5. Grouping, Static & Interactive Sorting
6. The Magic of Interactive Drill-Down Reports
7. Calculating Totals and Percentages
8. BI Dashboards for Data Visualization
9. Performance Management Scorecards
10. Advanced Report Features, Web Farm Deployment
11. Drill-Through Reports & Report Metadata
12. Linked Reports & Complex Expressions
13. Subreports & Report Definition Language
14. Configuring Document Maps & Bookmarks
15. Organizational Chart (Recursive) Reports
16. Top 10 Report Formatting Tips

CD-ROM 4 - REPORT PARAMETERS
1. Creating Simple Parameter Reports
2. Binding Report Parameters to Dataset Parms
3. Setting Up Defaults & Drop-Down Parameters
4. Multivalued Parameters with Checkmark Drop-Down
5. Architecting Reports with Multi-Select Parameters
6. Designing Reports with Cascading Parameters
7. Parameters Passing in Drillthrough Reports
8. Report Parameters Dialog Box
9. Configuring Stored Procedures with Parameters
10. Configuring Functions (UDF) with Parameters
11. Debugging Reports, Troubleshooting & Error Logs
12. Enhancing Performance with Filters
13. Multiple Criterion Report Filtering
14. Filters vs. Query Parameters
15. Parameters as Interactive BI Report Features
16. Top 10 Report Parameter Tips

CD-ROM 5 - MATRIX REPORTS
1. Delivering BI with Matrix (Crosstab) Reports
2. Classifying Data into Dimensions & Measures
3. Matrix Page, Columns, Rows & Details Setup
4. Matrix Subtotals, Totals & Grand Totals
5. Applying Aggregate Functions to Measures
6. Designing Interactive Drill-Down Matrix Reports
7. Creating Basic & Complex Matrix Charts
8. Matrix Reports with Time Dimensions
9. Matrix Reports with Multi-Level Dimensions
10. Matrix Reports with Mixed Dimensions
11. Matrix Reports with Multi-Measures
12. Matrix Reports with Multi-Aggregates
13. Adding Static & Dynamic Columns and Rows
14. Architecting Drillthrough Matrix Reports
15. Matrix Reports for OLAP (AS) Cube Reporting
16. OLAP Performance Management Matrix Reports

CD-ROM 6 - PUBLISHING & MANAGING
1. SSMS Reporting Services Management
2. Deploying Reports and Data Sources
3. RS Security: Managing Roles & Data Sources
4. Setting up Folders & Permissions for Users
5. Managing with Report Manager
6. Managing with Management Studio
7. Standard & Data-Driven Subscriptions
8. Automating Report Creation and Delivery
9. Snapshot Reports & Storing Report Histories
10. Report Caching & Fast Stored Procedures
11. Rendering Reports in Excel, XML or PDF
12. Managing Reports Builds and Deployments
13. Reports, Projects, Solutions & Data Sources
14. ReportServer & ReportServerTempDB Databases
15. Managing Models Builds and Deployments
16. Publishing Report Builder Reports

CD-ROM 7 - ADVANCED REPORTING
1. Key Performance Indicators (KPIs) Reports
2. Importing Reports from Microsoft Access
3. Adding Multiple Regions to a Report
4. Nested Lists & Green Bar Reports
5. Architecting Master-Detail Business Reports
6. Building Reports on Analysis Services Cubes
7. Generating MDX Using the MDX Builder
8. Mastering OLAP Reports: Drop-Down Parameters
9. Cascading Prompts for OLAP Cube Reports
10. Report Builder Model Designer
11. Creating Reports with Report Builder
12. Deploying Report Builder to End Users
13. Infinite Drillthrough Report Builder Reports
14. SQL Query Builder & DSV (Data Source Views)
15. Designing Matrix Reports with Report Builder
16. Top 10 Reporting Services Success Secrets