CERTIFICATIONS

PROGRAMS

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 getsmart@LRS.com

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

Prerequisites

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