10990 - Analyzing Data With SQL Server Reporting Services SQL Server 2016




    3 Day(s) Course


    Official Courseware


    Certified Trainer


    Exam Voucher


    1:1 Training Available on Demand


    Customize Your Batch

    Course Information

    Microsoft 10990 Analyzing Data with SQL Server Reporting Services is a three-day training course that will provide knowledge of implementing a SQL Server 2016 Reporting Services solution for data analysis in an organization.

    During the training course, participants will explore the use of Reporting Services development tools that can be deployed to create and manage reports and implement self-service BI solutions.

    Completion of this training course will enable candidates in:

    • Describing key features of data modeling 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


    Module 1: Introduction to Business Intelligence and Data Modelling

    In this module, participants will learn about the key concepts in business intelligence, and the Microsoft BI product suite.


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

    Lab: Exploring an enterprise BI solution

    • Describe key concepts in business intelligence
    • Describe the Microsoft BI platform
    • Describe key concepts in reporting services

    Module 2: Reporting Services Data

    In this module, participants will learn the various Report Services data sources and how these are configured.


    • Data sources
    • Datasets
    • Filters and parameters
    • Connection strings

    Lab: Configuring a data connection

    • Describe data connections and connection strings
    • Describe filters and parameters

    Module 3: Implementing reports

    In this module, participants will learn to create reports with report designer or report builder.


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

    Lab: Creating a report

    • Create a report using the report wizard
    • Show data graphically

    Module 4: Configuring reports

    In this module, participants will learn how to configure reports with report builder or report designer.


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

    Lab: Create and Publish reports that include parameters

    • Implement filters and parameters
    • Implement sorting and grouping
    • Publish a report

    Module 5: Creating Mobile Reports

    In this module, participants will learn how to create SQL Server mobile reports.


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

    Lab: Working with mobile reports

    • Describe SQL Server mobile reports
    • Prepare data for mobile reports
    • Publish mobile reports


    • This course majorly targets database professionals who are seeking a role as a BI developer role for creating reports.
    • The secondary audiences are power information workers.


    In addition to the professional experience, candidates should possess technical knowledge equivalent to the following course:

    • 20761A/B: Querying Data with Transact-SQL


    Name Code Fee
    Analyzing Data with SQL Server Reporting Services (SSRS) 10990 USD 100



    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by based on 18 reviews.