This fast-paced two-day instructor-led course is intended for IT professionals who are interested in quickly learning how to use the Reporting Services development tools to create reports. This course also covers how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Objectives
Understand version changes of SSRS from 2008-2012.
Understand Reporting Services installation and architecture.
Understand and utilize Reporting Services tools.
Understand and utilize Wizards.
Create and configure data sources.
Create and configure datasets.
Understand security in connections.
Create and configure Tables.
Create and configure Matrices.
Create and configure Lists.
Understand and utilize Report Items.
Understand and utilize Report Parts.
Understand and utilize Charts.
Understand and utilize Gauges.
Understand Dashboards.
Understand and utilize Maps.
Understand and utilize Data Bars.
Understand and utilize Sparklines.
Understand Key Performance Indicators
Understand and utilize Expressions.
Understand and utilize Functions.
Understand and utilize Interactivity.
Understand and utilize Parameters.
Understand and utilize Conditional Formatting.
Understand Templates.
Understand and utilize Subreports.
Deploy reports.
Secure and manage content.
Understand and utilize Caching.
Understand and utilize Snapshots.
Understand and utilize Report History.
Understand how to complete other administrative tasks.
Audience
This course is intended for SQL professionals, Microsoft Reporting Services administrators and report developers, and business intelligence professionals.
Topics
Course Overview
Introduction to Microsoft SQL Server Reporting Services
Building Basic Reports
Highlighting Basic Reports with Visualizations
Developing Advanced Reports
Managing and Maintaining Reporting Services