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 -...
DIMENSIONAL DATA MODELING TUTORIALS -...
Introduction to SLOWLY CHANGING DIMEN...
How to CREATE DATABASE, SCHEMA, AND T...

• #education
• #tsql_queries
• #relational_data_model
• #fact_table
• #degenrate_dimensions
• #ralph_kimball_methodology
• #star_schema
• #snow_flake
• #conceptual_model
• #logical_model
• #physical_model
• #database
• #primary_key
• #foreign_key
• #constraint
• #denormalization
• #granularity
• #grain
• #how_to_create_data_models_of_multiple_business_processes
• #designing_data_mart
• #data_modeling
• #data_warehousing
• #data_modelling
• #data_warehouse_concepts
• #sql_server
• #transact_sql
• #dimensional_data_modeling
• #star_schema
• #spark