Developing SQL Data Models

Overview Schedule Dates Course Content Faqs

Course Overview

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.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Schedule Dates

Developing SQL Data Models

14 October 2024 - 16 October 2024

Developing SQL Data Models

14 January 2025 - 16 January 2025

Developing SQL Data Models

14 April 2025 - 16 April 2025

Developing SQL Data Models

14 July 2025 - 16 July 2025

Course Content

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

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

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

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

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

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

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

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

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

FAQs

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.

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.

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.

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.