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

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

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

## About this lesson

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 - Core Concepts, Deduplication Techniques, and Retention Considerations with Iceberg (Day 1 Lecture) ](https://www.dataexpert.io/lesson/fact-data-modeling-day-1-lecture-v3.md)
- Next lesson: [Fact Data Modeling - Core Elements in Data Modeling with Iceberg (Day 2 Lecture)](https://www.dataexpert.io/lesson/fact-data-modeling-day-2-lecture-v3.md)