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.

Student Testimonials

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


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

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

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