Download PDF
of this course

MS55124 - Quick Microsoft SQL Server 2012 Reporting Services (MS55124)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 2 Days

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.

Who Should Attend

  • This course is intended for SQL professionals, Microsoft Reporting Services administrators and report developers, and business intelligence professionals.

Course Certifications

This course is part of the following Certifications:


  • None

Course 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.

Course Content

Module 1 :Course Overview

This module explains how the class will be structured and introduces course materials and additional administrative information


  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What we will be discussing 

Lab : Course Overview 

  • Successfully log into their virtual machine
  • Have a full understanding of what the course intends to cover


Module 2 : Introduction to Microsoft SQL Server Reporting Services

Reporting Services is a report design and enterprise-class information delivery tool. In this module , we will explore the version changes , installation , architecture and tools for Reporting Services.


  • Version Changes of SSRS from 2008-2012
  • Reporting Services Installation and Architecture
  • Reporting Services Tools

Lab : Introduction to Microsoft SQL Server Reporting Services

  • Understand version changes of SSR from 2008 - 2012
  • Understand Reporting Services Installation and architecture
  • Understand and utilize Reporting Services tools


Module 3 : Building Basic Reports

In this module , we begin building reports using the basics . We will explore the wizards available and then cover tables , matrices , and lists while demostrating how to use each of them. Finally , we will take a look at the report items available to help deisgn the report.


  • Wizards
  • Data Sources 
  • DataSets
  • Understanding Security in Connections
  • Tables 
  • Matrix
  • List 
  • Report Items
  • Report Parts

Lab : Building Basic Reports

  • Understand and utilizie 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


Module  4 : Highlighting Basic Reports with Visualisations

Visualize and present your data using visualisations. In this module , we cover the visualisations available , while demostrating each, so you can see for yourself just how captivating data can be.


  • Charts 
  • Gauges and Dashboards
  • Maps
  • Spark;ines , Data Bars , and Indicators

Lab : Highlighting Basic Reports with visualizations

  • 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


Module 5 : Developing Advanced Reports

Looking to take reporting to the next level? The look no further . In this module , we cover what you will need to create advanceds reports with features such as conditional formatting and interactivity just to name a few.


  • Expressions
  • Functions
  • Interactivity
  • Parameters 
  • Conditional Formatting
  • Templates
  • Subreports

Lab : Developing Advanced Reports

  • Understand and utilizie Expressions
  • Understand and utilize Functions
  • Understand and utilize Interactivity
  • Understand and utilize Parameters
  • Understand and utilize Conditional Formatting
  • Understand Templates
  • Understand and utilize Subreports


Module 6 : Managing and Maintaining Reporting Services

To share your report , you need to publish or deploy it to a report server or SharePoint site. In this module , we explain deployment options and follow with an explanation on security and administrative tasks.


  • Deploying Reports
  • Securing Content
  • Caching
  • Snapshots 
  • History
  • Viewing Reports Online
  • Utilizing Subscriptions 
  • Data Aklerts

Lab : Managing and Maintaining Reporting Services

  • 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


Course ID: MS55124

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register