Data Engineer Associate: AceVR Case Study

Project Overview

This project was part of the DataCamp Data Engineer Associate Certification. It involves cleaning and analyzing user engagement data for AceVR, a virtual reality fitness company, to support their upcoming marketing campaigns.

Technical Skills Demonstrated

• SQL (PostgreSQL): Data cleaning, multi-table joins, and aggregations.
• Data Validation: Ensuring data integrity across users, events, and games tables.
• Reporting: Delivering actionable insights for marketing and sales teams.

Data Cleaning Steps

I processed the users table to ensure it was "reporting-ready":

• Handled missing ages using COALESCE.
• Standardized workout_frequency strings to a uniform lowercase format.
• Validated email formats and replaced missing registration dates.

Key Insights

• Identified 202 unique users for the running game type.
• Extracted targeted user lists for boxing game promotions.
• Successfully audited historical event data before the 2024 cutoff.

Certification

• ID: DEA0013042180445
• Issued: April 19, 2026