SQL Server Reporting Services 2016 (SSRS) Introduction (conducted in English)

Kursusmål 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 paginated reports, mobile reports and Key Performance Indicators (KPI).

  • 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 Mobile Reports
  • Create Key Performance Indicators (KPI)
  • Create Subscriptions
  • Manage Security

Deltagere 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, ...

Vis mere

... 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.
Kursusmateriale 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.

Kursus indhold 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 - Mobile Reports

This module describes how to create mobile reports with SQL Server Mobile Report Publisher and how to create Key Performance Indicators (KPI) in the new SQL Server Reporting Services web portal.
  • Shared Data Sets
  • Create Reports with SQL Server Mobile Report Publisher
  • Reports and Mobile Devices
  • Create Key Performance Indicators (KPI)
Module 8 - 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 9 - 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
Du kan finde alle informationer om dette kursus ved at gå ind på http://www.4d.dk/Kurser/Backoffice/Business_Intelligence_(BI)/Ikke_angivet/661468

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.

SQL Server Reporting Services 2016 (SSRS) Introduction (conducted in English)

Forhandler
4D konsulenterne
Normalpris
11.400,00 kr
Udsalgspris
11.400,00 kr
Normalpris
Udsolgt
Pris pr. stk.
pr. 
Eksklusiv moms.

Efter aftale / Kontakt for pris

Hvis du har valgt Efter aftale, kan du udfylde formularen nedenfor og så vender vi tilbage til dig og aftaler nærmere.

Har du spørgsmål?

Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.