About Me
I have experience working with data in the form of reports, research, and analysis as part of my job in the fields of Hospitality and Industrial Real Estate. I realized a strong interest in working data, so recently, I decided to take a break from my career and dive deep into data analytics and business intelligence.
The more I learned and practiced, the more certain I felt that this was exactly what I was looking for. I enjoy playing with data, making sense of it, telling stories about it, and using it to make better evidence-based decisions.
Now I am looking for a challenging and rewarding opportunity in data analytics and business intelligence. I am eager to learn and grow in this field, and I am confident that I can contribute value by helping businesses make better decisions and achieve their goals.
Projects
Data Exploration with SQL BigQuery: Website Conversion Rate
This project aims to explore 2.4 million rows of web data from a fictitious e-commerce clothing company from 2019 to the present using SQL on Google BigQuery and Google Sheets for quick data visualization. The goal is to draw significant insights and give recommendations for the primary business question: how to increase the website conversion rate.
Tools & Skills
- SQL
- Google BigQuery
- Google Sheet
- Exploratory Data Analysis
- Data Visualization
Cohort Analysis: Customer Retention, Segment by Quantity and Revenue
This project uses Python and Jupyter Notebook to perform time-based cohort analysis to find significant trends and patterns in retention rate, order item quantity, and revenue of different customer cohorts based on their acquisition time. The goal is to provide recommendations for optimizing sales and marketing strategies to improve overall performance.
Tools & Skills
- Python
- Jupyter Notebook
- Data Visualization
Market Basket Analysis: EDA, Data Visualizations and Association Rules Mining
This project uses Python and Jupyter Notebook to perform data pre-processing, data exploration, data visualizations, and market basket analysis of an Edinburgh bakery café called "Bread Basket".
Tools & Skills
- Python
- Jupyter Notebook
- Data Wrangling
- Exploratory Data Analysis
- Data Visualization
- Statistical knowledge
Maven Toys Company - Executive Performance Summary
This project uses Power BI to create an interactive report of the sales performance of a Mexico toy company, providing stakeholders with significant insights into store and product performance. These insights can be used to optimize sales and marketing strategies.
Tools & Skills
- MS PowerBI Desktop
- Power Query
- Data Visualization
Airbnb Listings Analysis in 5 Asian Cities
This project uses PowerBI Desktop to provide broad audiences with a comprehensive analysis of lodging properties listed on Airbnb in Bangkok, Tokyo, Taipei, Hongkong and Singapore to deliver meaningful insights into listings in these markets.
Tools & Skills
- MS PowerBI Desktop
- Power Query
- Data Visualization
Google Data Analytics Professional Certificate Capstone Project: Cyclistic - Member & Casual Analysis
This is the final project for the Google Data Analytics Professional Certificate. After completing eight courses in this program, I am excited to apply what I have learned to conduct my first project as a junior data analyst. This project uses R to perform nearly all steps of the analysis of a large dataset of nearly six million rows, from data cleaning, manipulation, transformation, and visualization.
Tools & Skills
- R
- Kaggle Notebook
- Data cleaning and preparation
- Exploratory Data Analysis
Experience
Twenty Plus Holdings Investment JSC.
2022 - 2023
Secretary of the Board of Directors
Skills: Office Administration · Problem solving · Analysis · Communication
Marina Bay Vung Tau Resort & Spa
2019 - 2021
Assistant Sales Manager
Skills: Cross-functional Collaborations · Negotiation · Customer Satisfaction · Communication · Problem solving
Education
Foreign Trade University
Bachelor's degree, International Business Economics
2015 - 2019
GPA: 3.59/4.00 (8.6/10)
Google Data Analytics Professional Certificate
Google Business Intelligence
I appreciate any constructive comments or feedback on my work. If you have any questions, or would like to learn more, please feel free to contact me at tranthienmy2201@gmail.com. Thank you!