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

Book kursus nu

3 dage

14.700 kr. ex moms

Spar penge med et 4D klippekort

Udbydes som virksomhedskursus

Business Intelligence
Reporting Services SSRS
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: