SQL Server Business Intelligence // // 10990

10990: Analyzing Data with SQL Server Reporting – SSRS (See Course BI790)

home > training > 10990: Analyzing Data with SQL Server Reporting – SSRS (See Course BI790)
SQL Server Training at Interface logo image

10990: Analyzing Data with SQL Server Reporting – SSRS (See Course BI790)

$1,895.00

7 Student Comments

  • 3 Days
  • Replay™ Class Recordings Included
  • Microsoft SA Voucher Eligible
Interface Gold™This is an Interface Gold™ class date delivered live at our Phoenix location. Online attendees will have access to our RemoteLive™ platform. Replay™ class recordings are included.

Do you need a class sooner? We can also offer additional dates through our partners! It's not Interface Gold™ but it's a great choice if your schedule is not flexible.

Request A Date
SQL Server Training at Interface logo image
x
Course:

Course Description

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

If you are an IT Professional and you need to learn how to deploy in a production environment, see course: BI790 – SQL Server 2016 Reporting Services (SSRS) for Report Developers

 

Course 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

SHOW MORE COURSE OUTLINE
SHOW LESS COURSE OUTLINE
Partners

STUDENT COMMENTS
FOR THIS COURSE.

February 17, 2017 | 10990 Student
Comments about the Instructor
"A joy to learn from and packed with knowledge and experience in SSRS."
February 17, 2017 | 10990 Student
Comments about the Instructor
"Peter is an excellent instructor. This is my second class with him. He is patient, and knowledgeable. The class goes at the right pace. His passion for teaching, and level of care is shown in the class."
February 17, 2017 | 10990 Student
Comments about the Instructor
"The instruction was great. The course flowed nicely from the initial instruction to the demos and then to the labs. I felt the instructor was very successful at making sure everyone kept up in the course."
February 17, 2017 | 10990 Student
Comments about the Classroom
"Everything worked very nicely for me using the adobe plugin."
February 17, 2017 | 10990 Student
Comments about the Classroom
"I took it remotely, so I was very comfortable"
SHOW MORE COMMENTS