Product Business Analyst Technical Exercise
Instructions:
1. This test is designed to assess your technical knowledge and long-range thinking as a
Product Business Analyst.
2. You are required to answer the following questions to the best of your ability.
3. Please provide concise and precise answers to each question.
4. Please submit your completed assessment for evaluation to [Link]@[Link]
and sonny@[Link].
5. Be prepared to discuss your answers with the team.
6. Reach out to Sonny directly with any questions.
Best of luck!
Technical Exercise:
Given a theoretical dataset that contains values such as the following:
user_id: Unique identifier for each user.
session_id: Unique identifier for each session.
session_start_time: Timestamp when the reading session started.
session_end_time: Timestamp when the reading session ended.
pages_read: Number of pages read in the session.
genres_read: The genre of books being read in each session.
time_spent: Time spent in the app (in minutes) during a session.
features_used: List of app features used in the session (e.g., bookmarks, search, highlights).
app_version: Version of the app being used during the session.
device_type: Type of device used (e.g., smartphone, tablet).
1. How would you create user segments based on their behavior?
For example, you could segment users into categories such as:
● Highly engaged users (e.g., those who read more than 50 pages per session).
● Casual readers (e.g., users who spend less than 10 minutes per session).
● Power users (e.g., users who use more than 3 features per session).
Describe your method used to segment users (e.g., clustering, percentiles, etc.).
2. Trends Over Time
How would you analyze how user engagement changes over time? For example:
● How does the average number of pages read per session vary by week/month?
● Is there any seasonality or trend in usage (e.g., more reading during holidays)?
● Compare engagement between different app versions or devices.
3. Feature Usage Analysis
● How would you determine which app features (e.g., bookmarks, search) are used
the most, and how does their usage correlate with session length or pages read?
● Can you identify any patterns in how different types of users use specific features?
4. Retention Analysis
● How would you calculate user retention rates (e.g., 1-day, 7-day, and 30-day
retention) based on the data available?
● If you have access to a cohort of users (those who joined the app on the same day),
how would you calculate the retention over time for that cohort?
● How can this analysis help improve user engagement?
Bonus:
How would you use statistical or machine learning techniques to predict which users are likely
to churn (stop using the app) based on their behavior patterns?
