- Tracked sales of China Infant Milk Formula Online Market and filtered data for various brands and products to build customized databases- Assisted in the updates of the Paediatric Dashboard, visualizing given segments' monthly volume and value share to evaluate brand dynamics

- Investigated the trends of the high-end skincare market in China, classified consumers into categories and studied their purchasing behavior in offline and online channels; performed risk analysis and made strategic decisions for clients entering the Chinese high-end skincare market - Participated in the focus group and in-depth discussions, identifying the target consumers and potential opportunities and challenges for the Manuka Honey brand in the Chinese market; performed… Show more - Investigated the trends of the high-end skincare market in China, classified consumers into categories and studied their purchasing behavior in offline and online channels; performed risk analysis and made strategic decisions for clients entering the Chinese high-end skincare market - Participated in the focus group and in-depth discussions, identifying the target consumers and potential opportunities and challenges for the Manuka Honey brand in the Chinese market; performed subsequent analysis on the consumer positioning and the market promotion for this brand Show less

- Utilized SPSS to calculate customers' feedback on Pepsi and Coca-Cola's New Year Campaign, and compared the campaign performance in different cities and channels based on 750 questionnaires; independently compiled an annual Campaign Performance Report - Collaborated with colleagues to analyze the questionnaires of Mirinda among high-frequency users in the Northeast; utilized Excel to calculate performance trends and visualized monthly sales, built code frame and dp spec, and… Show more - Utilized SPSS to calculate customers' feedback on Pepsi and Coca-Cola's New Year Campaign, and compared the campaign performance in different cities and channels based on 750 questionnaires; independently compiled an annual Campaign Performance Report - Collaborated with colleagues to analyze the questionnaires of Mirinda among high-frequency users in the Northeast; utilized Excel to calculate performance trends and visualized monthly sales, built code frame and dp spec, and formulated evaluation reports - Tracked the monthly campaigns and sponsorship of Pepsi carbonated beverage brands and its competitors, updated the input sheet and code frame, and evaluated consumers' awareness, preferences and purchase intention of different products based on the analytic results Show less

- Developed a standard working method report, and simplified the collation procedures of the data standard list to optimize the database for the company and manage the customer data, promoting internal and external auditing and supervision of data information- Assisted the team in creating Data Standard Management Procedures and Data Quality Management Procedures, as well as producing the conclusion report for the AIA data governance project; standardized the process of data use… Show more - Developed a standard working method report, and simplified the collation procedures of the data standard list to optimize the database for the company and manage the customer data, promoting internal and external auditing and supervision of data information- Assisted the team in creating Data Standard Management Procedures and Data Quality Management Procedures, as well as producing the conclusion report for the AIA data governance project; standardized the process of data use, maintenance and management Show less