Quick Microsoft SQL Server 2012-2014 Reporting Service

Session Detail:    Classroom 2 Day

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.

Prerequisites

There are no prerequisites for this course.

Who Can Benefit

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

Session Outline

Class Outline

Module 1: Course Overview

  • Lesson 1: Introduction
  • Lesson 2: Course Materials
  • Lesson 3: Facilities
  • Lesson 4: Prerequisites
  • Lesson 5: What We’ll Be Discussing

After completing this module, students will be able to:

  • 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

  • Lesson 1: Version Changes of SSRS from 2008-2012
  • Lesson 2: Reporting Services Installation and Architecture
  • Lesson 3: Reporting Services Tools

After completing this module, students will be able to:

  • Understand version changes of SSRS from 2008-2012
  • Understand Reporting Services installation and architecture
  • Understand and utilize Reporting Services tools

Module 3: Building Basic Reports

  • Lesson 1: Wizards
  • Lesson 2: Data Sources
  • Lesson 3: Datasets
  • Lesson 4: Understanding Security in Connections
  • Lesson 5: Tables
  • Lesson 6: Matrix
  • Lesson 7: List
  • Lesson 8: Report Items
  • Lesson 9: Report Parts

After completing this module, students will be able to:

  • 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

Module 4: Highlighting Basic Reports with Visualizations

  • Lesson 1: Charts
  • Lesson 2: Gauges and Dashboards
  • Lesson 3: Maps
  • Lesson 4: Sparklines, Data Bars, and Indicators

After completing this module, students will be able to:

  • 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

  • Lesson 1: Expressions
  • Lesson 2: Functions
  • Lesson 3: Interactivity
  • Lesson 4: Parameters
  • Lesson 5: Conditional Formatting
  • Lesson 6: Templates
  • Lesson 7: Subreports

After completing this module, students will be able to:

  • 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

Module 6: Managing and Maintaining Reporting Services

  • Lesson 1: Deploying Reports
  • Lesson 2: Securing Content
  • Lesson 3: Caching
  • Lesson 4: Snapshots
  • Lesson 5: History
  • Lesson 6: Viewing Reports Online
  • Lesson 7: Utilizing Subscriptions
  • Lesson 8: Data Alerts

After completing this module, students will be able to:

  • 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

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Quick Microsoft SQL Server 2012-2014 Reporting Service

2 Day
Classroom

$1,090.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now