Developing SQL Data Models

0 Enrolled
3 day

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

Schedule Dates

Database, Microsoft

Developing SQL Data Models
14/08/2023

Database, Microsoft

Developing SQL Data Models
13/11/2023

Database, Microsoft

Developing SQL Data Models
12/02/2024

Database, Microsoft

Developing SQL Data Models
13/05/2024

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.

Feedback

0.0
0 rating
0%
0%
0%
0%
0%

Be the first to review “Developing SQL Data Models”

×
Main Content