Analyzing Data with SQL Server Reporting Services

DB-REPORTS

This 4-day instructor led course provides students with analyzing data using Microsoft SQL Server Reporting Services. The course discusses how to use the development tools to create and manage reports, manage, expand Reporting Services and implement self-service BI solutions.

Course length: 4 days (8:30 - 16:00)

List price: 22 000 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

PDF to download Expand allCollapse all

  • Students will be able to

    • Describe key features of data modeling and various report services within business intelligence
    • Create reports with Reporting Services
    • Enhance reports with graphics and parameters
    • Expand and integrate reporting services
    • Manage report execution and delivery
    • Create Mobile reports

  • Course requirements

    • T-SQL language
    • Basic knowledge of the Microsoft Windows operating system

  • This course is intended for

    • This course is intended for end users, Database Administrators, Database Developers, and BI professionals.

  • Literature

    All participants will receive internal OKsystem materials.

  • Hardware

    Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

  • Syllabus

    Module 1: Introduction to Reporting Services

    • Lesson 1: Introduction to reporting services
    • Lesson 2: Reporting services components
    • Lesson 3: Reporting services tools
    • Lab: Exploring reporting services

    Module 2: Reporting Services Data Sources

    • Lesson 1: Data sources
    • Lesson 2: Connection strings
    • Lesson 3: Datasets
    • Lab: Configuring data access with report builder

    Module 3: Creating Paginated Reports

    • Lesson 1: Creating a report with the report wizard
    • Lesson 2: Creating a report
    • Lesson 3: Showing data graphically in a report
    • Lab: Creating a report

    Module 4: Working with Reporting Services Data

    • Lesson 1: Data filters
    • Lesson 2: Report parameters
    • Lesson 3: Implementing report filters and parameters
    • Lab: Create a parameterized report

    Module 5: Visualizing Data with Report Services

    • Lesson 1: Formatting data
    • Lesson 2: Images and charts
    • Lesson 3: Databars, sparklines, indicators, gauges, and maps
    • Lab: Manage formatting

    Module 6: Summarizing Report Data

    • Lesson 1: Sorting and grouping
    • Lesson 2: Report sub-reports
    • Lesson 3: Drilldown and drill through
    • Lab: Summarizing report data

    Module 7: Sharing Reporting Services Reports

    • Lesson 1: Schedules
    • Lesson 2: Report caching, snapshots, and comments
    • Lesson 3: Report subscription and delivery
    • Lab: Sharing reporting services reports

    Module 8: Administering Reporting Services

    • Lesson 1: Administering reporting services
    • Lesson 2: Reporting services configuration
    • Lesson 3: Reporting services performance
    • Lab: Administering reporting services

    Module 9: Extending and Integrating Reporting Services

    • Lesson 1: Expressions and embedded code
    • Lesson 2: Extending reporting services
    • Lesson 3: Integrating reporting services
    • Lab: Extending and integrating reporting services

    Module 10: Introduction to Mobile Reports

    • Lesson 1: Overview of mobile reports
    • Lesson 2: Preparing data for mobile reports
    • Lesson 3: Mobile report publisher
    • Lab: Introduction to mobile reports

    Module 11: Developing Mobile Reports

    • Lesson 1: Designing and publishing mobile reports
    • Lesson 2: Drillthrough in mobile reports
    • Lab: Developing mobile reports

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.