Skip to content
View Kevin-yyuan's full-sized avatar

Block or report Kevin-yyuan

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.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. 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
Kevin-yyuan/README.md

Hi, I'm Kevin 👋

Data Solutions Architect in Vancouver. I build the layer between raw data and the dashboards people trust: dbt models, warehouse design (Snowflake, BigQuery), data quality checks, and the reconciliations that prove a number is right before anyone acts on it.

I write about that work twice a week on LinkedIn: short field notes on Tuesdays, longer articles on Thursdays. All my projects are also at kevinyy.com.

What's here

All data in these repos is synthetic, and each project includes the script that generates it.

Tools I use most: SQL · dbt · Snowflake · BigQuery · Python · Airflow · Sigma / Power BI · React for the occasional front end

📫 The best way to reach me is a message on LinkedIn.

Pinned Loading

  1. dbt-reconcile dbt-reconcile Public

    Catch the fact-table bugs that pass every test: dbt tests that reconcile a model to its source (row counts, totals, grain) + a runnable buggy/fixed demo on DuckDB

    Python

  2. project_lighthouse project_lighthouse Public

    Full-stack capex analytics app: synthetic data → validated ETL (pandera) → Flask API → React dashboard with forecasts

    Python

  3. shipping_route_map shipping_route_map Public

    Interactive React + Leaflet map of a week of shipping routes, with filters and a driver performance table

    JavaScript

  4. customer_churn_risk_dashboard customer_churn_risk_dashboard Public

    Next.js + MUI dashboard that puts a churn model's at-risk clients in front of a non-technical sales manager

    TypeScript

  5. warehouse_volume_forecast warehouse_volume_forecast Public

    4-week warehouse volume forecast with prediction intervals, served as a Streamlit app

    Jupyter Notebook

  6. data_cleaner data_cleaner Public

    ShipmentETL: Python CLI that standardizes messy shipment CSVs (dedup, dates, text, currency, missing values)

    Python