SQL portfolio
Data models that set the stage for great dashboards
Clean, modular SQL ensures every visualization is grounded in accurate, trustworthy data.
Customer Engagement Analysis with SQL & Tableau
Analytical queries and Tableau dashboards that surface how students learn, purchase, and revisit content on a digital platform.
SQL approach: CTEs for modular analytics, reusable views, and analytical queries that feed visual storytelling.
Query highlights
- CTEs to segment ratings, minutes watched, and purchases.
- Reusable views for consistent reporting across dashboards.
- Targeted queries to uncover top purchasing countries and months.
Insights unlocked
- English-speaking regions dominate purchases, highlighting localization opportunities.
- High engagement but low conversion in India and Nigeria prompted regional pricing experiments.
- Odd-month campaigns outperformed even months, confirming marketing pulses.