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

 

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

Durée 5 jours

Prix (Hors Taxe)
  • France: 2 750,- €
  • SA Voucher: 5
    hardcoded default SA
 
pointer une ville pour s'enregistrer Agenda
France
23.09. - 27.09.2019 Aix-en-Provence
23.09. - 27.09.2019 Paris
07.10. - 11.10.2019 Lyon
21.10. - 25.10.2019 Toulouse
18.11. - 22.11.2019 Nantes
18.11. - 22.11.2019 Rennes
25.11. - 29.11.2019 Lille
02.12. - 06.12.2019 Bordeaux
02.12. - 06.12.2019 Paris
02.12. - 06.12.2019 Strasbourg
FLEX Training

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

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
07.10. - 11.10.2019 Stuttgart
04.11. - 08.11.2019 Francfort
25.11. - 29.11.2019 Münster
16.12. - 20.12.2019 Munich
Italie
21.10. - 25.10.2019 Rome
Royaume-Uni
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
14.10. - 18.10.2019 Birmingham
11.11. - 15.11.2019 Londres
02.12. - 06.12.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
13.01. - 17.01.2020 Glasgow
20.01. - 24.01.2020 Birmingham
Suisse
16.12. - 20.12.2019 Zürich
North America
Etats-Unis
26.08. - 30.08.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: US/Pacific
23.09. - 27.09.2019 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: US/Pacific
Moyen-Orient
Emirats-Arabes-Unis
15.12. - 19.12.2019 Dubai Langue: Anglais This course is being delivered by iTLS.
Afrique
Egypte
15.12. - 19.12.2019 Le Caire Langue: Anglais
Formation en mode FLEX™.