Call Us: +32 2 466 00 16
Follow Us:

Microsoft SQL Server Reporting Services

Training code

Upcoming sessions

08 Jun 2020
14 Sep 2020
16 Nov 2020
Book this course

Introduction to Microsoft SQL Server Reporting Services 2012 and later

In this module you will get a birds eye view of the capabilities of Reporting Services, as an introduction into the next modules which dive deeper in each aspect of Reporting Services.

  • Overview of Microsoft SQL Server Reporting Services
  • Tour of SQL Server Reporting Services
  • Overview of Reporting Services architecture

Authoring Basic Reports

A basic Reporting Services report consists of a data source, a data set and one or more visualizations. This module shows you how to build such a basic report with the wizard as well as with the SQL Server Data Tools report designer.

  • Creating a basic table report
  • Formatting report pages
  • Calculating values

Manipulating Data Sets

You can control the queries which are used to load the data in your reports. This can be used amongst others to create parameterized reports. In this module you will learn two different ways to add parameters to your report, create dependant parameters and more.

  • Defining report data
  • Using parameters and filters
  • Using parameter lists

Report Enhancements

Often users want to interact with a report, e.g. drill down in more detailed data, link one report to another, sort data interactively or create a table of content. All these kinds of features are discussed in this module on report enhancements.

  • Interactive navigation
  • Displaying data
  • Multi-select parameters
  • Interactive column sorting
  • Floating headers

Advanced Report Components

Our brain is still wired to recognize trends in data more rapidly from a graphical representation than from an endless list of numbers. That's why charts, maps and other data visualizations are so popular. But in this module you will learn that we can even combine text and charts in a single table or matrix!

  • Advanced charting and sparklines
  • Plotting data on maps
  • Visualizing KPIs

Report On OLAP Data

Cubes or OLAP databases such as Analysis Services often make it easier and deliver better performance when running typical business intelligence queries compared to relational databases. That's why Reporting Services supports OLAP databases, both from Microsoft as well as other vendors. In this module you will see the special functionality offered by Reporting Services on top of these OLAP databases.

  • What is OLAP and MDX
  • Running Analysis Services based reports
  • Using the OLAP query builder

Mobile And KPI Reports

With the acquisition of DataZen Microsoft added support for mobile reports to their product. In this module you learn to build reports which adjust to a smaller form factor when running on a tablet or smartphone.

  • Building reports for multiple devices
  • Building multi-device designs
  • Visualizing KPIs directly in the portal

Managing Content

After a report has been created and tested in SQL Server Data Tools it's time to deploy the reports to the server. But once it's deployed, their are still many report properties that can be configured on the server. This module shows you the different options.

  • Publishing content
  • Executing reports
  • Creating cached instances
  • Creating snapshots and report history
  • Creating report subscriptions

Administering Reporting Services

As with so many application servers, also Reporting Services requires the server to be configured, backed up, secured etc.

  • Server administration
  • Performance and reliability monitoring
  • Database administration
  • Security administration

Programming Reporting Services

Programming against Reporting Services can be done in two ways: Either we embed Reporting Services in another application (as a wrapper around SSRS), or we write code that runs within Reporting services. Both of these options are explained in this module.

  • Querying server information
  • Automating report management
  • Rendering reports
  • Creating custom code

Self-service Reporting

Reporting Services can be used not only by BI developers who feel at home in Visual Studio, it is also a tool that can be used by less technical business users. To assist them, the Report Builder tool can be used to modify existing reports or create new reports. Furthermore, shared data sets and report parts make it possible for more technical users to create building blocks that can then be used by others to create their reports.

  • SQL Server Report Builder
  • Creating and configuring shared data sets
  • Developing shared report parts
  • Building reports with shared data sets and report parts

Branding Reporting Services

Unfortunately Reporting Services does not have traditional CSS files to easily control the look and feel of the portal and reports. But in this module you will learn about the options available to do some branding on SSRS.

  • The new branding functionality
  • A closer look at the default branding
  • Creating your own design
  • Uploading and activating your branding

This course introduces the SQL Server Reporting Services platform, and teaches the necessary skills to develop, deploy and maintain Reporting Services reports on SQL Server 2012, 2014, 2016 and 2017.

This course is intended for database administrators, database developers, IT professionals, and partners who have a basic SQL Server experience.

© 2020 U2U All rights reserved.