search
    

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

    QUICK

    INFORMATION

    course-duration

    3 Day(s) Course

    courseware

    Official Courseware

    exam-voucher

    Exam Voucher

    certified-trainer

    Certified Trainer

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    ABOUT

    THE COURSE

    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.

    Lessons

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

    Lessons

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

    Lessons

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

    Lessons

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

    Lessons

    • 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

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.