SQL Server Reporting Services (SSRS) Basic (conducted in English) kursus

You will learn

This course is focusing on developing reports with Microsoft SQL Server Reporting Services 2016. Microsoft SQL Server Reporting Services is a tool targeting students who wants to develop reports and share and manage these on a central report server. Microsoft SQL Server Reporting Services 2016 is a key product among Microsoft's business intelligence tools and have developed extensively over the last years and is a huge leap forward and makes it possible to develop simple paginated reports and advanced reports with charts and drill through actions.
  • Configuring Microsoft SQL Server Reporting Services 2016
  • Create Data Sources
  • Create Data Sets
  • Create Reports using the Tablix Data Region
  • Create Reports with Charts, Data Bars, Sparklines, and Indicators
  • Interactive Reports
  • Publishing Reports
  • Create Subscriptions
  • Manage Security

You get

During the course
  • Teaching by the most experienced instructor team in our cozy and fully updated classrooms located in the center of Copenhagen.
  • A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses.
  • A course material you can use as an encyclopedia after the course and downloads of course exercises.
  • All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch in an Italian restaurant on Gråbrødretorv, cake, candy and off course Wi-Fi to your devices.
  • A course certificate as a proof of your new skills.
After the course
  • Access to our free hotline service, which means that you up to a year after the completing of the course can contact us if you have questions regarding subjects from the course.
  • We have a unique satisfaction guarantee in order to ensure you the complete benefit from the course.

Get the best benefit from the course

This is a technical course and we expect that you have attended our "SQL Grundlæggende kursus” and "SQL Udvidet kursus” or have acquired similar experience about business intelligence, dimensional data modelling and SQL. Knowledge of programming with VB is an advantage as well

The course is targeting students that uses Microsoft SQL Server Reporting Services 2016.

Course Details

Module 1 – Introducing Microsoft SQL Server Reporting Services


This module describes Microsoft SQL Server Reporting Services and the tools used for developing reports, manage reports, and configuring the Microsoft SQL Server Reporting Services.
  • The Microsoft SQL Server Reporting Services Report Cycle
  • Configuring Microsoft SQL Server Reporting Services
  • Tools to manage Reports and the Report Server
  • Microsoft SQL Server Reporting Services Solutions

Module 2 – Authoring Basic Reports


This module describes the fundamentals of report authoring, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting.
  • Data Sources
  • Data Sets
  • Tablix Data Region
  • Grouping Data
  • Sorting Data
  • Headers and Footers
  • Aggregating Data
  • Expressions and conditional Formatting
Module 3 – Enhancing basic Reports

This module describes how to create reports with navigational controls and how to render reports in different formats.
  • Drill-down, Document Maps, and Actions
  • Export Reports to different formats
Module 4 – Using Parameters and advanced Data Sets in Reports


This module describes how to interact with a data set through the use of parameters and how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query, as well as best practices to implement static and dynamic parameter lists.
  • Query Parameters
  • Report Parameters
  • Parameter Lists
  • Stored Procedures
  • Reports using multiple Data Sources
Module 5 – Graphical Reports

This module describes how to create reports using charts, data bars, sparklines, and indicators.
  • Charts
  • Data Bars, Sparklines, and Indicators

Module 6 – Publishing and Executing Reports

This module describes the various options to publish reports to the report server and execute them.
  • Publishing Reports
  • Maintaining Data Sources
  • Caching Reports
  • Reports and Power BI

Module 7 – Using Subscriptions

This module describes how to implement subscriptions to distribute reports either automatically by e-mail, publishing reports to a shared folder, or publishing reports to a SharePoint library.
  • Standard Subscriptions
  • Data-driven Subscriptions
Module 8 – Managing Security

This module describes how to plan and implement security on Microsoft SQL Server Reporting Services.
  • Security on the Site Level
  • Security on Folders and Reports
  • User defines Roles
  • Linked Reports

Kontaktoplysninger

Adresse
Amagertorv 21
1160 København K