Analyze VR App Usage and Engagement Metrics
Company: Meta
Role: Data Scientist
Category: Data Manipulation (SQL/Python)
Difficulty: Medium
Interview Round: Onsite
vr_usage
+---------+------------+---------+------------+----------+
| user_id | date | app_id | session_id | duration |
+---------+------------+---------+------------+----------+
| 10 | 2023-08-01 | 1001 | 555 | 1800 |
| 10 | 2023-08-02 | 1002 | 556 | 2400 |
| 11 | 2023-08-02 | 1001 | 557 | 1200 |
| 12 | 2023-08-03 | 1003 | 558 | 3600 |
| 10 | 2023-08-04 | 1001 | 559 | 900 |
+---------+------------+---------+------------+----------+
apps
+---------+-----------+--------------+
| app_id | app_name | app_category |
+---------+-----------+--------------+
| 1001 | SpaceWar | game |
| 1002 | VRChat | social |
| 1003 | HomeView | home |
+---------+-----------+--------------+
##### Scenario
Oculus VR usage logs and app catalog; product team needs insights into most-used apps and category engagement.
##### Question
Which app had the greatest total usage duration in the last 30 days? 2. What percentage of total VR time in that period belongs to each app_category? 3. Test the hypothesis: users of “social” apps are more engaged than users of “game” apps. Define an engagement metric, outline the SQL, and describe the statistical test.
##### Hints
Join usage with apps, filter date >= CURRENT_DATE-30, aggregate durations; for hypothesis you might use active days per user.
Quick Answer: This question evaluates data manipulation and analytical competencies, including SQL/Python joins and aggregations, time-window filtering, definition of engagement metrics, and basic statistical hypothesis testing.