Microsoft Business Intelligence - SQL Server 2008 Reporting Services workshop - 2 Days

Microsoft Business Intelligence - SQL Server 2008 Reporting Services workshop - 2 Days

 

  • Registration

    Sale Date Ended

    INR 5499
    Sold Out

Invite friends

Contact Us

Page Views : 1224

About The Event

Course Outline


Module 1: Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Architecture of SQL Server 2008 Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

Module 2: Authoring Basic Reports

  • Creating a Table Report
  • Formatting Report Pages
  • Calculating Values

Module 3: Enhancing Basic Reports

  • Grouping and Sorting
    • Explore creating groups
    • Master the Reporting Services Grouping pane
    • Learn how to calculate group totals and percentages
    • Understand scope as it applies to aggregate functions
    • Discover interactive sorting
    • Find out how to create drill-down reports
  • Interactive Navigation
  • Displaying Data
  • Parameterized reports
  • Linked reports
  • Snapshot reports
  • Cached reports
  • Ad hoc reports
  • Clickthrough reports
  • Drilldown reports
    • Drillthrough reports
    • Subreports

Module 4: Working with Parameters

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists
  • Using Parameters with a Stored Procedure
  • Dig into the use of unbound, multivalued, and cascading parameters

Module 5: Using Report Models and Report Builder 3.0

  • Creating Report Models
  • Using Report Builder 3.0

Module 6: Publishing and Executing Reports

  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions
  • Creating a Data-Driven Subscription

Module 8: Administering Reporting Services

  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008


Certification Preparation and Tips:

Exam 70-448:
TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-448&locale=en-us#tab2

 

 

Venue Map