Vicky HU
Vicky HU
MSDA Grad @ Kansas State University
MIS Grad @ National Chiayi University
MSDA Grad @ Kansas State University
MIS Grad @ National Chiayi University
Data ANalytics
MySQL || Tableau || R || Web Scraping || Statistics || Conjoint Analytics
- Applied business analytics to process 114K records with SQL for data cleaning, aggregation, and feature engineering
- Developed 10+ Tableau dashboards visualizing loans, profitability, and risks to support executive decision-making
- Recommended 3 data-driven strategies to boost repayment rates and mitigate default risks
- Analyzed LEGO reviews using Python (NLP, TF-IDF, Gensim NMF) to uncover key trends and sentiments.
- Identified popular sets (cars, bikes, Technic) and themes like quality, value, and suitability as gifts for boys.
- Found 76.92% positive reviews and peak review periods, providing insights to guide targeted marketing strategies.
- Performed business analytics on 20K+ used car listings to model pricing trends
- Performed EDA in R (dplyr, ggplot2) to identify key factors influencing used car prices, including mileage and brand
- Delivered actionable business insights through statistical analysis, enhancing regional pricing strategies
Hotel Design-Conjoint Analysis
- Used Conjoint Analysis to evaluate business travelers' preferences for the new Forte Executive Inns hotel, identifying key features like room size, amenities, and services that drive customer choices.
- Applied Fractional Factorial Design and K-means Clustering to streamline data collection and segment customer preferences for targeted marketing.
- Calculated market share estimates and identified the most preferred option, providing strategic recommendations for the hotel’s success in the U.S. market.
