Analyzing Data with SQL Server Reporting Services

M10990

Ημερομηνία Έναρξης
Σε αναμονή
Διάρκεια
40 hours
Κόστος
Εξέταση - Πιστοποίηση

Audience profile

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.

Prerequisites

  • M20761 Querying Data with Transact SQL

 

Course outline

INTRODUCTION TO REPORTING SERVICES

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

Lab : Exploring reporting services

REPORTING SERVICES DATA SOURCES

  • Data sources
  • Connection strings
  • Datasets

Lab : Configuring data access with report builder

Lab : Configuring data access with report designer

CREATING PAGINATED REPORTS

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

Lab : Creating reports

WORKING WITH REPORTING SERVICES DATA

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

Lab : Create a parameterized report

VISUALIZING DATA WITH REPORT SERVICES

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

Lab : Manage formatting

SUMMARIZING REPORT DATA

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

Lab : Summarizing report data

SHARING REPORTING SERVICES REPORTS

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

Lab : Sharing reporting services reports

ADMINISTERING REPORTING SERVICES

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

Lab : Administering reporting services

EXTENDING AND INTEGRATING REPORTING SERVICES

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

Lab : Extending and integrating reporting services

INTRODUCTION TO MOBILE REPORTS

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

Lab : Introduction to mobile reports

DEVELOPING MOBILE REPORTS

  • Designing and publishing mobile reports
  • Drillthrough in mobile reports

Lab : Developing mobile reports

Δήλωσε Συμμετοχή

Προέκυψε κάποιο σφάλμα

Παρακαλούμε προσπαθήστε ξανά σε λίγο

Επιτυχής Εγγραφή

Σύντομα θα επικοινωνήσουμε μαζί σας.