DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY

Опубликовано: 24 Апрель 2021
на канале: BI with Mina

11,801

251

This video, which is based on a case study, shows how to build a dimensional data model for multiple business processes.

You will learn about the Types of Fact Tables, Conformed Dimensions, Role Playing Dimensions, 4-Step Dimensional Design Process, Matrix Design, Star Schema and Understand Dimensional Modeling of Multiple Business Processes based on a case study

Dimensional Data Model is a denormalization technique invented by Ralph Kimball. In this model, there are two types of tables:

Fact Table which contains: Metrics, Foreign keys of associated dimensions, optional Degenerated Dimension, optional Audit information
Dimension Tables are the Descriptive entities associated with the fact table

A Dimensional Model Design, has a fact table is surrounded by dimension tables, this design is referred to as Star Schema

Useful Links:
   • DIMENSIONAL DATA MODELING TUTORIALS -  STA...
   • DIMENSIONAL DATA MODELING TUTORIALS - STAR...
   • Introduction to SLOWLY CHANGING DIMENSIONS...
   • How to CREATE DATABASE, SCHEMA, AND TABLES...

На этой странице сайта вы можете посмотреть видео онлайн DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь BI with Mina 24 Апрель 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 11,801 раз и оно понравилось 251 зрителям. Приятного просмотра!

229,737

356