Analyzing Data with SQL Server Reporting Services

Datum
02/08/2021 - 04/08/2021
Ganztägig
Kalender-Import: iCal

Veranstaltungsort
ETC Trainingcenter
Modecenterstrasse 22, 1030 - Wien




Für dieses Seminar werden folgende Kenntnisse empfohlen :

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

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.

  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

Kategorien


Mehr Artikel