Excel to Power BI Migration Project
Fully migrated FP&A dashboards from Excel to Power BI. Engineered relational and non-relational databases
Title Card
Ziyuan Wang
Open to Internship Roles (2027 Jan Start) Open
Project Experience
Real Estate Power BI Project
Built a Power BI real estate dashboard project with portfolio views, operating metrics, and financial performance summaries.
Power BI Marketing Dashboard Samples
Created marketing dashboards with generated datasets to track executive KPIs, paid ads, organic channels, and SEO/website performance.
Movie + TV Recommender
Built an interactive recommender that filters and ranks movies from a CSV dataset based on user preferences like genre, rating, runtime, year, and keywords.
Lung Cancer Similarity Estimator
Built a profile-based similarity estimation demo from 2015-2025 patient records, combining weighted factors and dataset-calibrated scoring.
Basketball Reference Lite
Built a NBA scoreboard page with quarter-by-quarter scoring, Worker deployment, and API fallback handling through web-scraping.
SPY(ETF) Price Forecaster
Built LSTM models (90/30/10-day lookbacks) to predict next-day SPY adjusted close. Evaluated against a moving-average baseline and actuals.
Analysing LNY Effect on HK Stock Market
Analyzed 2015-2025 Hang Seng data across Pre-LNY, Post-LNY, and baseline windows using risk-return metrics and hypothesis testing.
Facial Emotion Detector
Real-time browser app that uses MediaPipe face landmarks and blendshape scores to classify facial emotion.
Gojo's Hollow Purple
Real-time hand movement detector powered by MediaPipe Hand Landmarker with live motion-speed tracking.
Latest Project/Achievement
Hitting Diamond I on Teamfight Tactics (Set 16)