Data & analytics · Personal blog
Practical notes on turning messy data into clear decisions, walkthroughs of the tools I use, and lessons from doing the work.
Read the blog
Featured Power BI & Dashboards
How I turned a raw sales CSV into a clean Power BI dashboard — importing data, shaping it in Power Query, modelling it, writing DAX measures, and designing the report.
Read article · · 4 min read
Marketing Analytics
Calculate Meta Ads ROAS in BigQuery with SQL you can reuse — the core query, ROAS by campaign and over time, and the gotchas that make BigQuery and Ads Manager disagree.
· 9 min read
Marketing Analytics
A Skyvia Facebook Ads replication can finish successfully yet leave the BigQuery table empty or stale. Diagnose the cause with a clear checklist and non-destructive BigQuery SQL.
· 12 min read
CRM & Salesforce
A plain-English look at what a CRM like Salesforce is really for, why CRM data quality matters, and how messy data quietly breaks the reports and dashboards built on top of it.
· 4 min read
SQL & Data Wrangling
The core SQL queries for data analysis — filtering, grouping, joins, window functions, and CTEs — explained with beginner-friendly examples you can reuse.
· 4 min read
I'm a computer science student at Université de Montréal and a Marketing & Business Intelligence Intern at Tennis Canada. This blog is where I write about data, analytics, and the business technology I work with.
More about me →