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

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
    • expand_more chevron_right event_available 15.03.-17.03.2021 15.03.2021 Seminarzeitentimer3 Tage3 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 25.05.-27.05.2021 25.05.2021 Seminarzeitentimer3 Tage3 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 Seminarzeitentimer3 Tage3 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 Seminarzeitentimer3 Tage3 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 Seminarzeitentimer3 Tage3 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