SQL Server 2008/2008 R2 Reporting Services (SSRS) for Power Users and End Users

Course Code: BISRS8
Duration: 2 days
Level: Beginner-to-intermediate
Audience: Business intelligence/data warehouse specialists, BI managers, BI power users and anyone tasked with tactical and strategic planning and analysis.
Prerequisites: Familiarity with desktop applications such as Microsoft Excel or Access.
Summary: This hands-on course is aimed at business intelligence power users and end users who want to develop reports with report models built by administrators. The course details how to use SQL Server 2008/2008 R2 Reporting Services' Report Builder 1.0, 2.0 and 3.0 tools to design and deliver a variety of report types in various formats.
Objectives: Upon completion of this presentation, the delegate should be competent to:
  • Understand the scope and limits of Report Builder 1.0 vs. 2.0 vs. 3.0
  • Access data sources using report models and Query Designer (for SQL and MDX)
  • Create reports using the Report Builder tools
  • Create different types of reports, such as tables, matrices, charts and gauges
  • Sort data in reports
  • Filter data
  • Format reports
  • Publish reports
  • Render reports in Excel, PDF, etc
Format: Lecture and hands-on (about 70%).
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page