COURSE 9185 | 2-DAY SESSION
SQL Server 2005 Reporting Services

---

Design and develop reports using SSRS in just two days

Corporations are just now figuring out that their data can drive their business. Companies need data in order to answer large strategic direction questions and everyday business decisions. Unfortunately, the data needed is in three different databases from three different departments. Understanding how to utilize the data you have access to is becoming one of the most important IT topics around.

SQL Server 2005 Reporting Services (SSRS) allows companies to leverage their data rather than simply manage it. This 2-day course on SSRS will teach you to create, execute, and manage reports that can be vital business tools helping your company succeed. You will start by installing and configuring SSRS. Then you will explore creating reports with groups, formatting, parameters, different data sources, and much more.

Whether you are data analyst responsible for creating reports and designing report models, an administrator that needs to install and configure SSRS and assign roles, a developer wanting to know how to integrate applications with SSRS, or a business analyst or project manager that needs to be able to run reports, this class will give you the hands-on experience you need to leverage your company’s data.

Immediate Benefits of Taking This Class:

1. Understand SSRS installation requirements
   
2. Configure data sources for report authoring
   
3. Summarize data for report authoring
   
4. Connect to a data source
   
5. Leverage parameters while interacting with a data set
   
6. Filter report data
   
7. Construct a report model
   
8. Work with Report Builder
   
9. Execute a report
   
10. Publish a report with Report Designer and Report Manager
    
11. Configure Report History
    
12. Comprehend subscription scenarios for Report Services
    
13. Control report distribution
    
14. Monitor availability of your reports
    
15. Leverage Reporting Services Management
    
16. Assign roles with Reporting Services Management
    
17. Secure your Reporting Services system
    
18. Evaluate your systems performance with trace files, report execution, and performance counters
    
19. Acquire the highest performance possible out of your Reporting Services
    

Who Should Attend:

This class provides definitive instruction on how to harness the latest features of Microsoft’s SQL Server 2005. Anyone involved in the use or management of a database using SQL 2005 will find this class invaluable, including:

• Data Analysts
  
• Information Workers
  
• Database Administrators
  
• Database Developers
  
• Project Managers
  
• Business Analysts
  
• Database Managers
  
• Data Modelers
  
• Database Security Experts
  
• Report Server Administrator