Pragmatic SSRS (Online)

This is a four day class designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and to prepare you to build your own real world applications using this SQL Server subsystem. With the hands-on labs, you will learn how to create complex reports. This course will cover all the key concepts of Reporting Services from basic reporting, parameters, deploying, and scheduling.

IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionnaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.

All virtual training students are provided a previously recorded version of the class that are available for 7 days after the end of the class.

Outline

    Day 1

  1. Introduction to Reporting Services
    • Why use SSRS?
    • Understanding Basic Architecture
    • Where Should I Report From?
  2. Introduction to the Reporting Environment
    • Creating Solutions and Projects
    • Getting Familiar with the Development Tool
    • Hands-on Lab: Creating a Report Project
  3. Building your First Report
    • Using the Report Wizard
    • Using the Query Builder
    • Report Types (Table/Matrix)
    • Hands-on Lab: Using the Report Wizard to Build a Report
  4. Bringing Data into your Reports
    • Creating Data Sources
    • Creating Datasets
    • Hands-on Lab: Creating a Dataset Based on a Stored Procedure

    Day 2

  5. Using Basic Toolbox Items
    • Using the Textbox
    • Using the Line
    • Organizing Report Items with Rectangles
    • Bringing Images into your Report
    • Hands-on Lab: Creating a Reporting Standard with Images and Textboxes
  6. Understanding the Table and Matrix
    • When to Use Table Versus Matrix
    • Using the Grouping Pane
    • Sorting Data
    • Expand / Collapse Groups
    • Creating Mailing Labels with the List
    • Hands-on Lab: Building a Matrix Report with Expanding Groups
  7. Building a Report with Parameters
    • Modifying Datasets to use Parameters
    • Using Default and Available Values in Parameters
    • Changing Parameters to use a Drop-Down Selection
    • Building Cascading Parameters
    • Hands-on Lab: Designing a Report with Cascading Parameters

    Day 3

  8. Making Reports Dynamic with Expressions
    • Introduction to the Expression Builder
    • Use Cases for Expressions
    • Hands-on Lab: Building a Dynamic Report Using Expressions
  9. Visualizations for Dashboard Development
    • Building Drill Through Reports with Actions
    • Visualizing Data with Charts
    • Creating Dashboards with Gauges
    • Showing Geographical data with Maps
    • Illustrating Trends in Data with Sparklines
    • Showing Data Distribution with Data Bars
    • Using Indicators to Display Key Performance Indicators (KPI)
    • Bringing together a Dashboard with Subreports
    • Hands-on Lab: Developing a Dashboard using Reporting Services
  10. Reporting on an Analysis Services Data Source
    • Using the Report Wizard to Build an Analysis Services Based Report
    • Querying an Analysis Services Data Source
    • Creating Parameters on Analysis Services Datasets
    • Hands-on Lab: Creating a Report Using an Analysis Services Data Source

    Day 4

  11. Administration
    • Deploying to the Report Server
    • Deploying to SharePoint
    • Security Basics
    • Hands-on Lab: Deploying Reports to the Report Server
  12. Report Delivery
    • Implementing Report Subscriptions
    • Using SharePoint Data Alerts
    • Hands-on Lab: Setting up a Window File Share Subscription
  13. Self-Service Reporting Services
    • Self-Service Tools and Who Would Use Them
    • Developing Reports Using Report  Builder
    • Creating Power View Reports
    • Hands-on Lab: Building a Power View Report 

Prerequisites

The target audiences of this class are developers, architects or IT professionals who already have basic SQL skills. This class assumes that you have no previous knowledge of SSRS. In some of the coding modules, it is useful (but not mandatory) that the student has some basic VB experience. You will also need to know how to run a query inside of SQL Server.

SystemRequirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Some features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Reporting Services
    • SQL Server Analysis Services (Optional)
    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance.
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance.

Some of our clients