MS2797 - Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services
| Categories |
Database Training, Microsoft SQL Server Reporting Services Training, Reporting Training |
| Duration |
2 days (14 hours) |
| Pre-requisites |
The target students for this course already have an understanding of how to use the SQL Server tools to implement reporting functionality, but need to develop their understanding of design principles and best practices when planning, implementing, and deploying a Reporting Services solution.
|
|
|
|
| Courseware |
MS2797-MS (300 pages) |
| Price |
$790 |
| Notes |
|
The purpose of this 2-day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. Students will go through the entire process—from identifying report data to promoting the reporting solution to production. Students will scale a reporting solution. Students will also be taught best practices for collaborating with application developers to integrate applications and reporting services.
Module 1:Designing for Reporting Services
Evaluating Business Requirements for a Reporting Solution
Lab 1: Designing a Reporting Solution
Identifying Reporting Solution Users
Creating a Reporting Solution Specification
Designing a Report Model
Module 2:Developing a Reporting Solution
Developing Reports
Developing Report Models
Lab 2: Developing a Reporting Solution
Creating Reports from a Report Specification
Working With Report Models
Customizing Reports By Using RDL
Module 3: Integrating Reporting Services with Applications
Integrating with Custom Applications
Controlling Reporting Services by Using Web Services
Lab 3: Integrating Reporting Services with Applications
Integrating Reports into an ASP.NET Application.
Integrating a Report Into a SharePoint Services Solution
Implementing a Reporting Services Web Service Client
Design Web service clients for Reporting Services.
Module 4: Deploying and Managing a Reporting Solution
Deploying a Reporting Services Solution
Managing Report Distribution
Lab 4:Implementing Calculations
Deploying Reports
Managing Report Distribution
Module 5: Designing Security for a Reporting Solution
Designing an Authentication Strategy
Designing an Authorization Strategy
Designing a Secure Communication Strategy
Lab 5: Securing Reporting Services
Configuring Authentication
Configuring Authorization
Configuring Secure Communications
Module 6: Optimizing Report Performance
Monitoring Report Execution
Designing a Report Execution Strategy
Scaling Reporting Services
Lab 6: Optimizing Performance
Monitoring Reporting Services
Optimizing Report Execution
Scaling Reporting Services