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

    QUICK

    INFORMATION

    course-duration

    3 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Training

    customize-batch

    Customize Your Batch

    one-o-one

    1:1 Training Available on Demand

    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

    COURSE OUTLINE

    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

    WHO SHOULD ATTEND

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

    Pre-requisites

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

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

    Exam

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

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.