Seminar Details

Analyzing Data with SQL Server Reporting Services (MOC10990)

Hersteller-ID: 10990
Prüfungs ID:
Dauer: 5 Tage
Preis: € 2.465.- exkl.MwST
Wissensgarantie: 12 Monate
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

Alle Details einblenden

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.

Vorkenntnisse

Für dieses Seminar werden folgende Kenntnisse empfohlen :

Schwerpunkte

  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
Alle Details ausblenden

1 Termin wählen

Was ist:
ILT

Ihr Klassenraumtraining - mehr Infos zu Instructor Led Trainings bei ETC erhalten Sie HIER

Live

Ihr virtuelles Training - mehr Infos zu ETC>Live erhalten Sie HIER

Hybrid VBT

Mehr Infos zu VBTs erhalten Sie HIER

Hybrid MOOC

Mehr Infos zu MOOCs erhalten Sie HIER

Hotseat

Mehr Infos zum ETC Hotseat erhalten Sie HIER

Info

zusätzliche Infos zum Seminartermin

Alle Preise exkl. Mwst.

2 Paket wählen

Analyzing Data with SQL Server Reporting Services

Preis

  • Ihr ILT Seminar (Instructor Led Training)
  • Seminarunterlagen, Teamwork, Labs
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.465.-
(€ 2.465.- p.P.)

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

Bisher keine Bewertungen