Analyzing Data with SQL Server Reporting Services

Session Detail:    Classroom, Virtual 5 Day

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.

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.

Who Can Benefit

The primary audience for this course is database professionals who need to fulfill 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.

Session Outline

Class Outline

Module 1: Introduction to Reporting Services

  • Lesson 1: Introduction to reporting services
  • Lesson 2: Reporting services components
  • Lesson 3: Reporting services tools

After completing this module, students will be able to:

  • Give a context for Reporting Services
  • Describe the components of Reporting Services
  • Explain Reporting Services tools

Module 2: Reporting Services Data Sources

  • Lesson 1: Data sources
  • Lesson 2: Connection strings
  • Lesson 3: Datasets

After completing this module, you will be able to:

  • Describe data sources
  • Work with connection strings
  • Describe datasets

Module 3: Creating Paginated Reports

  • Lesson 1: Creating a report with the report wizard
  • Lesson 2: Creating a report
  • Lesson 3: Publishing a report

After completing this module, you will be able to:

  • Create a report with the report wizard
  • Create a report using a report builder or report designer
  • Publish a report to reporting services

Module 4: Working with Reporting Services Data

  • Lesson 1: Data filters
  • Lesson 2: Report parameters
  • Lesson 3: Implementing report filters and parameters

After completing this module, students will be able to:

  • Filter data in reports
  • Use parameters in reports

Module 5: Visualizing Data with Report Services

  • Lesson 1: Formatting data
  • Lesson 2: Images and charts
  • Lesson 3: Databars, sparklines, indicators, gauges, and maps

After completing this module, you will be able to:

  • Format data in reports
  • Use images and charts in your reports
  • Use databars, sparklines, and indicators in reports
  • Explain what a KPI is and how it’s used

Module 6: Summarizing Report Data

  • Lesson 1: Sorting and grouping
  • Lesson 2: Report sub-reports
  • Lesson 3: Drilldown and drill through

After completing this module, students will be able to:

  • Group and sort data in reports.
  • Create report sub-sections.
  • Use drill-down and drill-through

Module 7: Sharing Reporting Services Reports

  • Lesson 1: Schedules
  • Lesson 2: Report caching, snapshots, and comments
  • Lesson 3: Report subscription and delivery

After completing this module, students will be able to:

  • Explain schedules
  • Describe report caching, report snapshots, and report comments
  • Configure report subscriptions

Module 8: Administering Reporting Services

  • Lesson 1: Administering reporting services
  • Lesson 2: Reporting services configuration
  • Lesson 3: Reporting services performance

After completing this module, students will be able to:

  • Secure access to reports by using authentication, permissions, and SSL encryption
  • Use report services configuration manager to reconfigure SSRS servers
  • Monitor and optimize the performance of SSRS on a given set of server hardware

Module 9: Extending and Integrating Reporting Services

  • Lesson 1: Expressions and embedded code
  • Lesson 2: Extending reporting services
  • Lesson 3: Integrating reporting services

After completing this module, students will be able to:

  • Work with expressions and embedded code
  • Extend reporting services functionality with external assemblies
  • Integrate reporting services with other software

Module 10: Introduction to Mobile Reports

  • Lesson 1: Overview of mobile reports
  • Lesson 2: Preparing data for mobile reports
  • Lesson 3: Mobile report publisher

After completing this module, students will be able to:

  • Describe considerations for mobile reports
  • Prepare data for publication in mobile reports
  • Use SQL Server mobile report publisher to create mobile reports

Module 11: Developing Mobile Reports

  • Lesson 1: Designing and publishing mobile reports
  • Lesson 2: Drillthrough in mobile reports

After completing this module, students will be able to:

  • Describe how to design and publish mobile reports
  • Explain how to drill through from mobile reports

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart

Analyzing Data with SQL Server Reporting Services

5 Day
Classroom, Virtual

$3,095.00

Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now