About Me.


Agnes CHAU

Data Analyst based in Düsseldorf, Germany

#dataviz #tableau #Power BI #SQL #python #datascience #machinelearning


I am results-oriented and data-passionate, skillful in managing and breaking down large volumes of information. Being curious and independent, I explore and identify data issues and monitor performance metrics to achieve business and strategic goals. I am a strong team player and perform well in cross-functional teams.


I've created several data visualization projects using BI tools such as Tableau, shinydashboard, PowerBI, etc.

I'm very familiar with machine learning workflow and algorithms. I've done several machine learning projects coded in Python ( used libraries such as: pandas, numpy, tensorflow, keras, sklearn etc. )


If you're interested in me for any opportunity, don't hesitate to contact me.



See projects >> Contact me >>

My Projects

Project Name Description Skillset Link Last Update
Avocado Price Analysis Provide the insight of the avocado price and the potential growth in US #Tableau #PowerBI #DataViz #PriceAnalysis PDF May 2022
New York Airbnb Price Analysis As the role of data analyst, providing the insight of the host performance from 2008-2015 in New York #PowerBI #DataViz #PriceAnalysis PDF Apr 2022
ML customer churn rate prediction Applied ML models to predict the customer churn rate in telecom company #MachineLearning #Regression #RandomForest #Python #sklearn #pandas #numpy Github Feb. 2022
Price Analysis of Airbnb in Paris Dashboard Used Airbnb data to analyze key figures based on the location and showcased the plots with shiny dashboard. #DataViz #R #shiny #shinydashboard #tidyverse shiny Mar 2022
BeeLikePro Application It is a school sustainability project aiming at building an application to connect the bee professional and beekeepers specifically in France #WebDesign #HTML #CSS #JavaScript #Figma Website Figma Nov 2021
Stock Checking Telegram Bot A small python Bot with Telegram notifications for checking price changes of stock in Hong Kong market. #Python #Beautifulsoup #Scrapy #yfinanceAPI Github Apr. 2021

My Experience

Professional Experience
Data Analyst
L'Oréal Group 		Düssledorf, Germany
Current
  • Independent creation and evolution of modern reports and visualizations for monitoring, benchmarking and analyzing CRM / e-commerce / media performance KPIs
  • Based on data and analytical insights, supporting in deriving best practices and developing suitable strategies with the aim of driving customer/channel growth
E-commerce Coordinator EMEA (MAC Cosmetics)
Estée Lauder Group 		Paris, France
07/2022 - 12/2022
  • Sales Analytics: provided data-driven actionable recommendations to 18 markets by tracking & analyzing customer purchase trends, new product launches & promotional campaigns performance, increased website traffic by 10% and conversion rate by 1-3% monthly
  • Reporting & KPI Dashboards: led monthly and weekly site performance reviews to establish KPIs and strategic plans, providing real-time business insights to stakeholders (Global Head of Brand Retail, 18 Market Managers)
  • Workflow Automation: automated 2-hour repetitive data collection task to 5 minutes by using Python, increasing efficiency by 95%
Data Analyst
Waysia (Ex. Alorfaim) 		Paris, France
03/2022 - 06/2022
  • Data Flow Automation: enabled fast and timely analysis & decision-making by automating Tableau ETL (extraction, transformation and load) process with Data Flow
  • Predictive Analytics: created a customer segmentation model and predicted the customer churn rate, tailored customer acquisition & retention strategy, the model achieved 90% accuracy & increased 5% of customer engagement rate
E-commerce Assistant
Caudalie 		Hong Kong
08/2020 - 08/2021
  • Digital Marketing & Analytics: implemented targeted social media campaigns for Facebook, Instagram & Google Ads & drove an additional 10% monthly website visits and 5% increase in conversion rate, deployed Google Analytics (GA) to optimize ROI of paid marketing campaigns
  • Customer Insights: ensured relevant personalized online communication, within the CRM team, based on customer behavior & buying preferences, resulting in a 30% improvement in email performance and a decrease in unsubscribe rate
  • Business Analytic: communicated with key stakeholders (Global & APAC Marketing Head) to identify business requirements, perform customer analysis and build customized dashboards to address these requirements
  • Management: managed a team of 3 people to ensure smooth running operations
  • Customer management: handled over 30 customers daily to address questions or complaints from email, phone and social media platforms

    • Reference Letter
Marketing Executive (Intern)
Integrated Management System 		Hong Kong
04/2020 - 08/2020
  • Responsible to create monthly social editorial calendars for 3 brands on social media (Facebook, Instagram and Twitter)
  • Implemented social listening by using Brandwatch for market research and developed social media strategy
  • Organized weekly eDMs using Salesforce Marketing Cloud
Marketing Associate (Intern)
Shun Hing Electronic Trading Co. Ltd. 		Hong Kong
06/2018 - 08/2018
  • Lead a summer promotion campaign and finally generated a 20% increase in revenue comparing to the same period of last year
Project Assistant (Intern)
Burberry Group Inc. 		Hong Kong
07/2015 - 08/2015
  • Tracked project performance to analyze successful completion of short- and long-term goals
  • Identified project scopes, constraints, risks and deadlines
  • Obtained needed resources by strategically negotiating with stakeholders and outside suppliers

Education
Msc in Data Science
EMLyon business school 		Paris, France
09/2021 - 12/2022

    Specialization: Data Science

    • Data Visualization (Tableau, PowerBI, R shiny) • R • SQL, PostgreSQL • Python (pandas, numpy, sklearn...) • Machine Learning • Deep Learning • Dataiku DSS • Text mining • AI and disruptive technologies • Google Analytics & Data Studio

    Learning trip to Silicon Valley in San Francisco
Bachelor of Business Administration in Applied Economics
Hong Kong Baptist University 		Hong Kong
09/2016 - 07/2020

    • Econometrics • Macro Economic • Game Theory • Statistics

    Upper Second-Class Honours

    Appointed as the peer mentor of School of Business to assist over 200 first-year students to adapt college life for 3 consecutive years

• Download my CV in PDF here: English Last updated: 10 Apr 2023

Contact Me.

Agnes CHAU

Based in Düsseldorf, Germany

Data Analyst

E-mail: agneschau.fr@gmail.com