LOGO For Immediate Assistance Call 855-211-9361

1-3 day (9 HOUR TRAINING):

Advanced SQL Server & Reporting Services: 6 High Impact Training Sessions


Call for availability 855-211-9361

Expand your skills with this high-impact series of training webinars by learning how to correctly and effectively use key features of SQL Server Reporting Services. These advanced-level sessions are for anyone who already has basic skills with Reporting Services and is now ready to add more advanced techniques for report development to your repertoire and to support ad hoc queries for business users. It's also for anyone who is responsible for managing the Reporting Services environment and needs to understand its capabilities, how to properly secure Reporting Services to protect the corporate network and information assets, and how (as well as whether) to integrate Reporting Services into a SharePoint environment. Although information about spatial data and some data visualization features apply only to the SQL Server 2008 R2 release of Reporting Services, all other information that you'll learn in these sessions also applies to the SQL Server 2005 and SQL Server 2008 versions.

Course Overview

By the end of the class students will be able to:

  • Practical examples of how, when, and why to use data visualizations (and which ones to avoid)
  • Tips and techniques for working with multidimensional data in reports
  • Best practice recommendations for report design, security, and SharePoint integration
  • Hands-on exercises distributed prior to the sessions help you understand how to use data visualization controls, create maps, query Analysis Services, and build report models

Course Outline

  • Adding Data Visualizations to Reports

    • Understanding Data Visualization Best Practices
    • Understanding Configuration Options for Charts and Gauges
    • Using Advanced Data Visualization Techniques
  • Displaying Spatial Data in Reports

    • Getting Started with the Map Wizard
    • Exploring Spatial Data Options
    • Developing Interactive Maps
  • Using Analysis Services as a Data Source

    • Using the MDX Query Designer
    • Customizing MDX Queries
    • Adding MDX Calculations
    • Working with Parameters and MDX
  • Enabling Ad Hoc Reporting

    • Developing and Publishing Report Parts
    • Building a Basic Report Model
    • Improving the Report Model Structure
    • Deploying the Report Builder 1.0 Client
    • Developing Ad Hoc Reports
  • Configuring Security Correctly

    • Understanding Default Report Server Security
    • Reviewing Report Server Entry Points
    • Designing Secure Reports
    • Configuring a Secure Server
  • Integrating Reporting Services with SharePoint

    • Understanding the Differences between Native and Integrated Mode
    • Installing and Configuring Reporting Services in Integrated Mode
    • Working with Document Libraries
    • Using Report Web Parts in Dashboards