Analysing Data with SQL Server Reporting Services (Online Training)

0

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

Get To Know The Trainer

Trainer Gerald

 

Gerald has 22 years of information technology experience and on community service and event experiences, he excels impressively. He was invited as a speaker for 3 break-out sessions for Microsoft TechED SEA 2008 on SQL Server 2008 at Kuala Lumpur Convention Center

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

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

CLASS DETAILS

  • TBC
  • 9am - 5pm (incl.1 hour lunch break)
  • Promo - Sign-up and get 1 seat FREE for any Live Online Soft Skill Public Class
    *T&C applies

ALL IN FROM ONLY

RM3,500/PAX

*T&C Applies

What Other People Bought

error: Content is protected !!

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?