Analyzing Data with SQL Server Reporting Services

Master the skills to revolutionize data analytics with SQL Server Reporting Services and propel your career as a Database Professional or BI Developer.

Course Thumbnail

Essential Skills Gained

Checkmark

Design and manage SQL Server Reporting Services solutions.

Checkmark

Implement interactive and mobile reports using Reporting Services tools.

Checkmark

Model data effectively for business intelligence applications.

Checkmark

Utilize self-service BI solutions to empower decision-making.

Format

  • Instructor-led
  • 5 days with lectures and hands-on labs.

Audience

  • Database Professionals
  • BI Developers
  • Power Information Workers

Description

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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Introduction to Business Intelligence and Data Modelling

  1. Introduction to business intelligence

  2. The Microsoft business intelligence platform

  3. Introduction to reporting services

  4. Lab: Exploring an enterprise BI solution

Module 2: Reporting Services Data

  1. Data connections

  2. Connection strings

  3. Filters and parameters

  4. Lab: Configuring a data connection

Module 3: Implementing reports

  1. Creating a report with the report wizard

  2. Creating a report

  3. Showing data graphically

  4. Lab: Creating a report

Module 4: Creating a Map Report

  1. Implementing filters and parameters

  2. Implementing sorting and grouping

  3. Publishing a report

  4. Lab: Creating a map report

Module 5: Creating Mobile Reports

  1. Overview of SQL Server mobile reports

  2. Preparing data for mobile reports

  3. Mobile report publisher

  4. Lab: Mobile reports

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.