Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-10990 - Analyzing Data with SQL Server Reporting Services

This three-day instructor-led course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Click here to print this page »

Prerequisites


In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
  • 20761: Querying Data with Transact-SQL

Detailed Class Syllabus


Module 1: Introduction to Business Intelligence and Data Modelling


Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services

Module 2: Reporting Services Data


Data connections
Connection strings
Datasets
Filters and parameters

Module 3: Implementing reports


Creating a report with the report wizard
Creating a report
Showing data graphically

Module 4: Configuring reports


Implementing filters and parameters
Implementing sorting and grouping
Publishing a report

Module 5: Creating Mobile Reports


Overview of SQL Server mobile reports
Preparing data for mobile reports
SQL Server Mobile report publisher