Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

MS2797 - Designing Reporting Solution Archictecture SQL Server 2005

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at
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.
Click here for a printer-friendly version of this page.
This course has not been scheduled yet. Please contact us by clicking the link below to learn about availability.
Contact us for additional availability.


Before attending this course, students must: Have hands-on experience with database development tasks. For example: • Creating Transact-SQL queries • Writing and optimizing advanced queries (for example, queries that contain complex joins or subqueries) • Creating database objects such as tables, views, and indexes • Have foundational conceptual understanding of Business Intelligence presentation architecture. For example, data source management, the function of pivot tables versus grids versus charts, what drill down and linked reports are, and what schema abstraction (Report Builder) is. • Have foundational understanding of Web-based architecture. For example, SSL, SOAP, IIS, and WSS/SPS-Web parts—what they are and what their role is. • Be familiar with SQL Server 2005 features, tools, and technologies. In particular, they must have used Report Designer, Report Manager, and Report Builder. • Have foundational understanding of Microsoft Windows security. For example, how group
Detailed Class Syllabus

Module 1: Designing a Reporting Solution
  • Evaluating Business Requirements for a Reporting Solution

  • Designing for Reporting Services

  • 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

  • Module 4: Deploying and Managing a Reporting Solution
  • 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 Reporting Services

  • Optimizing Report Execution

  • Scaling Reporting Services
    Microsoft Partner Gold LearningPearson VUE Authorized Test CenterEC-Council