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
10.02. - 14.02.2020 Paris
15.06. - 19.06.2020 Paris
21.09. - 25.09.2020 Paris
16.11. - 20.11.2020 Paris
FLEX Training

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

03.02. - 07.02.2020 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
15.06. - 19.06.2020 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.06. - 19.06.2020 Berlin
27.07. - 31.07.2020 Berlin
26.10. - 30.10.2020 Hambourg
Italie
20.04. - 24.04.2020 Milan
20.07. - 24.07.2020 Rome
12.10. - 16.10.2020 Milan
Royaume-Uni
03.02. - 07.02.2020 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
23.03. - 27.03.2020 Manchester
27.04. - 01.05.2020 Birmingham
15.06. - 19.06.2020 FLEX training This is an Anglais language FLEX course.
Fuseau horaire: Europe/London
13.07. - 17.07.2020 Birmingham
07.09. - 11.09.2020 Leeds
Suisse
27.07. - 31.07.2020 Zürich
Moyen-Orient
Emirats-Arabes-Unis
12.04. - 16.04.2020 Dubai Langue: Anglais This course is being delivered by iTLS.
27.09. - 01.10.2020 Dubai Langue: Anglais This course is being delivered by iTLS.
Afrique
Egypte
02.02. - 06.02.2020 Le Caire Langue: Anglais
09.08. - 13.08.2020 Le Caire Langue: Anglais
Formation en mode FLEX™.