HI THERE!

WELCOME TO MY PORTFOLIO

Hello!

l am Linh Duong, I'm thrilled that you're here.

A young curious and driven marketing analyst based in Germany, who sees data as the roots of understanding. I transform marketing and business data into clear, actionable insights. With hands-on experience in Google Analytics, SQL (SSMS), Python, Power BI, and Excel.

My goal is to move beyond reporting "what happened" to diagnosing "why it happened" and suggesting "what we should do next." I am passionate about using data to optimize customer journeys, measure campaign effectiveness, and support strategic decisions.

MY RECENT PROJECTS

01

HUMAN RESOURCE ANALYSIS

Employee Demography

Employee Head Count

Training Cost and Effectiveness

View the project

An end-to-end analysis report provides an overview demographic and headcount of company to optimize Human Resource strategy and its planning. By utilizing DAX Measures, I evaluate the training investment per department to find out its effectiveness, do impact analysis and give recommendation for the Human Resource. Moreover, a core focus is a deep dive into the turnover rate and retention dynamic rate, providing the Human Resource an actionable insights into employee lifecycle trends to strengthen the talent retention and the company stability.

Source: Kaggle

02

SALE & MARKETING ANALYSIS

Customer Segmentation

RFM Analysis

View the project

A Sale and RFM Analysis report which based on customer purchasing behaviour to prioritize the high-value customers, so that the Sale and Marketing teams can identify upsell and cross sell opportunities based on the customer segmentation. The report also provides the sale analysis to identify the revenue and profit gained from internet customers and resellers.

Source: AdvantureWorks Database

03

DIGITAL MARKETING ANALYSIS

Campaign and Advertising Investment

Conversion Rate and CTR

View the project

This Digital Marketing dashboard showcases a company's performance in the baby products space, highlighting revenue and profits over three years (starting from 2022). It also breaks down key metrics like Ads spend, Click through Rate, Conversion Rate giving insights into whether the advertising investment is paying off. Moreover, the report gives the marketing and sales team the insights to make smarter decisions like which ads and campaign channels are actually driving the most profit. It also answers the big question: are we winning on profitability or just running in place?

Source: Kaggle

MY TECHNICAL SKILLS

WHAT COLLEAGUES SAID ABOUT ME?

Marcel Heinemann

Assist Hotel Manager at Premier Inn Germany

“Es macht viel Spaß mit Linh zu arbeiten. Sie ist freundlich, wissbegierig, proaktiv und bietet ihren Kolleginnen und Kollegen immer eine helfende Hand..."