Pragmatic SSRS 2008 (Online)

Fine Tune Your SQL Skills in 2 Days

Join Pragmatic Works as we tour the country with our live two-day sessions on SSIS, SSRS & Performance Tuning. We target major cities providing affordable SQL training courses sure to be near your local home base.

Microsoft SQL industry experts delivering quality training.

Hone Your SQL Expertise

Remote SQL Server, SharePoint and Performance Tuning training classes saving you time and money. We offer morning and afternoon sessions providing less time away from work at a fraction of the cost.

Increase BI Knowledge in 1 Week

The Pragmatic Works BI Quick Start provides hands on labs teaching you how to build a fully functional prototype data warehouse using SQL Server 2008R2. We train you on the complete Microsoft BI Platform: SSIS, SSAS, SSRS, and SharePoint BI in 5 days. Our Business Intelligence courses are taught in major cities throughout the United States.

Virtual Training

"I'm impressed by the number of examples involved in the training, the affordability of the class, and more than anything, the fact that I can keep a video recording of the training after it's over. Pragmatic Works is the first place I look to and recommend for SQL training. "

Jason Hurley

Virtual Training

"The best providers of high quality Microsoft BI related virtual and on-site classes. Their assistance during class, hands-on approach as well as post-class help made for a great experience"

Cosmin Ioan
Sr. Data Architect at Acquinity Interactive

Virtual Training

If you have become or expect to become responsible for SQL Server Analysis Services in your shop you owe it to yourself to take this course.

Bryant Byrd,
Sr. BI Systems Analyst
Eastman Chemical Company

Virtual Training

"This is the class that got me going on SSRS. The format: a unique combination of an online class where you still could interact personally with the instructor. The class content: Starting from scratch so everyone can keep up. The instructor: I have also taken other Pragmatics webcasts and these people are specialized in BI"

-Philip Leduc

Duration: 4 Days

Location: Online

SSRS Training

Develop reports with graphical representation of your data
Make your reports dynamic
Understand the concepts of dashboard design for your reports
Report off your Cubes, deploy and manage your reports and set-up subscriptions

NEW IN 2013: Now includes Virtual Mentor time!

Training Course Sections

Instructor	Date/Time	Cost	Registration Link
Chris Albrektson	06/10/13 - 06/13/13 9:00 AM - 12:00 PM EST	$995.00	Register Now!
Kathi Kellenberger	08/26/13 - 08/29/13 2:00 PM - 5:00 PM EST	$995.00	Register Now!

Training Course Overview

A four day class designed to help you understand all aspects of SQL Server 2008 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 be prepared to build your own real world applications using this SQL Server subsystem. Students will learn how to use SSRS in the real-world. 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 questionaire, 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.

Training Course Prerequisites

The target of this class is at developers, architects or IT professionals who have basic SQL skills already. 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 need to know how to run a query inside of SQL Server 2008.

System Requirements

Microsoft Windows XP, Microsoft Windows Server 2003, 2008, 2012, Microsoft Windows Vista, Windows 7, 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 Edition, Standard Edition or Enterprise Edition with the client tools, SSIS and SSRS.
AdventureWorks2008 and AdventureWorksDW2008 databases installed on the instance.

Terms & Conditions

Class Recordings

A class recording will be available via the web for a limited time for students who missed a session. Recordings are copyright protected and may not be distributed to others.

One Student Per Seat

We limit the number of students in each class to maintain a proper student to instructor ratio. Each purchased seat in a Virtual Training class is for use by one student only.

Cancellation/Rescheduling Policy

Students must provide at least 14 days’ notice to reschedule or withdraw from a class. In the case of withdrawal a credit will be issued for another Virtual Training class of similar value. Cancellation/reschedule with less than 14 days’ notice is subject to a fee of 100% of the total price.

We reserve the right to cancel or reschedule a class up to 2 weeks prior to the start date. Any students in a cancelled or rescheduled class have the option of a refund or credit to be used for another Virtual Training class of similar value.

Training Course Outline

Day 1

1. Introduction to the SSRS Architecture:

Architecture - Report Server / Report Manager
IIS vs. HTTP.sys
Installation - Native/SharePoint Integrater
Report Server vs. Report Manager

2. Data Warehousing

Why do you need a data warehouse
Data warehouse vs. Transactional Database
Dimension Table
Fact Table

3. Introduction to the environment

Creating a project
What is the difference between the project and solution
Solution Explorer
Shared Data sources
Shared Datasets (r2 only)
Design tab
Preview tab
Report Data Pane

4. Report Wizard

Query Builder
Report Types (Tabular / Matrix)
Table Layout

5. Data Retrieval

Report Data Pane detail
Built In Fields
Parameters (high level)
Images
Data Source
Data Sets (high level - embedded / shared

6. Data Sets

Query Builder (Edit as Text)
Stored Procedure
Import (.RDL or .SQL)
Filter
Parameters (high level)

Day 2

1. Basic Toolbox Item

Text Box
Line
Table
Rectangle
List
Image
Sub report

2. Table & Matrix

What is the difference
Grouping Pane
Table - Detail Group
Matrix - Row and Column Grouping

3. Grouping Filtering / Sorting

Expands / Collapse Group
Sorting Option
Interactive Sorting

4. Advanced Parameters

Stored Procedure Parameters
Cascading Parameters
Default Values
Multi value
Dropdown menu

Day 3

1. Expressions, Functions, and Custom Code

Introduction to expression builder in reporting services
Using expressions to create dynamic reports
Using reporting services functions with expressions
Extending reports with custom code

2. Advanced Toolbox Items - more advanced report objects

Chart
Gauge
Map
Data Bars
Spark Lines
Indicators

3. Dashboard Designs

Planning out a dashboard
Common component uses
Eye catching dashboard design

4. Querying MDX/Cubes

Analysis Services
MDX
Cubes
Data Warehousing
Lab: Create a report off a cube

Day 4

1. Reporting Services Configuration

Service Account
Web Service URL
Database
Report Manager URL
Email Settings
Execution Account
Encryption Keys
Scale Out Deployment

2. Report Parts (R2)

Creating Report Parts
Deploying Report Parts

3. Deployment

Report Project Properties
Target Data Set Folder
Target Data Source Folder
Target Report Folder
Target Report Part Folder
Target Server URL
Solution Configurations