Pragmatic Master SSRS (Online)

Master Report Developers must hold unique traits to set themselves and their work apart from others. This four (half day) class is designed to take you to the next level in your understanding of SQL Server 2008R2/2012/2014  Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies. This course will cover all the advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage.

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 – Report Development

  1. Report Design Patterns
    • 5 Second Rule
    • Spotting Design Mistakes
    • Choosing Colors
    • Choosing Charts
    • Hands-on Lab: Identifying Report Design Mistakes
  2. .Net Integration
    • Why use Custom Code?
    • Direct Embedding
    • External Assemblies
    • Hands-on Lab: Implementing Custom Code
  3. Using SSAS as a Data Source
    • Building a Dynamic Cube Report
    • Tips and Tricks
    • Building a Data Mining Report
    • Hands-on Lab: Building a Dynamic Cube report

Day 2 – Report Development cont. and User Interface

  1. Advanced SSRS Expressions
    • Advanced Functions
    • Launch Office Tools from your report
    • Launching Bing Maps
    • Hands-on Lab: Dynamically launching Bing Maps
  2. Report Manager
    • Linked Reports
    • Object Visibility
    • My Reports
    • Hands-on lab: Using Linked Reports
  3. Report Builder 3.0
    • Train the Trainer: How to Teach End Users
    • Using Report Parts
    • Hands-on Lab: Building and Using Report Parts

Day 3 – Administration

  1. Configuration
    • Setting up an Email Server
    • Configuring an Execution Account
    • Understanding and Enabling Encryption Keys
    • Using SSL within SSRS
  2. Report Utilization
    • Setting up a Monitoring database
    • Scheduling Monitoring Database Updates
    • Usage Reports
    • Hands-on Lab: Implementing Report Server Monitoring Reports
  3. Security
    • Role based security explained
    • Creating System-Level Permissions
    • Creating Item-Level Permissions
    • Creating Custom Security Roles
    • Hands-on Lab: Creating and Using a Custom Security Role
  4. Performance
    • Creating Snapshots
    • Performance Tuning with Report Caching
    • SSRS Performance Counters
    • Hands-on Lab: Setting up a Report Snapshot

Day 4 – Enterprise Solutions

  1. SharePoint Integration
    • Report Server Database
    • Configuration
    • Deployment
  2. Web Farm
    • Understanding Scaling-Out Architecture
    • Setup and Configuration
    • Network Load Balancing
  3. Data Driven Subscriptions
    • Building a Subscription
    • Monitoring Subscriptions
    • Debugging Failed Subscriptions
    • Hands-on Lab: Building a Data Driven Subscription
  4. Accessing Report Server Remotely
    • Report Server Internet Architecture
    • Setup Considerations
  5. Miscellaneous
    • Creating a Report Viewer Control
    • Creating Report Templates
    • Using Document Maps
    • Reporting on Recursive Data
    • Refresh Report Data from Word, PowerPoint, etc..
    • Using Reports to Start SQL Agent Jobs
    • Hands-on Lab: Creating a Document Map report

Prerequisites

The target of this class is at developers, architects or IT professionals who have above average T-SQL skills already and a basic understanding of MDX and VB. This class assumes that you have a strong understanding of SSRS fundamentals. For example, you should already know and use the majority of the toolbox items before attending this class. It is not mandatory but ideally you should have an instance of SharePoint to follow some sections of the class.

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
    • 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
  • **Optional** Full Visual Studio .Net Components. Used for only one module so this is not mandatory.
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance.
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance.
  • AdventureWorks Cube installed on the Analysis Services instance.

Some of our clients