home > training > 10990: Analyzing Data with SQL Server Reporting Services

This course replaces: BI795 - SQL Server Reporting Services (SSRS) for Report Developers

SQL Server Training at Interface logo image

23 Student Comments

10990: Analyzing Data with SQL Server Reporting Services

$2,995 Interface Gold™

  • 5 Days
  • Microsoft SA Voucher Eligible
  • Included in the "all-you-can-eat" Microsoft Live Training Subscription Learn More
Dates Available
Class Time
Guaranteed to Run
Live Online
Live In Classroom
 
Mar 29 - Apr 2
Replay™ AvailableThis class date includes Interface Replay™ class recordings, available for online viewing 1 hour after each class day ends.
8AM - 4PM (PHX)
This class date is Guaranteed to Run and will not change.
Guaranteed To Run
Live Online
Register today - no risk!  No cancellation fees.  Full money back guarantee!
SQL Server Training at Interface logo image
x
Course:
  • This field is for validation purposes and should be left unchanged.

Course Description

This is a 5-day Microsoft Official Course – MOC 10990: Analyzing Data with SQL Server Reporting Services.

This course is an overview of 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. It also reviews Data Modeling, mobile reports and report mapping for filtering and sorting parameters and grouping.

 

Outline

Module 1: Introduction to Business Intelligence and Data Modelling

Lessons

  • Introduction to business intelligence
  • The Microsoft business intelligence platform
  • Introduction to reporting services

Lab : Exploring an enterprise BI solution

 

Module 2: Reporting Services Data

Lessons

  • Data connections
  • Connection strings
  • Filters and parameters

Lab : Configuring a data connection

 

Module 3: Implementing reports

Lessons

  • Creating a report
  • Showing data graphically

Lab : Creating a report

 

Module 4: Creating a Map Report

Lessons

  • Implementing filters and parameters
  • Implementing sorting and grouping
  • Publishing a report

Lab : Creating a map report

 

Module 5: Creating Mobile Reports

Lessons

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

Lab : Mobile reports

 

Audience

The primary audience for this course is database professionals who want to learn about creating reports. Primary responsibilities will include implementing reports and mobile reports. The secondary audiences for this course are power information workers.

Prerequisites

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

SQL101: Introduction to Transact SQL

or

SQL250: Transact-SQL for Developers

What You Will Learn

After completing this course, students will be able to:
• Describe key features of data modelling 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

Student Comments (23)

Comments about the Instructor
"Peter has great command of the skills needed for developing reports. He has provided the skill level to push me into good, professional level reporting skills. We did not have time to go over a lot of real world scenarios as we had a lot of ground to cover, but Peter did a good job of providing content to help out in those cases."
January 15, 2021 | 10990 Student
Comments about the Physical Environment
"awesome class..will take a future class"
February 14, 2020 | BI795 Student
Comments about the Instructor
"Instructor was extremely knowledgable"
February 14, 2020 | BI795 Student
Comments about the Physical Environment
"Class was setup and liked having dual monitors and smart boards."
February 14, 2020 | BI795 Student
Comments about the Instructor
"Peter Avila is a great instructor and a very knowledgeable with SQL and SSRS. He was able to explain everything in detail. Look forward to applying what I have learned to my job!"
February 14, 2020 | BI795 Student
Load More Comments