Course description

Explore key features of data modeling within business intelligence

In this course you will learn how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. You will discover how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Each individual Microsoft Official Course On-Demand includes 3 months (or 12 months with purchase of Microsoft Total Access Collection) of 24x7 access to the following:

What You’ll Learn

• 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

Who Needs to Attend

• Database professionals who fulfill a BI developer role

• Database professionals who create analysis and reporting solutions


In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course: Querying Data with Transact-SQL (M20761)

Follow-on Courses

Course Outline

1: Introduction to Business Intelligence and Data Modeling

2: Reporting Services Data

3: Implementing reports

4: Configuring reports

5: Creating Mobile Reports


Lab 1: Exploring an enterprise BI solution

Lab 2: Configuring a data connection

Lab 3: Creating a report

Lab 4: Create and Publish reports that include parameters

Lab 5: Working with mobile reports