Data Analysis Journal

Share this post
How To Create User Profiles in SQL
dataanalysis.substack.com
SQL

How To Create User Profiles in SQL

You might get this task on your next SQL interview.

Olga Berezovsky
Sep 2, 2020
Comment
Share

User profiling is a very common type of data analysis, which helps you segment a user base into fractions to learn and understand customer type and behavior.  

For this exercise, we will take a look at user actions across the webpage and bucket them into categories, which may be used for additional deep-dive analysis, A/B testing, or user research later …

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2022 Olga Berezovsky
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing