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

> 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 compactne…

- Web page: https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lecture-v3
- Program: [Data Engineering Boot Camp V2 Combined Track](https://www.dataexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 1: Dimensional Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 1 h 1 min video
- Skills: SQL, Data Modeling, Apache Iceberg
- Academy: DataExpert.io Academy

## About this lesson

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: [Dimensional Data Modeling - Complex Data Types Arrays and Structs with Iceberg (Day 1 Lab)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-1-lab-v3.md)
- Next lesson: [Dimensional Data Modeling - Slowly-changing Dimensions and idempotent queries with Trino (Day 2 Lab)](https://www.dataexpert.io/lesson/dimensional-data-modeling-day-2-lab-v3.md)