Data Analysis Projects
Conducted logistic regression, decision tree and random forest by using R to analyze 130k survey data. Discovered the best model to predict customer satisfaction and identified valuable variables for airline companies to make decisions.
Transformed raw data to operational data through handling missing values and mapping data. Conducted logistic regression, decision tree, random forest models to evaluate current customer segmentations. Built a new segmentation model baed on RFM (Recency, Frequency and Monetary) to generate targeted marketing strategies.
Extracted valuable insights for stakeholders by using MySQL, Python and PowerBI to analyze YouTube dataset of 50k trending videos. Generated a Wordcloud of popular video tags, and analyzed popular channels to provide suggested video contents.
Identified key features that could increase the likelihood of winning the lottery by using Tableau dashboards to analyze 217k lottery application data. Provided data-driven recommendations to maximize the possibility of winning the lottery.
Defined user personas of different device types by using Adobe Analytics tool to analyze Hilton’s web and mobile search data. Discovered the highest bounce rate through the digital booking flow to help improve user experience.
Marketing Analysis Project:
4Ps and 5Cs Analysis on Uber
Conducted 4Ps (Product, Price, Promotion, Placement) and 5Cs (Company, Consumer, Competitor, Collaborator, Content) Analysis on Uber. Identified data applications to different strategic environments.
2021 DailyView Best Reviewed Online Awards
Led a cross-functional team to organize the first awards based on online public opinion volume and sentiment analysis. Boosted visibility of 50+ potential clients and 100+ media coverage through analyzing Post-COVID industrial trends.
Influencer Marketing Analysis for Estée Lauder
Created an innovative statistical model to identify and rank appropriate influencers who generated the most sales growth. Increased the engagement rate of social media by 95% and video view rate by 486%.
DailyView Special Coverage on Internet User Behaviors
Evaluated information gathered from multiple resources and applied diverse perspectives such as sociology theories to social media analytics. Classified social media posts through text mining and produced an interactive website to elaborate the results.