in

Pragmatic Works

Enabling your business intelligence enterprise.

This Blog

Syndication

Tags

Darren Herbold

Reporting Services Class

Recently I've been tasked with writing a 4 day Reporting Services class
for End to End Training www.EndToEndTraining.com. It will be ready in
time for an April delivery and can be viewed here: http://www.endtoendtraining.com/rs.aspx 

I'm going to post the outline here as well, and I'm open for suggestions!
I also wanted to get some feedback on a class that I was thinking of
creating called Professional Dashboarding with SQL Server. The course 
will be pretty hard-core and targeted to developers (web and windows).
It will teach you how to build professional web-based and windows-based
dashboard portals. It will include everything from creating a staging environment
to SSIS ETL, to front-end dashboad development in C# and/or VB.NET.
I would appreciate any feedback you may have on this!

Day 1

Module 1 – Introduction to SQL Server Reporting Services

  • What is SSRS and features overview
  • SSRS Architecture and components
  • Installation and Setup
  • BIDS environment and the Report Designer IDE
  • Report Development Lifecycle

Module 2 – Introduction to Reporting Services Report Designer

  • Reporting Services Data Sources
  • Report Designer Table Control
  • Report Designer List Control
  • Report Designer Matrix Control
  • Report Designer Image Control
  • Report Designer Wizard
  • LAB – Building a report with the SSRS Wizard

Module 3 – Designing and Developing Reports with Reporting Services

  • Creating and utilizing data sources
  • Developing reports using the Table control
  • Developing reports using the List Control
  • Developing reports using the Matrix Control
  • Utilizing the Image control in Reporting Services
  • LAB – Designing and developing reports using the Table, List, and Matrix controls

Module 4 – Report Deployment

  • Introduction to Report Manager portal
  • Report Deployment in Reporting Services
  • The ReportServer database
  • Configuring your environment to deploy reports
  • LAB – Deploying Reports to the Report Server

Module 5 – Report Builder

  • Introduction to Report Builder
  • Report Builder Models
  • Ad-Hoc Reporting with Report Builder
  • Adding Security with Report Builder
  • LAB – Building a Report Builder Model

Day 2

Group Lab 1 – Creating a basic End-to-End Reporting Services Report

Module 6 – Designing and Developing Reports utilizing the Chart Controls

  • Introduction to Charting Controls in Reporting Services
  • Data Architecture for Chart control development
  • Configuration of Charting controls in Reporting Services
  • LAB – Designing and developing reports using charts

Module 7 – Sub-reports, Drill-down, Drill-through and Navigation

  • Introduction to Sub-reports in Reporting Services
  • Creating and configuring sub-reports
  • Creating and configuring drill-down and drill-through reports
  • Configuring  report navigation
  • LAB – Creating a report using sub-reports, drill-through, and navigation

Module 8 – Grouping and Sorting

  • Introduction to Grouping in Reporting Services
  • Data architecture for grouping in table controls
  • Configuring grouping in a table control
  • Interactive sorting in reporting services
  • Configuring sorting in a report
  • LAB – Create a report using grouping and sorting

Module 9– Parameters

  • Using Parameters in Reporting Services
  • Default, Lookup, and Multi-value parameters
  • Dynamic cascading parameters
  • Understanding and configuring the various parameter properties
  • LAB – Creating a parameter-driven report

Module 10 – 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
  • LAB – Create a dynamic report using expressions and custom code

Day 3

Group Lab 2 – Creating an advanced End-to-End Reporting Services Report

Module 11 – Reporting from Analysis Services Cubes

  • Introduction to Analysis Services Cube data
  • Connecting to Analysis Services from Reporting Services
  • Creating Reports on Analysis Services Cubes
  • LAB – Building a report from Analysis Services cubes

Module 12 - Report Development Data Architecture

  • Requirements gathering for Report Development
  • Data Architecture in report development
  • Staging data techniques for reports consumption
  • Report View control for Windows and Web applications
  • LAB – Building and loading a staging architecture based on report requirements

Module 13 – Report Management

  • Configuring reports in Report Manager
  • Configuring Report Parameters in Report Manager
  • Configuring Data Sources in Report Manager
  • Configuring Security in Report Manager
  • Running Reports in Report Manager
  • LAB  - Configuring and running reports in Report Manager

Module 14 – Report Subscriptions

  • Introduction to Report Subscriptions in Reporting Services
  • Standard Subscriptions
  • Data-Driven Subscriptions
  • Report Delivery Options
  • Managing Subscriptions in Report Manager
  • LAB – Configuring Standard and Data-Driven Subscriptions  

Day 4

Module 15 – SQL Server 2008 Reporting Services

  • Explore new features in SSRS 2008
  • New Controls in SSRS 2008
  • Creating reports in SSRS 2008
  • LAB – Creating a report using the new Tablix control  

Group Project – Create a Dashboard Report

Day 4 will consist of an all day project where the students will be given a set of basic requirements, transform those into a polished set of full requirements with the aid of the instructor. Then the students will create, deploy and configure (in Report Manager) and run the successfully created report. The report will contain all the controls and techniques covered in the class through an entire phase of the report lifecycle. The report will pull data from a staging environment created and loaded by the student and will utilize parameters, grouping, sorting, sub-reports, drill-down, drill-through, expressions, table control, list control, matrix control, images, charts & graphs, and subscriptions.

I also do on-site training for SSIS, SSAS, and SSRS
www.PragmaticWorks.com

To view more of these articles, please visit my blog site at:

http://pragmaticworks.com/community/blogs/

Comments

No Comments
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems