DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY
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...
On this page of the site you can watch the video online DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY with a duration of hours minute second in good quality, which was uploaded by the user BI with Mina 24 April 2021, share the link with friends and acquaintances, this video has already been watched 11,801 times on youtube and it was liked by 251 viewers. Enjoy your viewing!
