Analyzing Data with SQL Server Reporting Services

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.

Code
DB-REPORTS

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

Form
In our classroom or online

Questions about the course?


Ing. Jitka Sotonová

Ing. Jitka Sotonová

Leader of training center

+420 236 072 375
sotonova@oksystem.cz

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.

This course is intended for

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

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

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

Hardware

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

Literature

All participants will receive internal OKsystem materials.

PDF to download

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

Similar courses

Take a look at some similar courses from our wide range.

Subsidized course „Jsem v kurzu“

Analyzing Data with Excel DB-EXCEL


11 800 CZK Course detail
Authorized course Subsidized course „Jsem v kurzu“

Microsoft Power BI Data Analyst PL-300


21 800 CZK Course detail

Need some advice?

Do not hesitate to contact us. We are at your disposal and will be happy to help you.

Mgr. Barbora Záhlavová

Mgr. Barbora Záhlavová

More information about courses


+420 734 525 195
zahlavova@oksystem.cz

Ing. Lumír Vojtěchovský

Ing. Lumír Vojtěchovský

More information about courses


+420 724 332 135
vojtechovsky@oksystem.cz

Why OKškolení?

What are the main advantages of our training centre?

About us

Contact us

Do not hesitate to contact us with any questions you may have.

Simona Dianová

Simona Dianová

Training and test organization


+420 236 072 251
dianova@oksystem.cz

Ing. Dana Černá

Ing. Dana Černá

Certification tests


+420 236 072 318
cernad@oksystem.cz

Do you need to know more about us or would you prefer to contact us using the form?

Contact page

OKškolení is part of OKsystem a.s.