· Using SQL to pull UK sellers that had committed violations and their sales performance on other sites, filtering suspected high-risk sellers, and visualizing business conversions with Tableau. · Implemented all GC sellers’ sales data and collected traffic performance via SQL, thereafter analyzed the annual and monthly data changes, and published the referring data on digital platforms through R shiny.

Independently analyzed the relationship between e-commerce platform promotion methods and different commodity categories and price ranges by using K-means clustering and regression through R language,with the new findings raising the usage of promotion tools by 10%.Summarized the logic and ideas of e-commerce stores’ promotional methods, optimized promotion sale plans, and established targets, based on the product category and seller type.