# Fact Data Modeling: Compact Tables for Efficient Data Representation 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.

- Web page: https://learn.dataexpert.io/lesson/fact-data-modeling-day-2-lab-yt
- Program: [Boot Camp: Community Edition](https://learn.dataexpert.io/program/free-community-boot-camp.md)
- Module: Fact Data Modeling
- Access: Requires enrollment in Boot Camp: Community Edition
- Length: 45 min video
- Skills: SQL, Data Modeling
- Academy: DataExpert.io Community 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.

## Navigation

- Previous lesson: [Fact Data Modeling: Core Elements in Data Modeling Day 2 Lecture](https://learn.dataexpert.io/lesson/fact-data-modeling-day-2-lecture-yt.md)
- Next lesson: [Fact Data Modeling: Minimizing Shuffle and Reducing Facts Day 3 Lecture](https://learn.dataexpert.io/lesson/fact-data-modeling-day-3-lecture-yt.md)
