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 750,- €
  • SA Voucher: 5
    hardcoded default SA
Dates et Inscription
 
pointer une ville pour s'enregistrer Agenda
France
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
17.06. - 21.06.2019 Paris
24.06. - 28.06.2019 Bordeaux
23.09. - 27.09.2019 Aix-en-Provence
FLEX Training

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

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
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
09.09. - 13.09.2019 Berlin
07.10. - 11.10.2019 Stuttgart
Italie
27.05. - 31.05.2019 Rome
29.07. - 02.08.2019 Milan
21.10. - 25.10.2019 Rome
Royaume-Uni
01.04. - 05.04.2019 Birmingham
08.04. - 12.04.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
29.04. - 03.05.2019 Edinburgh
15.07. - 19.07.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
22.07. - 26.07.2019 Edinburgh
02.09. - 06.09.2019 Edinburgh
16.09. - 20.09.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
30.09. - 04.10.2019 Londres
Suisse
24.06. - 28.06.2019 Zürich
16.12. - 20.12.2019 Zürich
North America
Etats-Unis
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
Cours en ligne avec instructeur
Formation en mode FLEX™.