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
Curriculum
-
Module 1: Introduction to Business Intelligence and Data Modeling
-
Module 2: Creating Multidimensional Databases
-
Module 3: Working with Cubes and Dimensions
-
Module 4: Working with Measures and Measure Groups
-
Module 5: Introduction to MDX
-
Module 6: Customizing Cube Functionality
-
Module 7: Implementing a Tabular Data Model by Using Analysis Services
-
Module 8: Introduction to Data Analysis Expression ﴾DAX﴿
-
Module 9: Performing Predictive Analysis with Data Mining
- 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.
