20466D: Implementing Data Models and Reports with Microsoft SQL Server




    5 Day(s) Course


    Official Courseware


    Exam Voucher


    Certified Trainer


    1:1 Training Available on Demand


    Customize Your Batch



    The Microsoft Course 20466D Implementing Data Models and Reports with SQL Server expert level training course designed for professionals to implement data models and reports to support Business Intelligence Solutions using Microsoft SQL Server 2014.

    This is an advanced course that describes how to implement analytical processing models, such as OLAP (Online Analytical Processing) using the multidimensional structures and tabulated models in SSAS (SQL Server Analysis Services).

    It also teaches the deployment of various other services of SQL Server for Business Intelligence Applications such as Integration and Reporting Services.

    Note* - This training is part 1 of the series of two courses for MCSE: Business Intelligence Solutions with SQL Server 2014. Participants need to achieve certification for both the course exams to earn the credentials of MCSE.

    Module 1: Introduction to Business Intelligence and Data Modeling

    This module will impart a good understanding of the various elements that comprise a BI solution.


    • Introduction to Business Intelligence
    • The Microsoft Enterprise BI Platform

    Module 2: Creating Multidimensional Databases

    This module provides an introduction to the core components of an Online Analytical Processing (OLAP) cube and multidimensional databases.


    • Introduction to Multidimensional Analysis
    • Overview of Cube Security
    • Creating a Cube
    • Creating Data Sources and Data Source Views

    Module 3: Working with Cubes and Dimensions

    This module explains how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model.


    • Defining Attribute Hierarchies
    • Configuring Dimensions
    • Sorting and Grouping Hierarchies

    Module 4: Working with Measures and Measure Groups

    This module explores measures and measure groups. It also explains how you can use them to define fact tables and associated dimensions with measures.


    • Working with Measures and Measures Groups

    Module 5: Introduction to MDX

    This module explains the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.


    • Adding Calculations to a Cube
    • Using MDX to Query a Cube
    • MDX Fundamentals

    Module 6: Customizing Cube Functionality

    This module explains how to enhance a cube with Key Performance Indicators (KPIs), perspectives, actions, and translations.


    • Implementing Actions
    • Implementing Key Performance Indicators
    • Implementing Translations
    • Implementing Perspectives

    Module 7: Implementing an Analysis Services Tabular Data Model

    This module explains Analysis Services tabular data models and describes how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.


    • Introduction to Tabular Data Models
    • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
    • Creating a Tabular Data Model

    Module 8: Introduction to Data Analysis Expressions (DAX)

    This module describes the fundamentals of the DAX language. It also describes how you can use DAX to create calculated columns and measures, and how you can use them in your tabular data models.


    • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
    • Fundamental skill of DAX

    Module 9: Implementing Reports with SQL Server Reporting Services

    This module describes Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.


    • Introduction to Reporting Services
    • Showing Data Graphically
    • Grouping and Aggregating Data in a Report
    • Filtering Reports Using Parameters
    • Creating a Report with Report Designer

    Module 10: Automating Report Execution and Delivery

    This module describes how to apply security and report execution settings, and create subscriptions to deliver reports.


    • Managing Report Security & Execution
    • Delivering Reports with Subscriptions and Data Alerts
    • Reporting Services Troubleshooting

    Module 11: Delivering BI with SharePoint PerformancePoint Services

    This module describes Microsoft SharePoint Server as a platform for BI and building BI dashboards and scorecards with PerformancePoint Services.


    • SharePoint Server as a BI Platform Introduction
    • Planning for PerformancePoint Services
    • Planning Security for a SharePoint Server BI Solution

    Module 12: Performing Predictive Analysis with Data Mining

    This module introduces data mining, describes how to create a data mining solution, validate data mining models, use the Data Mining Add-ins for Microsoft Excel, and incorporate data mining results into Reporting Services reports.


    • Overview of Data Mining
    • Using the Data Mining Add-in for Excel
    • Validating a Data Mining Model
    • Creating a Custom Data Mining Solution
    • Connecting to and Consuming Data Mining Data

    This Data Models and Reports implementation with Microsoft SQL Server course is intended for database professionals who need to accomplish a Business Intelligence Developer role.

    They will be required to exhibit hands-on work creating BI solutions Primary responsibilities will include:

    • Implementing a data warehouse.
    • Enforcing data integrity by using Master Data Services.
    • Cleansing data by using Data Quality Services.
    • Developing SSIS packages for data extraction, transformation, and loading.

    This course requires professionals and learners to meet the following prerequisites:

    • At least 2 years’ experience of relevant experience with relational databases, including.
    • Designing a normalized database.
    • Querying with Transact-SQL.
    • Creating tables and relationships.
    • Some exposure to basic programming constructs (such as looping and branching).

    Name Code Fee
    Microsoft Certified Professional (MCP) - [70-466] 70-466 USD 127



    What Our Trainees Say

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