01↗Industrial Instrument Sales Analytics
An end-to-end pipeline that turns inconsistent sales records into decision-ready reporting.
Python · pandas · SQL · SQLite · Matplotlib
2,500 orders+5.51% YoY revenue10 reports automated
Gainesville, FL · Open to data analytics opportunities
Turning complex data
into clear answers.
Hi, I’m Siyuan (Lucas) He, an M.S. Biostatistics student building practical analytics solutions with Python, SQL, Tableau, and Power BI.
SELECTED WORK
ANALYSIS · AUTOMATION · BI01↗
02↗Energy AI Assistant Evaluation
A repeatable evaluation framework for bilingual energy-service AI responses.
Python · pandas · Regex · Tableau
20 bilingual tests70.0% pass rate1.85 sec response
ABOUT
Good analysis goes
beyond the answer.
It explains why.
I’m pursuing an M.S. in Biostatistics at the University of Florida after earning a B.S. in Mathematics and Physics from the University of Toronto.
My work combines data cleaning, KPI analysis, SQL, automation, and visualization. I focus on making analysis rigorous, transparent, and useful to the people making decisions.
2.5Korders analyzed20AI test cases10reports automated