SQL Business Intelligence: Reporting Services

Datum
09/12/2020 - 11/12/2020
9:00 - 17:00
Kalender-Import: iCal

Veranstaltungsort
ETC Trainingcenter
Modecenterstrasse 22, 1030 - Wien





Dieser Kurs wird auf Basis von SQL Server 2016 abgehalten.
Der überwiegende Anteil der erworbenen Kenntnisse ist abwärtskompatibel (bis inkl. SQL Server 2008).

Ausgenommen sind neu hinzugekommene, versionsspezifische Features, auf die im Rahmen des Kurses hingewiesen wird.

Lernen Sie in diesem Kurs wie Sie Ihre Daten richtig visualisieren und mittels Drill-through bis auf die Detailebene analysieren. Eindrucksvolle Reports für Präsentationen oder auch die Darstellung auf Ihrem Mobile Device sind nach diesem Kurs eine Leichtigkeit für Sie.

Dieses Seminar wird auf Basis des offiziellen MOC (Microsoft Official Curriculum) Trainings durchgeführt:

Nach Abschluss des Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:

  • Reporting Services Datenquellen
  • Erstellen von Reporting Services Berichten mit „Report Designer“ und „Report Builder“
  • Administration des Reportings (Konfiguration, Performance uvm)
    • Mögliche Zertifizierung: MCSE: Data Management & Analytics

      Vorkenntnisse:
      Für dieses Seminar werden folgende Kenntnisse empfohlen:

      Kurs Inhalte:

      1. Introduction to Reporting Services
        1. Introduction to reporting services
        2. Reporting services components
        3. Reporting services tools
        4. Lab: Exploring reporting services
          1. Exploring reports
          2. Reporting services configuration
      2. Reporting Services Data Sources
        1. Data sources
        2. Connection strings
        3. Datasets
        4. Lab: Configuring data access with report builder
          1. Configuring data access with report builder
        5. Lab: Configuring data access with report designer
          1. Configuring data access with report designer
      3. Creating Paginated Reports
        1. Creating a report with the report wizard
        2. Creating a report
        3. Publishing a report
        4. Lab: Creating reports
          1. Use the report wizard – report designer
          2. Use the report wizard – report builder
          3. Creating and publishing a report – report designer
          4. Creating and publishing a report – report builder
      4. Working with Reporting Services
        1. Data filters
        2. Report parameters
        3. Implementing report filters and parameters
        4. Lab: Create a parameterized report
          1. Using parameters in report designer
          2. Using parameters in report builder
      5. Visualizing Data with Report Services
        1. Formatting data
        2. Images and charts
        3. Databars, sparklines, indicators, gauges, and maps
        4. Lab: Manage formatting
          1. Report designer
          2. Report builder
      6. Summarizing Report
        1. Sorting and grouping
        2. Report sub-reports
        3. Drilldown and drill through
        4. Lab: Summarizing report data
          1. Sorting and grouping in report builder
          2. Sorting and grouping in report designer
      7. Sharing Reporting Services
        1. Schedules
        2. Report caching, snapshots, and comments
        3. Report subscription and delivery
        4. Lab: Sharing reporting services reports
          1. Create a shared schedule
          2. Configure caching
          3. Subscribe to a report
      8. Administering Reporting
        1. Administering reporting services
        2. Reporting services configuration
        3. Reporting services performance
        4. Lab: Administering reporting services
          1. Authorize access to reports
          2. Web portal branding
      9. Extending and Integrating Reporting Services
        1. Expressions and embedded code
        2. Extending reporting services
        3. Integrating reporting services
        4. Lab: Extending and integrating reporting services
          1. Custom code – report designer
          2. Custom code – report builder
          3. URL access
      10. Introduction to Mobile Reports
        1. Overview of mobile reports

      Anmeldelink: https://www.etc.at/seminare/SQLBI-R

      Preis: 1465

      Kategorien


Mehr Artikel