Available 24/7
Professional Instruction
Free Training Materials
Course Details
The Analyzing Data with SQL Server Reporting Services - 10990 course is a 5-day course that is designed to teach students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization.
Students will learn how to use Reporting Services development tools to create and manage reports and implement self-service BI solutions.
Topics covered in the course include:
- Describing key features of data modelling within business intelligence
- Describing various report services data sources and how these are configured
- Creating reports with report designer and/or report designer
- Configuring reports with report designer and/or report builder
- Creating SQL Server mobile reports
Target Student:This course is designed for database professionals who need to fulfil a BI developer role to create reports.
Students should possess the following experience before attending the course:
- 20761A: Querying Data with Transact-SQL or equivalent knowledge.
Section 1: Introduction to Business Intelligence and Data Modelling
In this section students are introduced to the key concepts in business intelligence, and the Microsoft BI product suite.
Topics
Introduction to business intelligence
The Microsoft business intelligence platform
Introduction to reporting services
Lab : Exploring an enterprise BI solution
Section 2: Reporting Services Data
Describe various Report Services data sources and how these are configured.
Topics
Data connections
Connection strings
Filters and parameters
Lab : Configuring a data connection
Section 3: Implementing reports
Students will learn to create reports with report designer or report builder.
Topics
Creating a report with the report wizard
Creating a report
Showing data graphically
Lab : Creating a report
Section 4: Creating a Map Report
This section describes how to configure reports with report builder or report designer.
Topics
Implementing filters and parameters
Implementing sorting and grouping
Publishing a report
Lab : Creating a map report
Section 5: Creating Mobile Reports
This section describes how to create SQL Server mobile reports.
Topics
Overview of SQL Server mobile reports
Preparing data for mobile reports
Mobile report publisher
Lab : Mobile reports
Please check the course description to find prerequisite information.
MOC On-Demand: 10990-Analyzing Data with SQL Server Reporting Services
On-Demand Training Course
90/month licence
- 24/7 Access
- Hands-On Practice Exercises
- Free Repeats
- Professional Instruction
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Free Repeats
Learn At Your Pace
No Travel
Professional Instruction
Affordable Pricing
Group Discounts
