Data
Creator data for a regional report
e-Conomy SEA 2024
BigQuery dataset with SQL cleaning pipeline normalising creator metrics across Meta, TikTok, and YouTube
What I built
In a four-month data analyst role, I built the base BigQuery dataset for creator data and cleaned it in SQL. I used it to trace video-commerce and creator-economy trends across Meta, TikTok, and YouTube for a 2024 regional flagship report Google published with outside research partners.
The hard part
Each platform measures things its own way, so a lot of the work was making their numbers comparable before any trend meant anything.