×

MS-10990 - Analyzing Data with SQL Server Reporting Services

This five-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


Before attending this course, students must have:
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL, such as that taught in 20761C.

Detailed Class Syllabus


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
Drilldown 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
Drillthrough in mobile reports