Skip to content
View Ucazin's full-sized avatar

Block or report Ucazin

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Ucazin/README.md

Hi, I'm Lucca! 👋

📊 Data Analyst | 🧮 SQL · Python · BI | ☁️ Modern Data Stack

Data Analyst turning raw data into business decisions. SQL · Python · Power BI · BigQuery. I build dashboards, ETL pipelines, and analytics that ship — with a strong interest in experimentation, A/B testing, and analytics engineering on the modern data stack.


🧰 Languages & Querying

📊 BI & Visualization

🗄️ Data Warehouses & Databases

🔧 ETL & Analytics Engineering

🛠️ Tools & Platforms


💡 What I Work With

  • 📈 Analytics & Experimentation: A/B testing, hypothesis testing, cohort & funnel analysis, KPI design.
  • 🧱 Modern Data Stack: dbt models, data marts, semantic layers, data quality testing.
  • 📊 Dashboards & Reporting: Executive reporting, product analytics, marketing attribution, financial KPIs.
  • 🐍 Python for Analytics: pandas, NumPy, matplotlib, seaborn, scikit-learn for predictive modeling.
  • 🧮 Statistics: Regression, segmentation, time-series, confidence intervals, lift calculation.
  • 🗣️ Data Storytelling: Translating findings into clear narratives for non-technical stakeholders.

📊 GitHub Stats


🌟 Featured Projects

  • SaaS MRR, Churn & Cohort Analytics — Subscription analytics on a synthetic SaaS dataset (5,000 customers · 36 monthly snapshots · 3 tiers). MRR waterfall, NRR/GRR cohorts, Kaplan-Meier survival, LTV/CAC. Headline: ending MRR $1.99M, median NRR 85.2%, 12-month survival 53.9%, LTV/CAC up to 17.0× (Growth tier). Diagnosed churn concentrating in months 3–6 of customer life (7–9% vs 2–3% early). Python · pandas · matplotlib
  • Olist E-commerce SQL Analytics — End-to-end SQL analytics on an Olist-shaped Brazilian e-commerce dataset (96,497 delivered orders, 92,315 customers, R$ 14.7M revenue). DuckDB warehouse, Kimball star schema, 10 business-question queries. Headline: late deliveries collapse review score to 1.64/5 vs 3.98 on-time; 86.8% of 8+d-late orders rated 1–2 stars; bottleneck is carrier transit (25.6d) not seller dispatch (13.1d); R$ 560k revenue-at-risk. SQL · DuckDB · Python
  • Portfolio Hub — Index of academic and personal data-science / ML projects from CEUB. New analytics projects shipping daily this week.

📫 Let's Connect


"In data we trust — but only after we test it."

Popular repositories Loading

  1. Ucazin Ucazin Public

  2. portfolio-hub portfolio-hub Public

    Repositorio de projetos academicos e pessoais - Ciencia de Dados e Machine Learning - CEUB

    HTML

  3. olist-ecommerce-analytics olist-ecommerce-analytics Public

    End-to-end SQL analytics on a synthetic Olist e-commerce dataset — DuckDB warehouse, Kimball star schema, 10 business-question queries, Python chart deck.

    Python

  4. saas-mrr-churn-analytics saas-mrr-churn-analytics Public

    Subscription analytics on a synthetic SaaS dataset — 5,000 customers, 36 monthly billing snapshots, MRR waterfall, NRR/GRR cohorts, Kaplan-Meier survival, LTV/CAC by tier.

    Python

  5. ab-testing-framework ab-testing-framework Public

    End-to-end A/B testing framework — power analysis, SRM checks, CUPED variance reduction, BH-corrected segment breakouts, and an auto-generated ship/no-ship decision doc. Built on a 60k-user synthet…

    Python