Analyzing Data with SQL Server Reporting Services (10990)

Description

Duration: 5 days

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 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.

After completing this course, students will be able to:

Describe key features of data modeling within business intelligence
Describe various report services data sources and how these are configured
Create reports with report designer and/or report designer
Configure reports with report designer and /or report builder
Create SQL Server mobile reports

Prerequisites

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

20761A: Querying Data with Transact-SQL

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
9/23/20249/25/2024
10/14/202410/16/2024
11/4/202411/6/2024
11/25/202411/27/2024
12/16/202412/18/2024
1/6/20251/8/2025
1/27/20251/29/2025
2/17/20252/19/2025
3/10/20253/12/2025
3/31/20254/2/2025
4/21/20254/23/2025
5/12/20255/14/2025
6/2/20256/4/2025
6/23/20256/25/2025
7/14/20257/16/2025
8/4/20258/6/2025
8/25/20258/27/2025
9/15/20259/17/2025
10/6/202510/8/2025
10/27/202510/29/2025
11/17/202511/19/2025
12/8/202512/10/2025
12/29/202512/31/2025
1/19/20261/21/2026

Curriculum

Module 1: Introduction to Business Intelligence and Data Modelling
In this module, students will be introduced to the key concepts in business intelligence and the Microsoft BI product suite.

Lessons

Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services
Lab: Exploring an enterprise BI solution

After completing this module, you will be able to:

Describe key concepts in business intelligence
Describe the Microsoft BI platform
Describe key concepts in reporting services

Module 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.

Lessons

Data connections
Connection strings
Filters and parameters
Lab: Configuring a data connection

After completing this module, you will be able to:

Describe data connections and connection strings
Describe filters and parameters

Module 3: Implementing reports
Create reports with report designer or report builder.

Lessons

Creating a report with the report wizard
Creating a report
Showing data graphically
Lab: Creating a report

After completing this module, you will be able to:

Create a report using the report wizard
Show data graphically

Module 4: Creating a Map Report
This module describes how to configure reports with report builder or report designer.

Lessons

Implementing filters and parameters
Implementing sorting and grouping
Publishing a report
Lab: Creating a map report

After completing this module, you will be able to:

Implement filters and parameters
Implement sorting and grouping
Publish a report

Module 5: Creating Mobile Reports
This module describes how to create SQL Server mobile reports.

Lessons

Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab: Mobile reports

After completing this module, you will be able to:

Describe SQL Server mobile reports
prepare data for mobile reports
Publish mobile reports