Jiayu Fang

• Using Excel like pro, including Pivot Tables and VLOOKUP to explore a large dataset

• Create basic charts in Tableau and interactive dashboards

• Analyze and explain A/B test results

• Transformed string-type values into one-hot encoding and standardized it.

• Tried various parameters to determine best K-means clustering model with the minimum silhouette score and grouped the data.

• Calculated various key metrics for each cluster, including average registration rate, average search volume, average advertising duration, average conversion rate, etc.

• used MySQL to remove select necessary data and import into Python.

• grouped data by month using the "group by" operation, and calculated changes of the number of users

• calculated website's purchase rate and visualized result by line chart.

• computed The n-day retention rate and the repeat purchase rate by dividing number of user who login today and n days before by number of the same user who login in n days before.