In this lesson, we’ll be talking about the technical aspect of categorization – when and where it happens, how it’s tracked, how the categorization data makes its way to the data warehouse.
AB-test categorization
To categorize a user for an AB-test means to assign this user a variation of the AB-test. This is why we imagine that this association between AB-test variations and users could be stored in a data warehouse like this:
ab_test_name | ab_test_variation | user_id | categorized_at |
onboarding_abtest | control | 1234 | 2018-03-08 10:33:13 |
... |
Sign up and check out 36 free lessons and exercises.
About SQL Habit
Hi, it’s Anatoli, the author of SQL Habit. 
SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst
and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (you’re looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything you’ve learned at work. 