# Fact Data Modeling - Compact Tables for Efficient Data Representation with Iceberg (Day 2 Lab) - Pre-recorded from V3

> This is a pre-recorded lesson from V3. This lab guides you through the process of analyzing user activity using compact tables. The lab demonstrates how to create a table that efficiently captures user IDs and their corresponding activity status. We address the intricacies of handling date calculat…

- Web page: https://www.dataexpert.io/lesson/fact-data-modeling-day-2-lab-v4
- Program: [Data Engineering Mastery Course](https://www.dataexpert.io/program/data-engineering-mastery-course)
- Module: Week 2: Fact Data Modeling in Iceberg
- Access: Requires enrollment in Data Engineering Mastery Course
- Length: 39 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. This lab guides you through the process of analyzing user activity using compact tables. The lab demonstrates how to create a table that efficiently captures user IDs and their corresponding activity status. We address the intricacies of handling date calculations and utilizing bitwise operations to represent user activity. The lab captures the presenter encountering and troubleshooting various challenges, providing valuable insights and explanations. By the end of the lab, you will have gained a clear understanding of how to design and leverage compact tables for the purpose of analyzing user activity.[Recorded Nov 15, 2023]

## Navigation

- Previous lesson: [Fact Data Modeling - Minimizing Shuffle and Reducing Facts with Iceberg (Day 3 Lecture) - Pre-recorded from V3](https://www.dataexpert.io/lesson/fact-data-modeling-day-3-lecture-v4.md)
- Next lesson: [Data Accessibility and Privacy (Day 4 Lecture)](https://www.dataexpert.io/lesson/fact-data-modeling-day-4-lecture-v4.md)