Developing SQL Data Models

  • 4.7(45,982 Rating)

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.

Schedule Dates

Developing SQL Data Models
13 May 2024 - 15 May 2024
Developing SQL Data Models
13 August 2024 - 15 August 2024
Developing SQL Data Models
13 November 2024 - 15 November 2024
Developing SQL Data Models
17 February 2025 - 19 February 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.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?