Cours M10990-C
Analyzing Data with SQL Server Reporting Services

Doelstelling
  • 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.
Inhoud

Introduction to Reporting Services

  • Introduction to reporting services
  • Reporting services components
  • Reporting services tools

Reporting Services Data Sources

  • Connection strings
  • Datasets

Creating Paginated Reports

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report

Working with Reporting Services Data

  • Data filters
  • Report parameters
  • Implementing report filters and parameters

Visualizing Data with Report Services

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps

Summarizing Report Data

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through

Sharing Reporting Services Reports

  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery

Administering Reporting Services

  • Administering reporting services
  • Reporting services configuration
  • Reporting services performance

Extending and Integrating Reporting Services

  • Expressions and embedded code
  • Extending reporting services
  • Integrating reporting services

Introduction to Mobile Reports

  • Overview of mobile reports
  • Preparing data for mobile reports
  • Mobile report publisher

Developing Mobile Reports

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Details

Duur
5 dagen
Deelnemers
8
Bestemd voor
IT-specialist
Voorkennis
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL, such as that taught in 20761C.