Analyse de données avec SQL Server 2016 Reporting Services (10990)

Course Description Agenda
 

A qui s'adresse cette formation

The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.

The secondary audiences for this course are power information workers.

Pré-requis

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

  • Écrire des requêtes Transact SQL pour SQL Server 2016 (20761)

Objectifs

After completing this course, students will be able to:

  • Describe key features of data modelling within business intelligence
  • Describe various report services data sources and how these are configured
  • Create reports with report designer and/or report designer
  • Configure reports with report designer and/or report builder
  • Create SQL Server mobile reports

Contenu

Detailed Course Outline

Module 1: Introduction to Business Intelligence and Data Modelling In this module students will be introduced to the key concepts in business intelligence, and the Microsoft BI product suite.

Lessons

  • Introduction to business intelligence
  • The Microsoft business intelligence platform
  • Introduction to reporting services

Lab : Exploring an enterprise BI solution

Module 2: Reporting Services Data Describe various Report Services data sources and how these are configured.

Lessons

  • Data connections
  • Connection strings
  • Filters and parameters

Lab : Configuring a data connection

Module 3: Implementing reports Create reports with report designer or report builder.

Lessons

  • Creating a report with the report wizard
  • Creating a report
  • Showing data graphically

Lab : Creating a report

Module 4: Configuring reports This module describes how to configure reports with report builder or report designer.

Lessons

  • Implementing filters and parameters
  • Implementing sorting and grouping
  • Publishing a report

Lab : Creating a map report

Module 5: Creating Mobile Reports This module describes how to create SQL Server mobile reports.

Lessons

  • Overview of SQL Server mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Lab : Mobile reports

Classroom training
Modality: G

Durée 5 jours

Prix (Hors Taxe)
  • France: 2 690,- €
  • SA Voucher: 5
    hardcoded default SA
Dates et Inscription
 
pointer une ville pour s'enregistrer Agenda
France
04.02. - 08.02.2019 Paris
11.03. - 15.03.2019 Aix-en-Provence
18.03. - 22.03.2019 Lyon
08.04. - 12.04.2019 Toulouse
13.05. - 17.05.2019 Nantes
13.05. - 17.05.2019 Rennes
13.05. - 17.05.2019 Strasbourg
17.06. - 21.06.2019 Lille
FLEX Training

Please see below our alternative, English language, FLEX course option.

21.01. - 25.01.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
08.04. - 12.04.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
15.07. - 19.07.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
16.09. - 20.09.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
02.12. - 06.12.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.

Europe
Allemagne
18.02. - 22.02.2019 Hambourg
18.03. - 22.03.2019 Berlin
15.04. - 18.04.2019 Stuttgart 4 jours
13.05. - 17.05.2019 Francfort
03.06. - 07.06.2019 Münster
24.06. - 28.06.2019 Munich
15.07. - 19.07.2019 Hambourg
12.08. - 16.08.2019 Düsseldorf
Italie
27.05. - 31.05.2019 Rome
29.07. - 02.08.2019 Milan
21.10. - 25.10.2019 Rome
Royaume-Uni
21.01. - 25.01.2019 London (Int Hse)
21.01. - 25.01.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
28.01. - 01.02.2019 Birmingham
11.02. - 15.02.2019 Edinburgh
11.02. - 15.02.2019 London (Int Hse)
11.03. - 15.03.2019 Manchester
01.04. - 05.04.2019 Birmingham
08.04. - 12.04.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
Suisse
24.06. - 28.06.2019 Zürich
16.12. - 20.12.2019 Zürich
North America
Etats-Unis
21.01. - 25.01.2019 Formation en ligne Fuseau horaire: US/Central Langue: Anglais garanti !
01.04. - 05.04.2019 Formation en ligne Fuseau horaire: US/Central Langue: Anglais
Moyen-Orient
Emirats-Arabes-Unis
23.06. - 27.06.2019 Dubai Langue: Anglais This course is being delivered by iTLS.
15.12. - 19.12.2019 Dubai Langue: Anglais This course is being delivered by iTLS.
Qatar
23.06. - 27.06.2019 Doha Langue: Anglais
Afrique
Egypte
23.06. - 27.06.2019 Le Caire Langue: Anglais
15.12. - 19.12.2019 Le Caire Langue: Anglais
Fast Lane s’engage à mettre en œuvre les formations garanties quelque soit le nombre de participants, en dehors des cas de force majeurs ou d’événements exceptionnels, comme un accident ou un maladie de l’instructeur.
Cours en ligne avec instructeur
Formation en mode FLEX™.