Analyzing Data with SQL Server Reporting Services - MOC10990

Beschreibung

This five-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Wir empfehlen den Besuch unserer smart Seminare:

Nach Besuch des Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:
  • Describe reporting services and it’s components
  • Describe reporting services data sources
  • Implement paginated reports
  • Work with reporting services data
  • Visualize data with reporting services
  • Aggregate report data
  • Share reporting services reports
  • Administer reporting services
  • Expand and integrate reporting services
  • Describe mobile reports
  • Develop mobile reports
Weitere Seminare zum Thema

expand_more chevron_right Zielgruppe

Dieses Seminar richtet sich an
  • 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.

    expand_more chevron_right Vorkenntnisse

    Für dieses Seminar werden folgende Kenntnisse empfohlen :

    expand_more chevron_right Detail-Inhalte

    1. Module 1: Introduction to Reporting Services
    2. Lessons
      1. Introduction to reporting services
      2. Reporting services components
      3. Reporting services tools
    3. Lab: Exploring reporting services
      1. Exploring reports
      2. Reporting services configuration
    4. Module 2: Reporting Services Data Sources
    5. Lessons
      1. Data sources
      2. Connection strings
      3. Datasets
    6. Lab: Configuring data access with report builder
      1. Configuring data access with report builder
    7. Lab: Configuring data access with report designer
      1. Configuring data access with report designer
    8. Module 3: Creating Paginated Reports
    9. Lessons
      1. Creating a report with the report wizard
      2. Creating a report
      3. Publishing a report
    10. 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
    11. Module 4: Working with Reporting Services
    12. Lessons
      1. Data filters
      2. Report parameters
      3. Implementing report filters and parameters
    13. Lab: Create a parameterized report
      1. Using parameters in report designer
      2. Using parameters in report builder
    14. Module 5: Visualizing Data with Report Services
    15. Lessons
      1. Formatting data
      2. Images and charts
      3. Databars, sparklines, indicators, gauges, and maps
    16. Lab: Manage formatting
      1. Report designer
      2. Report builder
    17. Module 6: Summarizing Report
    18. Lessons
      1. Sorting and grouping
      2. Report sub-reports
      3. Drilldown and drill through
    19. Lab: Summarizing report data
      1. Sorting and grouping in report builder
      2. Sorting and grouping in report designer
    20. Module 7: Sharing Reporting Services
    21. Lessons
      1. Schedules
      2. Report caching, snapshots, and comments
      3. Report subscription and delivery
    22. Lab: Sharing reporting services reports
      1. Create a shared schedule
      2. Configure caching
      3. Subscribe to a report
    23. Module 8: Administering Reporting
    24. Lessons
      1. Administering reporting services
      2. Reporting services configuration
      3. Reporting services performance
    25. Lab: Administering reporting services
      1. Authorize access to reports
      2. Web portal branding
    26. Module 9: Extending and Integrating Reporting Services
    27. Lessons
      1. Expressions and embedded code
      2. Extending reporting services
      3. Integrating reporting services
    28. Lab: Extending and integrating reporting services
      1. Custom code – report designer
      2. Custom code – report builder
      3. URL access
    29. Module 10: Introduction to Mobile Reports
    30. Lessons
      1. Overview of mobile reports
      2. Preparing data for mobile reports
      3. Mobile report publisher
    31. Lab: Introduction to mobile reports
      1. Format data for a mobile report
      2. Create a mobile report
      3. Create KPIs
    32. Module 11: Developing Mobile Reports
    33. Lessons
      1. Designing and publishing mobile reports
      2. Drillthrough in mobile reports
    34. Lab: Developing mobile reports
      1. Add a dataset with parameters
      2. Design a mobile report
      3. Publish a mobile report
      4. Add a drillthrough to a custom URL
    online_prediction Virtual Classroom Demo oder Kontakt anfordern

    Kontaktoption wählen

    close
    Chat mit Experten Wir beantworten ihre Fragen direkt im live chat perm_phone_msg Rückrufservice Senden sie uns ihre Anfrage und unser Kundenservice ruft sie an group Beratungstermin Buchen Vereinbaren sie online direkt einen Beratungstermin.
    • expand_more chevron_right event_available 25.05.-27.05.2021 25.05.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom €2.465,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum €2.465,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 02.08.-04.08.2021 02.08.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom €2.465,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum €2.465,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 11.10.-13.10.2021 11.10.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom €2.465,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum €2.465,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services
    • expand_more chevron_right event_available 20.12.-22.12.2021 20.12.2021 Seminarzeitentimer5 Tage5 T roomETC-Wien Als Live-Stream verfügbaronline_predictionLive-Stream
      • expand_more chevron_right ETC Live - Virtual Classroom €2.465,00
        • Virtual Training – aber live im Seminar
        • Keine Anfahrt ins Seminarzentrum notwendig
        • Seminarunterlagen, Teamwork, Labs 24/7
        • ETC>Live Support und Hotline
        • ETC-Services

         

      • expand_more chevron_right ETC Classroom - im Seminarzentrum €2.465,00
        • Ihr ILT Seminar (Instructor Led Training)
        • Seminarunterlagen, Teamwork, Labs
        • Verpflegung vorort in einem der  ETC Seminarzentren
        • Seminar-Services

    Ähnliche Seminare

    SQL Business Intelligence: Datenmodelle mit Analysis Services

    event_available Nächster Termin: 19.04.2021

    SQL Business Intelligence: Datawarehouse und Integration Services

    event_available Nächster Termin: 03.05.2021

    SQL Server: Introduction to SQL Databases

    event_available Nächster Termin: 10.05.2021

    SQL Business Intelligence: Reporting Services

    event_available Nächster Termin: 25.05.2021