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 09.12.-11.12.2020 09.12.2020 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 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