Developing SQL Data Models

4.7(45,982 Ratings)

Duration

3 Days

Upcoming Batch

16 November 2026 - 18 November 2026

Batch Options

4 hours & 8 hours

Language

English / Arabic

Developing SQL Data Models

The Developing SQL Data Models course is designed for IT professionals at CounselTrain Technologies who want to learn how to develop and implement SQL Server data models. This course covers a range of topics, including designing and implementing dimensions, creating and managing measures, and implementing business logic in a data model.

The course content includes the following modules:

Introduction to Business Intelligence and Data Modeling
Creating Multidimensional Databases
Working with Cubes and Dimensions
Working with Measures and Measure Groups
Introduction to MDX
Customizing Cube Functionality
Implementing a Tabular Data Model by Using Analysis Services
Introduction to Data Analysis Expression (DAX)
Implementing Reports with SQL Server Reporting Services

This course will help candidates excel in their respective careers by providing them with the skills and knowledge they need to develop effective SQL Server data models. With these skills, candidates can design and implement data models that meet their organization’s needs, enabling them to make better decisions and gain insights into their data. By the end of the course, candidates should be able to design and implement effective SQL Server data models, customize cube functionality, and create reports using SQL Server Reporting Services.

Course Content

9 modules · 37 topics

01Module 1: Introduction To Business Intelligence And Data Modeling3 topics

Introduction to Business Intelligence
The Microsoft business intelligence platform
Lab : Exploring a Data Warehouse

02Module 2: Creating Multidimensional Databases5 topics

Introduction to multidimensional analysis
Course details Creating data sources and data source views
Creating a cube
Overview of cube security
Overview of cube security

03Module 3: Working With Cubes And Dimensions4 topics

Configuring dimensions
Define attribute hierarchies
Sorting and grouping attributes
Lab : Working with Cubes and Dimensions

04Module 4: Working With Measures And Measure Groups3 topics

Working with measures
Working with measure groups
Lab : Configuring Measures and Measure Groups

05Module 5: Introduction To MDX4 topics

MDX fundamentals
Adding calculations to a cube
Using MDX to query a cube
Lab : Using MDX

06Module 6: Customizing Cube Functionality5 topics

Implementing key performance indicators
Implementing actions
Implementing perspectives
Implementing translations
Lab : Customizing a Cube

07Module 7: Implementing A Tabular Data Model By Using Analysis Services4 topics

Introduction to tabular data models
Creating a tabular data model
Using an analysis services tabular model in an enterprise BI solution
Lab : Working with an Analysis services tabular data model

08Module 8: Introduction To Data Analysis Expression ﴾DAX﴿3 topics

DAX fundamentals
Using DAX to create calculated columns and measures in a tabular data model
Lab : Creating Calculated Columns and Measures by using DAX

09Module 9: Performing Predictive Analysis With Data Mining6 topics

Overview of data mining
Using the data mining add‐in for Excel
Creating a custom data mining solution
Validating a data mining model
Connecting to and consuming a data mining model
Lab : Perform Predictive Analysis with Data Mining

Schedule Dates

4 upcoming batches

Session Type

Physical sessions run at our training facility.

Developing SQL Data Models
Batch Dates	Duration	Batch Options	Language
16 November 2026 - 18 November 2026Next	3 Days	4 hours & 8 hours	English / Arabic
22 February 2027 - 24 February 2027	3 Days	4 hours & 8 hours	English / Arabic
24 May 2027 - 26 May 2027	3 Days	4 hours & 8 hours	English / Arabic
30 August 2027 - 01 September 2027	3 Days	4 hours & 8 hours	English / Arabic

Can’t find a suitable date? Request a schedule that fits your team.

Request More Information

FAQs

Who is the target audience for this course?

The course Developing SQL Data Models (20768-C) is primarily intended for database professionals who need to fulfill a Business Intelligence Developer role. This course is also suitable for individuals who develop and maintain SQL Server Analysis Services (SSAS) multidimensional models and/or tabular models for their organizations.

How will participants benefit from taking the course?

The 20768-C course is designed for database professionals who need to fulfill a Business Intelligence Developer role. This course is intended for individuals who design and build relational database models and who are responsible for data retrieval and analysis, as well as designing and building multi-dimensional databases, and creating tabular semantic data models. By taking this course, participants will gain the skills and knowledge required to design and implement a database solution that supports their business intelligence needs. They will learn how to create multidimensional data models, implement tabular data models, deploy SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) solutions, and implement self-service BI solutions. Participants will also learn how to optimize their BI infrastructure, and how to create dashboards and scorecards to visualize data.

Will participants receive any kind of certification or recognition for completing the course?

Yes, participants who successfully complete the Developing SQL Data Models (20768-C) course will receive a certificate of completion from Microsoft. Additionally, this course also helps prepare participants for the Microsoft Certification Exam 70-768: Developing SQL Data Models, which is one of the exams required to earn the MCSA: SQL 2016 BI Development certification.

What topics are covered in the course?

The Developing SQL Data Models (20768-C) course covers the following topics:
– Introduction to Business Intelligence and Data Modeling
– Creating Multidimensional Databases
– Working with Cubes and Dimensions
– Working with Measures and Measure Groups
– Introduction to MDX
– Customizing Cube Functionality
– Implementing Tabular Data Models
– Introduction to DAX
– Advanced DAX
– Implementing an Analysis Services Tabular Data Model
– Creating Data Visualizations with Power BI
In this course, participants will also learn how to create multidimensional and tabular data models, as well as how to work with measures, dimensions, and hierarchies. Participants will also learn how to customize cube functionality using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Finally, participants will learn how to create data visualizations using Power BI.

This course includes:

Soft copy of Courseware
Certificate of Course Completion
Experienced and Professional Trainer
Lab and Exercises During Training
Sample Questions for Exam Preparation
Mock Test on the Last Day of Training
Exam Registration Guidance
5-Star Training Environment

Upcoming Batch

16 November 2026 - 18 November 2026

View all batch dates

How We Deliver

Select the method that best suits your needs.

Online Instructor-Led Training Classroom Training Onsite Training Overseas Training

Request More Information

First Name *Please enter your first name.

Last Name

Email Address *Please enter a valid email address.

Phone Number *Please enter your phone number.

Country

Message

Your information is secure and never shared.

How We Deliver

Flexible Training Options to Meet Your Needs

Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.

Select the method that best suits your needs.