# Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lecture) - Pre-recorded from V3

> This is a pre-recorded lesson from V3. In this presentation, we explore the fundamental concepts essential for effective data modeling and database management. We dive into understanding your data consumer, the distinctions between OLTP and OLAP data modeling, the principles of Cumulative Table des…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v4
- Program: [Data Engineering Mastery Course](https://www.dataexpert.io/program/data-engineering-mastery-course)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Mastery Course
- Length: 48 min video
- Skills: SQL, Data Modeling, ETL/ELT, Apache Iceberg
- Academy: DataExpert.io Academy

## About this lesson

This is a pre-recorded lesson from V3. In this presentation, we explore the fundamental concepts essential for effective data modeling and database management. We dive into understanding your data consumer, the distinctions between OLTP and OLAP data modeling, the principles of Cumulative Table design, and the tradeoff between compactness and usability. We also address the challenges of temporal cardinality explosion and the potential pitfalls of run-length encoding compression. By the end of this lecture, you will have a strong foundation in the key concepts of data modeling and be prepared to apply these principles in practice. [Recorded Nov 7, 2023]

## Navigation

- Previous lesson: [V3 Boot Camp Kick-Off](https://www.dataexpert.io/lesson/boot-camp-kick-off-v3.md)
- Next lesson: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab) - Pre-recorded from V3](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lab-v4.md)