10990 Analyzing Data with SQL Server Reporting Services
11/16/2020 - 11/20/2020



COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
Register for this course


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.


The primary audience for this course is database professionals who need to fulfil a BI developer role to create reports. Primary responsibilities will include implementing reports and mobile reports.
The secondary audiences for this course are power information workers.

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

• 20761A/B: Querying Data with Transact-SQL


*Course Cost listed does not include the cost of courseware. Course is subject to a minimum enrollment to run. If the minimum enrollment is not met, this course may run as a virtual instructor led. If you have any questions, please contact us (learn@vtec.org or 207-775-0244)


At Course Completion
Describe reporting services and it’s components
Describe reporting services data sources
Implement paginated reports
Work with reporting services data
Visualize data with reporting services
Aggregate report data
Share reporting services reports
Administer reporting services
Expand and integrate reporting services
Describe mobile reports
Develop mobile reports

Module 1: Introduction to Business Intelligence and Data Modeling
Introduction to business intelligence
Reporting services components
Reporting services tools
Lab : Exploring reporting services

Module 2: Reporting Services Data
Data sources
Connection strings
Lab : Configuring data access with report builder
Lab : Configuring data access with report designer

Module 3: Creating Paginated Reports
Creating a report with the report wizard
Creating a report
Publishing a report
Lab : Creating reports
Use the report wizard – report designer
Use the report wizard – report builder
Creating and publishing a report – report designer
Creating and publishing a report – report builder

Module 4: Working with Reporting Services Data
Data filters
Report parameters
mplementing report filters and parameters
Lab : Create a parameterized report
Using parameters in report designer
Using parameters in report builder

Module 5: Visualizing Data with Report Services
Formatting data
Images and charts
Databars, sparklines, indicators, gauges, and maps
Lab : Manage formatting
Report designer
Report builder

Module 6: Summarizing Report Data
Sorting and grouping
Report sub-reports
Drilldown and drill through
Lab : Summarizing report data
Sorting and grouping in report builder
Sorting and grouping in report designer

Module 7: Sharing Reporting Services Reports
Report caching, snapshots, and comments
Report subscription and delivery
Lab : Sharing reporting services reports
Create a shared schedule
Configure caching
Subscribe to a report

Module 8: Administering Reporting Services
Administering reporting services
Reporting services configuration
Reporting services performance
Lab : Administering reporting services
Authorize access to reports
Web portal branding

Module 9: Extending and Integrating Reporting Services
Expressions and embedded code
Extending reporting services
Integrating reporting services
Lab : Extending and integrating reporting services
Custom code – report designer
Custom code – report builder
URL access

Module 10: Introduction to Mobile Reports
Overview of mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab : Introduction to mobile reports
Format data for a mobile report
Create a mobile report
Create KPIs

Module 11: Developing Mobile Reports
Designing and publishing mobile reports
Drillthrough in mobile reports
Lab : Developing mobile reports
Add a dataset with parameters
Design a mobile report
Publish a mobile report
Add a drillthrough to a custom URL