La Liga - Newsletter Analytics - Power BI

Built an end-to-end measurement system using SQL + Power BI to track how clubs engaged with LaLiga’s monthly newsletter.

Tech highlights:

SQL modeling (CTEs, joins, window functions) to merge opens, clicks & roles.

Custom engagement score based on role-weighted opens/clicks.

Power BI dashboards with monthly trends, club rankings & department insights.

Result: A clear, scalable framework to measure real engagement across all LaLiga clubs.

Cleaned and merged email data (opens, clicks, send logs).

Built a unified fact table using CTEs, joins, and window functions.

Implemented a weighted scoring model based on user role and actions.