Menu

Gerald Hoong

  • 8 hours of Live Online / Virtual Training
  • E-WorkBook
  • E-Cert

Course Objectives

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

Pre-requisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL, such as that taught in 20761C.

Target Audience

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

Methodology

This program will be conducted with interactive lectures, discussions and practical exercises

Course Modules

  • Module 1: Introduction to Reporting Services
    – Introduction to reporting services
    – Reporting services components
    – Reporting services tools
  • Module 2: Reporting Services Data Sources 
    – Data sources
    – Connection strings
    – Datasets
  • Module 3: Creating Paginated Reports
    – Creating a report with the report wizard
    – Creating a report
    – Publishing a report
  • Module 4: Working with Reporting Services Data
    – Data filters
    – Report parameters
    – Implementing report filters and parameters
  • Module 5: Visualizing Data with Report Services
    – Formatting data
    – Images and charts
    – Databars, sparklines, indicators, gauges, and maps
  • Module 6: Summarizing Report Data 
    – Sorting and grouping
    – Report sub-reports
    – Drill down and drill through
  • Module 7: Sharing Reporting Services Reports
    – Schedules
    – Report caching, snapshots, and comments
    – Report subscription and delivery
  • Module 8: Administering Reporting Services
    – Administering reporting services
    – Reporting services configuration
    – Reporting services performance
  • Module 9: Extending and Integrating Reporting Services
    – Expressions and embedded code
    – Extending reporting services
    – Integrating reporting services
  • Module 10: Introduction to Mobile Reports
    – Overview of mobile reports
    – Preparing data for mobile reports
    – Mobile report publisher
  • Module 11: Developing Mobile Reports
    – Designing and publishing mobile reports
    – Drill through in mobile reports

Contact us for more information

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?