SUMMARY:   This scenario-based presentation details how to use SQL Server 2005 Reporting Services (SSRS) to design a robust reporting solution to support a BI solution. AUDIENCE:   Data architects, business intelligence/data warehouse specialists, developers and analysts. PREREQUISITES:   Completion of our Data Warehousing Terms, Concepts & Architecture course or equivalent knowledge. Basic knowledge of SQL on any relational DB platform. DURATION:   3 days. APPROACH:   Lecture and hands-on (about 70%). OBJECTIVES:   Upon completion of this presentation, the delegate should be competent to: Identify and manage report data Create reports using tools such as Report Wizard, Report Designer and Report Builder Add expressions to reports Manage and secure reports Etc. COURSE CONTENT:   SQL SERVER 2005 BUSINESS INTELLIGENCE FEATURES Integration Services Analysis Services Reporting Services REPORTING CONSIDERATIONS Reporting options Audience type considerations Enterprise reporting life cycle Ad-hoc reporting SSRS INSTALLATION CONSIDERATIONS Deployment options Installation requirements SSRS configuration REPORT BUILDING Data source definition Structuring data Using style templates Report Wizard Report layout Publishing a report Report management Accessing a report Report Designer Structuring a report Formatting a report Report Builder EXPRESSIONS Calculating values with expressions Aggregate functions Conditional formatting Sorting ORGANISING DATA Data regions Matrices Charts Lists ADVANCED REPORTING FEATURES Using parameters Query parameters Interactive features (actions, subreports, etc.) Hierarchical data REPORT MODELS Create a report model Change a report model Publish a report model Secure a report model CONTENT MANAGEMENT Publishing reports Content organisation Report execution SECURITY CONSIDERATIONS Report server security Data security GOW/08