Learn: in:
» back to Search Results

Course rating of 4 Vendor rating of 5


In this instructor-led course, you will learn to implement a Reporting Services solution in an organization.

  • Course Start Date: Nov. 7
  • Location: Virtual (Map)
  • Time: 8:30 am - 4:30 pm (Note on end times)
  • Please Note: End Times are approximate and depend
    on the number or students and pace of the class.
    It is important to allow for the class to run a little bit longer,
    or finish a little sooner, than expected.
  • Duration: 5 days
    08:30 AM - 04:30 PM
  • Delivery Method(s):Virtual Instructor Led
  • Mentored training is a revolutionary training method
    that provides you with the quality training that
    you have come to expect, and combines it with
    flexible learning and a self paced environment.
    For more information click here.
  • Discount Seats Available:2
  • Category:Microsoft SQL Training

 
Course Outline
Learn how to create dynamic reports that integrate with SharePoint.

In this instructor-led course, you will learn to implement a Reporting Services solution in an organization. You will learn how to use the Reporting Services development tools to create reports and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

This course incorporates material form the Official Microsoft Learning Product 6236: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services.

Why Global Knowledge?


For a comprehensive learning experience, this course includes two days of exclusive lecture and hands-on labs where you'll learn how to create dynamic reports, access external data sources, optimize and troubleshoot Reporting Services, and integrate with SharePoint 2007.

What You'll Learn
  • SQL Server Reporting Services and its components
  • Create a Reporting Services report
  • Enhance a Reporting Services report
  • Create dynamic reports
  • Create and manipulate data sets
  • Use report models to implement reporting for business users
  • Configure report publishing and execution settings
  • Implement subscriptions for reports
  • Administer Reporting Services
  • Implement custom Reporting Services applications
  • Retrieve data from external data sources
  • Optimize and troubleshoot Reporting Services
  • Integrate Reporting Services with SharePoint 2007
Who Needs to Attend

IT professionals and developers who need to implement reporting solutions by using Microsoft SQL Server 2008 Reporting Services

Course Outline

1. Introduction to Microsoft SQL Server Reporting Services

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools
2. Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values
3A. Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data
  • Expressions
  • Using Parameters as Content
  • Changing Report Structure with Parameters
3B. Exclusive - Dynamic Reports
  • More with expressions
  • Displaying Parameters
  • Dynamic Report Structure
4. Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists
5. Using Report Models
  • Creating Report Models
  • Using Report Builder
6. Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
7. Using Subscriptions to Distribute Reports
  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions
8. Administering Reporting Services
  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008
9A. Programming Reporting Services
  • Adding Code to Reports
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code
9B. Exclusive - Adding Custom Code to a Report
  • Adding Code to a Report
  • Using a Custom Code Assembly
10. Exclusive - External Data
  • Accessing Remote SQL Server Data
  • Connecting to Other Data Sources
  • Implementing Analysis Services
11. Exclusive - Optimizing and Troubleshooting
  • Optimizing the SSRS environment
  • Troubleshooting the SSRS environment
12. Exclusive - Integrating with Microsoft Office SharePoint Server 2007
  • Introduction to SharePoint 2007
  • SharePoint Integrated Mode
  • Configuring SharePoint for Reporting Services
  • Deploying Reports to SharePoint
  • Managing and Viewing Reports
  • Integrating Reports into Dashboards
Labs

Lab 1: Introduction to Microsoft SQL Server Reporting Services

  • Exploring Report Designer
Lab 2: Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Adding Calculated Values
Lab 3A: Enhancing Basic Reports
  • Using Dynamic Visibility
  • Using Document Maps
  • Initiating Actions
  • Using a List Data Region
  • Creating a Tablix Report
  • Adding Chart Subreport to Parent Report
Lab 3B: Exclusive - Dynamic Reports
  • Variables and Parameters
  • Dynamic Shading
  • Displaying Filter Values
  • Dynamic Report Structure
Lab 4: Manipulating Data Sets
  • Using Parameters to Restrict Query Results
  • Using Parameters to Filter Report Data
  • Creating Dynamic Parameter Lists
  • Using Parameters with a Stored Procedure
  • Displaying All Categories in a Parameter List
Lab 5: Using Report Models
  • Creating a Report Model
  • Using Report Builder to Create a Report
Lab 6: Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Configuring and Viewing a Cached Report
  • Configuring and Viewing a Snapshot Report
Lab 7: Using Subscriptions to Distribute Reports
  • Creating a Standard Subscription
  • Creating a Data-Driven Subscription
Lab 8: Administering Reporting Services
  • Using Reporting Services Configuration Manager
  • Securing a Reporting Services Site
  • Securing Items
Lab 9A: Programming Reporting Services
  • Using URL Access to Display a Report
  • Building a Reporting Services Web Service Client
  • Using the Report Viewer Control
  • Adding a Report Control to a Windows Application
Lab 9B: Exclusive - Advanced Reporting: Adding Code to Reports
  • Custom Report Code
  • Using a Custom Assembly
Lab 10A: Exclusive - External Data
  • Reporting on External SQL Server Data
  • Reporting on MySQL Data
  • Reporting on Analysis Services Data
Lab 10B: Exclusive - Analysis Services
  • Create an Analysis Services Cube
  • Created a Calculated Member and a KPI
  • Create a Cube-Based Report
Lab 11: Exclusive - Optimizing and Troubleshooting Reporting Services
  • Troubleshoot Reports
  • Troubleshoot Reporting Services
Lab 12: Exclusive - SharePoint Integration
  • Configure Reporting Services for SharePoint Integration
  • Install and Configure the Reporting Services Add-In for SharePoint
  • Deploy a Reporting Services Project to SharePoint
  • Display and Manage Reports
  • Add a Report to an Existing SharePoint Page



Prerequisites & Certificates
Pre-Requisites

- Exposure to creating reports in Microsoft Access or other third-party reporting products, such as Crystal Reports - Conceptual understanding of the push and pull distribution/subscription paradigm - Experience navigating the Microsoft Windows Server environment - Experience with Windows services (starting and stopping) - Experience creating service accounts and permissions - Experience with Microsoft SQL Server, including: * SQL Server Agent * SQL Server query language (SELECT, UPDATE, INSERT, and DELETE) * SQL Server System tables * SQL Server accounts (users and permissions) - Course 6182: Implementing and Managing SQL Server 2008 - SQL Server 2008 R2 for Administration (M6231)

Certificates offered

- Eligible for SATV Purchase - 3 Day SATV Voucher


Cancellation Policy
We require 16 calendar days notice to reschedule or cancel any registration. Failure to provide the required notification will result in 100% charge of the course. If a student does not attend a scheduled course without prior notification it will result in full forfeiture of the funds and no reschedule will be allowed. Within the required notification period, only student substitutions will be permitted.

Reschedules are permitted at anytime with 16 or more calendar days notice. Enrollments must be rescheduled within six months of the cancel date or funds on account will be forfeited.
Map & Reviews
Global Knowledge
[ View Provider's Profile ]

Online Classroom
your office
your city, your province
your country   .


Reviews
 
I am not highly enthused about taking a course over a video link, however, I did find that this course was well presented. It's my feeling that there is no substitute for a classroom environment when it comes to learning and sharing ideas.
Reviewed by 2015
7-November-2016 $2695 Regular Price $2995 Register for this course

Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer Make An Offer Help

Not enough budget for this course? Maybe you just love to make deals!
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
need-to-train-a-group-banner

This course is also scheduled on the following dates:

Not interested in this Course?

Tell us why:

This page has been viewed 12 times.