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

You will learn

In this course you will learn how to develop and author reports with Microsoft SQL Server Reporting Services. Microsoft SQL Server Reporting Services is a tool targeting you that wants to develop reports and share and manage these on a central report server. You will learn how to develop paginated reports with rich formatting and deliver scheduled reports in multiple formats like HTML, Excel and PDF.
  • Configure Microsoft SQL Server Reporting Services
  • Create Data Sources
  • Create Data Sets
  • Create Reports using the Tablix Data Region
  • Create Reports with Charts, Data Bars, Sparklines, and Indicators
  • Create interactive Reports with drill down and drill through
  • Publish 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.
  • Full accommodation, 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.

Get the best benefit from the course

This is a technical course and we expect that you have attended our "SQL basic course” or have acquired similar experience.

This Reporting Services (SSRS) cource is a part of 4D's unique collection of English conducted courses.

Course Details

Module 1 – Introducing Microsoft SQL Server Reporting Services
In this module you will get an overview of Microsoft SQL Server Reporting Services and the tools used for developing reports, managing reports, and configuring the Microsoft SQL Server Reporting Services.

The following will be covered:
  • 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
In this module you will learn to author basic reports, including configuring data sources and data sets, creating tabular reports, summarizing data, and applying basic formatting with expressions.


The following will be covered:
  • Data Sources
  • Data Sets
  • Tablix Data Region
  • Sorting Data
  • Headers and Footers
  • Aggregating Data
  • Expressions and conditional Formatting

Module 3 – Grouping and enhancing basic Reports
In this module you will learn how to group data in reports and how to implement drill down. You will also learn how to render reports in different formats like Excel and PDF.


The following will be covered:
  • Grouping data in Reports
  • Drill-down and Document Maps
  • Export Reports to different formats

Module 4 – Using Parameters and advanced Data Sets in Reports
In this module you will learn to interact with data and reports using parameters. You will also learn how to create reports using multiple data sources with expressions and drill through actions.

The following will be coverd:
  • Query Parameters
  • Report Parameters
  • Parameter Lists
  • Stored Procedures
  • Reports using multiple Data Sources
  • Interactivity with Actions

Module 5 – Graphical Reports
In this module you will learn how to create graphical reports using different types of charts. You will also learn how to use data bars, sparklines, and indicators.

The following will be covered:
  • Charts
  • Data Bars, Sparklines, and Indicators

Module 6 – Publishing and Executing Reports
In this module you will learn about the various options to publish reports to the report server and how to configure report execution. You will also learn about the various options of using SQL Server Reporting Services with Power BI.

The following will be covered:
  • Publishing Reports
  • Maintaining Data Sources
  • Caching Reports
  • SQL Server Reporting Services and Power BI


Module 7 – Using Subscriptions
In this module you will learn how to implement subscriptions to distribute reports by schedule in different formats like Excel and PDF either by e-mail or to a shared folder.

The following will be covered:
  • Standard Subscriptions
  • Data-driven Subscriptions

Module 8 – Managing Security
In this module you will learn how to plan and implement security in Microsoft SQL Server Reporting Services. You will learn how to grant access on the site level and item level securing your server, folders, and reports.

The following will be covered:
  • Security on the Site Level
  • Security on Folders and Reports
  • User defined Roles
  • Linked Reports

Hold dig opdateret med vores nyhedsbrev

Modtag nyheder, gode tilbud, tips og tricks med vores månedlige nyhedsbrev.

Vi har både et Office/Adobe nyhedsbrev og et nyhedsbrev for vores tekniske Microsoft kurser.

Her bor vi

Hovedindgang
Amagertorv 21
1160 København K
Kursusindgang
Læderstræde 22-26
1201 København K
Åbningstider
Mandag: 08.00 - 16.30 (Indgang for kursister i Læderstræde åbner 8.30) 
Tirsdag: 08.30 - 16.30
Onsdag: 08.30 - 16.30
Torsdag: 08.30 - 16.30
Fredag: 08.30 - 16.30

 

Kontaktoplysninger

 
Amagertorv 21
1160 København K