Course Information
Code10990
FeeSee particular events - prices exclude VAT
Duration3 Day(s)
Delivery MethodInstructor-led
Scheduled DatesCurrently there are no scheduled events for this course - please contact us for information
Referral Fee£50 Amazon Voucher! - refer a friend or colleague
Related LinksN/A
MS 10990 Analyzing Data SQL Server Reporting Services SQL Course Sheffield London Manchester Leeds Online Book Your Course Now!

Rezound provide official 10990 Analyzing Data with SQL Server Reporting Services (SRSS) training for Sheffield, London, Leeds, Manchester, Yorkshire and at your site in the UK.

Course Details

Introduction

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

Related Certifications and Examinations

There can be many combinations for how a course's content maps to the various examinations and related certifications.

We have listed as many of the primary ones as possible and continually update our database - please contact us for further information.

Related Examinations

  • There are no listed related examinations

Related Certifications

  • There are no listed related certifications

Audience

The primary audience for this course is database professionals who need to fulfil 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.

At Course Completion

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

Prerequisites

Before attending this course, students should ideally have:

  • Technical knowledge of Transact-SQL querying. For example, gained on course:
  • 20761: Querying Data with Transact-SQL

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline

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 and Activities

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

Lab : Exploring an enterprise BI solution

Module 2: Reporting Services Data

Describe various Report Services data sources and how these are configured.

Lessons and Activities

  • Data connections
  • Connection strings
  • Filters and parameters

Lab : Configuring a data connection

Module 3: Implementing reports

Create reports with report designer or report builder.

Lessons and Activities

  • Creating a report with the report wizard
  • Creating a report
  • Showing data graphically

Lab : Creating a report

Module 4: Creating a Map Report

This module describes how to configure reports with report builder or report designer.

Lessons and Activities

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

Lab : Creating a map report

Module 5: Creating Mobile Reports

This module describes how to create SQL Server mobile reports.

Lessons and Activities

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

Lab : Mobile reports


Copyright © + Design: Rezound Limited | MS 10990 Analyzing Data with SQL Server Reporting Services Course Sheffield London Manchester Leeds Online