0% found this document useful (0 votes)

41 views52 pages

Dimensional Modeling

The document provides an overview of data warehousing concepts, focusing on dimensional modeling techniques such as star and snowflake schemas, fact and dimension tables, and various types of slowly changing dimensions. It also discusses ETL processes, data quality, data lineage, and methodologies like Kimball and Data Vault modeling. Key components like surrogate keys, junk dimensions, and data mart architecture are highlighted throughout the document.

Uploaded by

Woody Woodpecker

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

41 views52 pages

Dimensional Modeling

Uploaded by

Woody Woodpecker

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as PDF, TXT or read online on Scribd

You are on page 1/ 52

DATA WAREHOUSING

DIMENSIONAL
MODELLING

Shwetank Singh
GritSetGrow - GSGLearn.com
DIMENSIONAL MODELING

Shwetank Singh
GritSetGrow - GSGLearn.com
STAR SCHEMA

Shwetank Singh
GritSetGrow - GSGLearn.com
SNOWFLAKE SCHEMA

Shwetank Singh
GritSetGrow - GSGLearn.com
FACT TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
DIMENSION TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
GRAIN

Shwetank Singh
GritSetGrow - GSGLearn.com
SURROGATE KEY

Shwetank Singh
GritSetGrow - GSGLearn.com
SLOWLY CHANGING
DIMENSIONS (SCD)

Shwetank Singh
GritSetGrow - GSGLearn.com
TYPE 1 SCD

Shwetank Singh
GritSetGrow - GSGLearn.com
TYPE 2 SCD

Shwetank Singh
GritSetGrow - GSGLearn.com
TYPE 3 SCD

Shwetank Singh
GritSetGrow - GSGLearn.com
CONFORMED DIMENSIONS

Shwetank Singh
GritSetGrow - GSGLearn.com
JUNK DIMENSION

Shwetank Singh
GritSetGrow - GSGLearn.com
ROLE-PLAYING DIMENSIONS

Shwetank Singh
GritSetGrow - GSGLearn.com
FACTLESS FACT TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
AGGREGATE FACT TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
BRIDGE TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
DEGENERATE DIMENSION

Shwetank Singh
GritSetGrow - GSGLearn.com
ETL (EXTRACT, TRANSFORM,
LOAD)

Shwetank Singh
GritSetGrow - GSGLearn.com
BUS ARCHITECTURE

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA MART

Shwetank Singh
GritSetGrow - GSGLearn.com
GRAIN DECLARATION

Shwetank Singh
GritSetGrow - GSGLearn.com
DIMENSIONAL HIERARCHY

Shwetank Singh
GritSetGrow - GSGLearn.com
MULTIVALUED DIMENSIONS

Shwetank Singh
GritSetGrow - GSGLearn.com
OUTRIGGER DIMENSION

Shwetank Singh
GritSetGrow - GSGLearn.com
MINI-DIMENSION

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA STEWARDSHIP

Shwetank Singh
GritSetGrow - GSGLearn.com
SURROGATE KEY PIPELINE

Shwetank Singh
GritSetGrow - GSGLearn.com
SLOWLY CHANGING MEASURE

Shwetank Singh
GritSetGrow - GSGLearn.com
FACT TABLE GRAIN

Shwetank Singh
GritSetGrow - GSGLearn.com
SNAPSHOT FACT TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
ACCUMULATING SNAPSHOT
FACT TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
SEMI-ADDITIVE MEASURES

Shwetank Singh
GritSetGrow - GSGLearn.com
NON-ADDITIVE MEASURES

Shwetank Singh
GritSetGrow - GSGLearn.com
ETL STAGING AREA

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA QUALITY

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA LINEAGE

Shwetank Singh
GritSetGrow - GSGLearn.com
BUSINESS PROCESS

Shwetank Singh
GritSetGrow - GSGLearn.com
DRILL-DOWN ANALYSIS

Shwetank Singh
GritSetGrow - GSGLearn.com
DERIVED TABLE

Shwetank Singh
GritSetGrow - GSGLearn.com
FACT TABLE AGGREGATION

Shwetank Singh
GritSetGrow - GSGLearn.com
PERFORMANCE TUNING

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA WAREHOUSE
ARCHITECTURE

Shwetank Singh
GritSetGrow - GSGLearn.com
DIMENSIONAL INTEGRITY

Shwetank Singh
GritSetGrow - GSGLearn.com
LATE ARRIVING DATA

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA WAREHOUSE LIFECYCLE

Shwetank Singh
GritSetGrow - GSGLearn.com
OLAP (ONLINE ANALYTICAL
PROCESSING)

Shwetank Singh
GritSetGrow - GSGLearn.com
KIMBALL METHODOLOGY

Shwetank Singh
GritSetGrow - GSGLearn.com
CORPORATE INFORMATION
FACTORY (CIF)

Shwetank Singh
GritSetGrow - GSGLearn.com
DATA VAULT MODELING

Shwetank Singh
GritSetGrow - GSGLearn.com

Data Engineering - Dimensional Modelling
No ratings yet
Data Engineering - Dimensional Modelling
52 pages
Python Basics Shwetank Singh PDF
No ratings yet
Python Basics Shwetank Singh PDF
32 pages
SQL and PySpark
No ratings yet
SQL and PySpark
80 pages
SQL Subquery
100% (1)
SQL Subquery
57 pages
Data Modelling Essentials
No ratings yet
Data Modelling Essentials
40 pages
Detailed SQL Interview Questions
No ratings yet
Detailed SQL Interview Questions
4 pages
Unix Commands Cheat Sheet
No ratings yet
Unix Commands Cheat Sheet
12 pages
Ade 1737191501
No ratings yet
Ade 1737191501
29 pages
Spark SQL Built in Functions List 1666128345
No ratings yet
Spark SQL Built in Functions List 1666128345
143 pages
Day 10 1729086189
No ratings yet
Day 10 1729086189
14 pages
SQL Cheatsheet - Shwetank Singh
No ratings yet
SQL Cheatsheet - Shwetank Singh
44 pages
Tech Mahindra Data Analyst Interview Questions
No ratings yet
Tech Mahindra Data Analyst Interview Questions
11 pages
All Snowflake Details Document
No ratings yet
All Snowflake Details Document
105 pages
Date Function
No ratings yet
Date Function
8 pages
Day 89
No ratings yet
Day 89
9 pages
Data Engineering 101 - Databricks Q&As
No ratings yet
Data Engineering 101 - Databricks Q&As
39 pages
The Complete SQL HandBook
No ratings yet
The Complete SQL HandBook
89 pages
SQL Basics for Beginners
No ratings yet
SQL Basics for Beginners
141 pages
Data Engineer Interview Prep
No ratings yet
Data Engineer Interview Prep
27 pages
SQL Basics for Beginners
No ratings yet
SQL Basics for Beginners
4 pages
Azure Analytics Interview Answers Complete
No ratings yet
Azure Analytics Interview Answers Complete
5 pages
Best2 Toppers SQL-interview-Question
100% (1)
Best2 Toppers SQL-interview-Question
47 pages
Spark A To Z
No ratings yet
Spark A To Z
63 pages
Manish SQL Notes
100% (1)
Manish SQL Notes
82 pages
Power BI Interview Questions Part-1
No ratings yet
Power BI Interview Questions Part-1
53 pages
Python Cheat Sheet For Beginners
No ratings yet
Python Cheat Sheet For Beginners
26 pages
SQL Basics for Beginners
No ratings yet
SQL Basics for Beginners
49 pages
Power-Bi Interview Questions and Answers
No ratings yet
Power-Bi Interview Questions and Answers
11 pages
Interview Questions
No ratings yet
Interview Questions
2 pages
SQL Queries and PL/SQL
No ratings yet
SQL Queries and PL/SQL
92 pages
SQL Interview Prep Guide
No ratings yet
SQL Interview Prep Guide
67 pages
Power BI
No ratings yet
Power BI
47 pages
100 SQL Formulas Each Student Should Know
No ratings yet
100 SQL Formulas Each Student Should Know
10 pages
Parallel Processing
No ratings yet
Parallel Processing
38 pages
SQL Master
No ratings yet
SQL Master
45 pages
Ebook Python Interview Guide
No ratings yet
Ebook Python Interview Guide
15 pages
VBA MACRO Course Training Syllabus PDF
No ratings yet
VBA MACRO Course Training Syllabus PDF
1 page
ETL Best Practices
No ratings yet
ETL Best Practices
21 pages
Questions (SQL) : Saved To The Database. DCL
No ratings yet
Questions (SQL) : Saved To The Database. DCL
15 pages
180+ SQL Interview Questions 2023
No ratings yet
180+ SQL Interview Questions 2023
76 pages
Python Variables Guide
No ratings yet
Python Variables Guide
2 pages
BigQuery CheatSheet
100% (1)
BigQuery CheatSheet
100 pages
Data Engineer Path - Hands On SQL, Data Pipelines - Dataquest
No ratings yet
Data Engineer Path - Hands On SQL, Data Pipelines - Dataquest
1 page
DML Practical 2
No ratings yet
DML Practical 2
2 pages
Python For Non-Programmers - 1-1
No ratings yet
Python For Non-Programmers - 1-1
19 pages
Pandas - Basics - Practice: Consider The Following Python Dictionary Data and Python List Labels
No ratings yet
Pandas - Basics - Practice: Consider The Following Python Dictionary Data and Python List Labels
6 pages
Data Analytics Certificate Glossary
No ratings yet
Data Analytics Certificate Glossary
23 pages
Cleaning Dirty Data With Pandas & Python - DevelopIntelligence Blog PDF
No ratings yet
Cleaning Dirty Data With Pandas & Python - DevelopIntelligence Blog PDF
8 pages
PBI - Bhaskar
No ratings yet
PBI - Bhaskar
9 pages
SQL Fundamentals
No ratings yet
SQL Fundamentals
61 pages
Appendix B DAX Reference
100% (1)
Appendix B DAX Reference
174 pages
Pyspark Cashing & Persisting - Complete Guide
No ratings yet
Pyspark Cashing & Persisting - Complete Guide
3 pages
SQL Case When Statement
100% (1)
SQL Case When Statement
10 pages
25 Pyspark Transformation
No ratings yet
25 Pyspark Transformation
10 pages
SQL Notes
No ratings yet
SQL Notes
96 pages
Practice Exercise Power BI: Tables
No ratings yet
Practice Exercise Power BI: Tables
2 pages
110 SQL Query Interview Questions and Practice Exercises For Experienced and Fre
No ratings yet
110 SQL Query Interview Questions and Practice Exercises For Experienced and Fre
40 pages
Week 04 & 05
No ratings yet
Week 04 & 05
63 pages
Dimensional Data Modeling With Databricks
No ratings yet
Dimensional Data Modeling With Databricks
23 pages
Session-9 Final Notes PRM 45
No ratings yet
Session-9 Final Notes PRM 45
4 pages
Celebrate 50 Years of Microsoft
No ratings yet
Celebrate 50 Years of Microsoft
28 pages
Data Structure and Algorithms
No ratings yet
Data Structure and Algorithms
110 pages
Crime Analysis in India (2001-2013)
No ratings yet
Crime Analysis in India (2001-2013)
23 pages
Excel Mastery With These Guided Projects
100% (2)
Excel Mastery With These Guided Projects
66 pages
Data KPIs Cheat Sheet
100% (1)
Data KPIs Cheat Sheet
12 pages
Limpieza de Datos Con Pandas
100% (1)
Limpieza de Datos Con Pandas
19 pages
R Cookbook: Geospatial Data Processing
No ratings yet
R Cookbook: Geospatial Data Processing
79 pages
The Big Six - SQL
No ratings yet
The Big Six - SQL
23 pages
Trade Tariffs in 3 Levels of Difficulty
No ratings yet
Trade Tariffs in 3 Levels of Difficulty
10 pages
8 Machine Learning Algorithms
No ratings yet
8 Machine Learning Algorithms
13 pages
Inventory Abbreviations
No ratings yet
Inventory Abbreviations
13 pages
100 SQL Commands Notes
No ratings yet
100 SQL Commands Notes
8 pages
Crack Your Databricks
100% (2)
Crack Your Databricks
103 pages
Product Manual 36693 (Revision D, 5/2015) : PG Base Assemblies
No ratings yet
Product Manual 36693 (Revision D, 5/2015) : PG Base Assemblies
10 pages
Class 12 Geography: Planning & Sustainable Development
No ratings yet
Class 12 Geography: Planning & Sustainable Development
40 pages
Jeep Wrangler Brochure - Compressed
No ratings yet
Jeep Wrangler Brochure - Compressed
22 pages
Buy Ebook The Routledge Handbook of Landscape Ecology 1st Edition Robert A. Francis Cheap Price
100% (11)
Buy Ebook The Routledge Handbook of Landscape Ecology 1st Edition Robert A. Francis Cheap Price
41 pages
Che 560 HW5
No ratings yet
Che 560 HW5
1 page
Hospital Setup: 5 Essential Steps
75% (4)
Hospital Setup: 5 Essential Steps
4 pages
Cost Out Engineer: VAVE Mechanical Role
No ratings yet
Cost Out Engineer: VAVE Mechanical Role
2 pages
Za HL 368 Big Book Original in This Together Ver 2
No ratings yet
Za HL 368 Big Book Original in This Together Ver 2
26 pages
4pm1 02r Rms 20230302
No ratings yet
4pm1 02r Rms 20230302
29 pages
Biodiversity and The Healthy Society
No ratings yet
Biodiversity and The Healthy Society
26 pages
Marketing Strategies in Creating Brand Image of FMCG in India With Special Reference To Store Promotion
No ratings yet
Marketing Strategies in Creating Brand Image of FMCG in India With Special Reference To Store Promotion
9 pages
Syllabus Database Management For Business Fall 2024-2025-1
No ratings yet
Syllabus Database Management For Business Fall 2024-2025-1
9 pages
Oil & Gas Construction Services
No ratings yet
Oil & Gas Construction Services
22 pages
Standard of Competence
No ratings yet
Standard of Competence
11 pages
Exercise Solutions For Simulation With Arena PDF
0% (1)
Exercise Solutions For Simulation With Arena PDF
2 pages
American Options Pricing Methods
No ratings yet
American Options Pricing Methods
9 pages
Krebs Cycle Study Resources
No ratings yet
Krebs Cycle Study Resources
1 page
G Codes and M Codes List
No ratings yet
G Codes and M Codes List
3 pages
Petroleum Basin Classifications
No ratings yet
Petroleum Basin Classifications
21 pages
Shock Absorber Design & Analysis
No ratings yet
Shock Absorber Design & Analysis
16 pages
NSO Level 2 Class 7 Science Paper 2017 18 Part 1
No ratings yet
NSO Level 2 Class 7 Science Paper 2017 18 Part 1
5 pages
PROJ
No ratings yet
PROJ
7 pages
Keymaker
No ratings yet
Keymaker
3 pages
Excel Tutorial PDF
No ratings yet
Excel Tutorial PDF
13 pages
Theory 2 - Code of Ethics For Professional Teacher & Historical Development of Teaching
No ratings yet
Theory 2 - Code of Ethics For Professional Teacher & Historical Development of Teaching
5 pages
State Bank of India
No ratings yet
State Bank of India
13 pages
دليل البحث عبر الإنترنت
No ratings yet
دليل البحث عبر الإنترنت
21 pages
Namma Kalvi 12th Commerce Book Inside One Mark Study Material EM 220550
No ratings yet
Namma Kalvi 12th Commerce Book Inside One Mark Study Material EM 220550
145 pages
Heep 111
0% (1)
Heep 111
7 pages

Dimensional Modeling

Uploaded by

Dimensional Modeling

Uploaded by

DATA WAREHOUSING

You might also like