LYUHUAN
I'm an analyst who builds the tool when the off-the-shelf one doesn't fit.
PM-turned-analyst | Data storytelling | AI tooling | Toronto
YAO.
02 · about

Ask me.

A. How I think
Problem scoping
What's the decision? What's worth measuring? Start there.
Stakeholder translation
Business intent → technical spec → delivered insight.
KPI design & storytelling
Define the metric, then make it land with the room.
End-to-end ownership
Discovery → delivery, comfortable in the full loop.
B. How I execute
SQL & Python
CTEs, Pandas, NumPy.
Dashboard development
Power BI, Excel, HTML interactive reporting.
LLMs & AI tooling
Claude API, RAG, prompts that behave.
Workflow automation
Agentic AI, API integrations, Make.
03 · projects

Same work. Smarter loop.

From "we have data" to "we know what to do" — faster.

01 / 04
01
Claude Agent SDKPythonMulti-agent orchestration

Competitive Analysis Agent

Works like a junior market analyst — give it a company name, it researches across 6 dimensions, cross-checks sources, and delivers a structured report. 4–6 hours of work, done in 15 minutes.

GitHub ↗
02
PythonClaude APIVector DBStreamlit

AI Product Insights

24K app reviews no one had time to read. This tool lets PMs query them like asking a junior product analyst  and walk into roadmap discussions with evidence, not gut feel. 

GitHub ↗
03
SQLiteMakeETL

Automated ETL Workflow

A daily data ritual that used to eat an hour of someone's morning. Now it pulls, cleans, validates, and alerts on its own. Zero manual touch.  An analyst can spend that hour on work that actually needs a brain.

GitHub ↗
04
Interactive DashboardData VisualizationGeospatial Analysis

Airbnb Toronto BI Solution

Hosts ask: where to list, how to price, what makes guests return. I turned 40K bookings into dashboards that surface the answers by neighborhood, season, and property type, so hosts can stop guessing and start pricing with confidence.

Interactive dashboard ↗
LET'S
TALK.