Applied knowledge
Real case studies by Henry Mariño on data analytics, automation, marketing and applied AI, explained step by step.
Browse as projects →Article / case study
How I built a tested, secure weather ELT pipeline with Airflow, dbt, PostgreSQL and Superset on a free 100-call API, then published a branded, embeddable dashboard.
Read case study →Article / case study
End-to-end ecommerce analytics project focused on returns, profitability, product performance, acquisition quality, and fulfillment. I built the analytical pipeline from PostgreSQL and Python through reusable data marts and an interactive Metabase dashboard, then reconciled dashboard metrics directly against SQL before publishing the final analysis.
Read case study →Article / case study
Discover how Vibe Coding transforms data analysis. See how I automated a complex CRM data cleaning pipeline in Google Sheets using AI-assisted Google Apps Script, reducing hours of manual work to seconds.
Read case study →Article / case study
Discover how "Vibe Coding" is revolutionizing how Data Analysts build high-performance portfolios. Learn to integrate Metabase, Directus, and Astro using AI-driven development to impress top tier recruiters.
Read case study →Article / case study
Analytics review of used cars sourcing for the United states automotive market
Read case study →