20768B: Developing SQL Data Models (SSAS)




    3 Day(s) Course


    Official Courseware


    Certified Trainer


    Exam Voucher


    1:1 Training Available on Demand


    Customize Your Batch

    Course Information

    The 3-days Microsoft 20768B Developing SQL Data Models Certification course is Part 2 of the series of two courses of MCSA 2016: SQL Business Intelligence Development, meant for database professionals who develop and implement multidimensional models and tabular models on Online Analytical Processing (OLAP) cubes by using SQL Server Analysis Services (SSAS).

    The SSAS provides data mining functionality by letting you design, create and manage the multiple databases that are aggregated from other data resources, such as relational databases.  

    This course qualifies you for the exam 70-768: Developing SQL Data Models Certification.


    Module 1: Introduction to Business Intelligence and Data Modeling

    This module describes key BI concepts and the Microsoft BI product suite.


    • Business Intelligence Introduction
    • Microsoft business intelligence platform

    Module 2: Creating Multidimensional Databases

    This module explains the steps required to create a multidimensional database with analysis services.


    • Multidimensional analysis Introduction
    • Creating data sources and data source views
    • Creating a cube
    • Overview of cube security

    Module 3: Working with Cubes and Dimensions

    This module explains how to implement dimensions in a cube.


    • Configuring dimensions
    • Define attribute hierarchies
    • Sorting and grouping attributes

    Module 4: Working with Measures and Measure Groups

    This module explains how to implement measures and measure groups in a cube.


    • Working with measures
    • Working with measure groups

    Module 5: Introduction to MDX

    This module explains the MDX syntax and how to use MDX.


    • MDX fundamentals
    • Adding calculations to a cube
    • Using MDX to query a cube

    Module 6: Customizing Cube Functionality

    This module explains how to customize a cube.


    • Implementing key performance indicators
    • Implementing actions
    • Implementing perspectives
    • Implementing translations

    Module 7: Implementing a Tabular Data Model by Using Analysis Services

    This module explains how to implement a tabular data model in PowerPivot.


    • Tabular data models Introduction
    • Using an analysis services tabular model in an enterprise BI solution
    • Creating a tabular data model

    Module 8: Introduction to Data Analysis Expressions (DAX)

    This module describes how to use DAX to create measures and calculated columns in a tabular data model.


    • Fundamentals of DAX
    • Using DAX to create calculated columns and measures in a tabular data model

    Module 9: Performing Predictive Analysis with Data Mining

    This module describes how to use data mining for predictive analysis.


    • Overview of data mining
    • Validating a data mining model
    • Using the data mining add-in for Excel
    • Creating a custom data mining solution
    • Connecting to and consuming a data mining model


    This Developing SQL Data Models SSAS training 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 that you meet the following prerequisites:

    • Working knowledge of Transact-SQL and Relational Databases.
    • Basic knowledge of the Microsoft Windows operating system and its core functionality.


    Name Code Fee
    Developing SQL Data Models Certification 70-768 USD 108



    What Our Trainees Say

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