SQL Server Reporting Services

Course 140

  • Duration: 4 days
  • Labs: Yes
  • Language: English
  • Level: Intermediate
Get This Course 27.950 kr
  • 4-day instructor-led training course

  • Hands-on labs included

  • Learning Tree end-of-course exam included

  • After-course instructor coaching benefit

  • After-course computing sandbox included

#140
  • okt 18 - 21 15:00 - 22:30 CEST
    Virtual
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    okt 25 - 28 10:00 - 17:30 CEST
    London or Virtual
  • nov 29 - dec 2 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • dec 13 - 16 15:00 - 22:30 CET
    New York or Virtual
  • jan 17 - 20 15:00 - 22:30 CET
    Ottawa or Virtual
  • jan 24 - 27 10:00 - 17:30 CET
    London or Virtual
  • feb 21 - 24 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • mar 21 - 24 14:00 - 21:30 CET
    New York or Virtual
  • apr 18 - 21 15:00 - 22:30 CEST
    Ottawa or Virtual
  • apr 25 - 28 10:00 - 17:30 CEST
    London or Virtual
  • maj 23 - 26 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • jun 20 - 23 15:00 - 22:30 CEST
    New York or Virtual
  • jul 18 - 21 15:00 - 22:30 CEST
    Ottawa or Virtual
  • aug 29 - sep 1 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • sep 19 - 22 15:00 - 22:30 CEST
    New York or Virtual

Scroll to view additional course dates

Gain an in-depth skillset to leverage on-premises SQL Server Reporting Services (SSRS) for extracting business intelligence from enterprise data. Attain the knowledge and skills to produce compelling reports with enhanced visualization features. This training course enables you to go beyond the limitations of legacy reporting to deliver and share information with others — when you want and how you want.

SQL Server Reporting Services Delivery Methods

  • In-Person

  • Online

SQL Server Reporting Services Course Benefits

  • Produce reports for extracting business intelligence through the Web Portal

  • Leverage Visual Studio and Report Designer to create paginated reports

  • Build reports for mobile devices with SQL Server Mobile Report Publisher

  • Integrate parameters, filters, and interactive components into reports

  • Deploy reports through Report Server

  • Create reports on SSAS cubes with Report Builder and Report Designer

  • Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

SQL Server Reporting Services Course Outline

Prerequisites

  • Learning Tree Microsoft SQL Server® Introduction or equivalent experience with any relational database system
  • Visual Studio knowledge and familiarity with simple scripting is recommended, but not required

Who should attend?

This course is for anyone with database experience who wants to design, create, or deliver reports from relational or MDX compliant data sources.

Exam Information

Learning Tree Exam provided at the end of class

  • Architecture and tools
  • Managing web farm deployment

Leveraging Reporting Services tools

  • Report Building with Report Builder and Visual Studio
  • Accessing the power of SQL Server Mobile Report Publisher

Designing fundamental reports

  • Connecting to relational and multidimensional sources
  • Generating a Tablix reporting structure

Composing expressions

  • Computing custom fields
  • Linking expressions to properties

Arranging and sorting data

  • Multiple-level grouping and categorizing the results
  • Applying aggregate functions

Producing various outputs from a Tablix

  • Creating parallel dynamic group report formats
  • Combining dynamic and static columns

Incorporating parameters into reports

  • Yielding subsets of data with query parameters
  • Constructing cascading report parameters
  • Transmitting parameters to stored procedures

Applying filters to report data

  • Augmenting performance with filters
  • Determining filters vs. query parameters

Combining multiple data regions in one report

  • Applying sequential and nested regions
  • Creating master/detail reports and linking subreports

Showing robust data with relevant detail

  • Drilling through report detail and drilling down
  • Navigating reports with document maps

Deploying reports to the server

  • Publishing reports and configuring project properties
  • Verifying results with Report Manager

Identifying delivery options

  • Enhancing performance with cached instances
  • Configuring snapshot history

Dispatching subscription reports

  • Publishing reports via e-mail and file share
  • Seamlessly delivering reports by data-driven subscriptions

Structuring content security

  • Leveraging existing Windows authentication
  • Establishing permission levels on report items

Ensuring the RS system

  • Instituting varying levels of administrative roles
  • Granting and revoking system-level permissions

Creating reports on Analysis Services cubes

  • Exploiting cubes as intuitive data sources for nontechnical and power users
  • Generating parameterized reports with MDX Builder Designing reports for data visualization
  • Improving data visualization with sparklines, data bars, maps and indicators
  • Implementing Key Performance Indicators (KPIs)

Delivering reports to users

  • Accessing and controlling reports using URLs
  • Embedding reports in applications with the Report Viewer

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

SQL Server Reporting Services FAQs

No, however, this course was introduced to assist students who had been interested in the Microsoft 10990: Analyzing Data with SQL Server Reporting Services that was retired in December 2021.

Yes! Data analysis and data engineers both benefit from this course. This course is for anyone with database experience who wants to design, create, or deliver reports from relational or MDX compliant data sources.

This course uses Microsoft SQL Server 2019, running on Windows Server 2019.

Yes! This course is applicable to those using earlier versions of Microsoft SQL Server.