• 18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
  • 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337

70-768 – Developing SQL Data Models Certification Training Course Overview

The 3 days training for ‘Developing SQL Data Models’ is designed to prepare you pass 70-768 exam.  The 70-768 exam course is focused on creating the managed enterprise BI solutions. Data modeling is a widely used process of creating a data model to represent the data to be stored in a Database. Data model is the conceptual representation of ‘Data objects’ and association between the different data objects. SQL Data Models simplify the defining and analyzing the data requirements often needed to support the IT processes of corresponding information systems. Developing SQL Data Models training course provides insights to implement multidimensional and tabular data models as well as to create measures, measure groups, cubes and dimensions.

SQL Developer Data Modeler is a free to use graphical tool designed to improve the productivity and to simplify the data modeling tasks. As being the leading accredited training partner for Microsoft, our certified and experienced SQL trainers follow the latest Microsoft Official Course (MOC) content; so, you get the best knowledge to crack 70-768 exam in first go. It is an important milestone on the path of getting MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.

Learning Scope of Developing SQL Data Models Training:

  • Describing components, architecture, nature of a BI solution
  • Creating multidimensional database with analysis services
  • Implementing dimensions in a cube
  • Implementing measures and measure groups in a cube
  • Using MDX syntax
  • Customizing a cube
  • Implementing tabular database
  • Using DAX to query tabular model
  • Using data mining for an accurate and predictive analysis

Target Audience for Developing SQL Data Models Certification:

 It is a good globally acknowledged career developing credential for Data analysts, power information professionals, Database professionals in the job role of BI developer, professionals creating enterprise BI solutions, and the professionals implementing multidimensional databases by using SSAS.

Growth Prospects after Passing 70-768 Exam: 

  • SQL developers are always in demand.
  • Certified SQL Developers are highly paid and can make even $114,500.
  • SQL Server is the most used “relational database management system” (RDMS).
  • Global SQL server market is expected to reach 9.5 Billion USD by 2021.
  • There has been 7% increase in demand of certified SQL database administrators.


Developing SQL Data Models Certification Exam Training Course Outline (70-768 Exam)

Module 1: Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • Microsoft business intelligence platform

Module 2: Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Create Data Sources and Data Source Views
  • Cubes and Cube Security
  • Configure and monitor  SSAS

Module 3: Working with Cubes and Dimensions

  • Configure Dimensions
  • Define Attribute Hierarchies
  • Implementing Sorting and Grouping Attributes
  • Changing Dimensions

Module 4: Working with Measures and Measure Groups

  • Working with measures and measure groups

Module 5: Introduction to MDX

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

Module 6: Customizing Cube Functionality

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

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

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

Module 8: Introduction to Data Analysis Expression (DAX)

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

Module 9: Performing Predictive Analysis with Data Mining

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

The training involves intensive lab exercises for each module to test the learned subjective skills.  

Prerequisite for Developing SQL Data Models Exam Course:

  • Knowledge of Microsoft Windows operating system and core functionality
  • Experience of querying data using Transact-SQL
  • Knowledge of relational databases

FAQs for Developing SQL Data Models Certification Exam Course

Q: Can I learn to develop SQL data models online?

Yes! We provide online training to help you learn to develop SQL data models.

Q: Can I use SATVs for SQL Data Modeling certification course?

Yes, ‘Developing SQL Data Models - 70-768’ certification course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.

Q: Is ‘Developing SQL Data Models’ training part of a Microsoft SQL Server certification path?

Yes! It fulfills the prerequisite for MCSA: SQL 2016 BI Development and MCSE: Data Management and Analytics certifications.

Q: What is the practical learning scope of ‘Working with Cubes and Dimensions’?

During the labs exercises, you will learn: Configure Dimensions; Define Relationships and Hierarchies; Sorting & Grouping Dimension Attributes.

Q: What is the practical learning scope (lab tests) of ‘Working with Measures and Measure Groups’ domain?

During the labs exercises under this domain, you will learn: Configuring Measures; Defining Regular Relationships; Configuring Measure Group Storage.


Are you being sponsored by your employer to take this class?
Contact No.
  • *I authorize Microtek Learning to contact me via Phone/Email