Hey there!

I am

Samuel Lam

A passionate Data Analyst

ABOUT


Who am I?

I am a Data Analyst with a genuine passion for turning data into impactful insights that shape businesses and communities. Numbers, math, and coding have fascinated me since I was young – anything that involves calculations, problem-solving, and logic. Data analytics is where all these interests collide and create magic, allowing me to find the creative expression of numbers and to craft stories from complex data sets, which just clicks perfectly for me!

I have deepened my data analytics journey through courses like the Google Data Analytics Professional Certificate and the Generation Data Analytics Bootcamp. These experiences have given me the tools – SQL, Python, R, Excel, Tableau, and Power BI – to transform data into actionable insights. I find it so enjoyable when working on data, unravelling trends from vast datasets and making them understandable for everyone.

Beyond the technical skills, my background as a geologist, drummer, and lighting specialist has fine-tuned my soft skills – problem-solving, communication, teamwork, and many more – all honed through diverse experiences that make me a well-rounded Data Analyst.

Remember to check out my personal projects in the section below!

SKILLS

Spreadsheet (Microsoft Excel, Google Sheets)
SQL
Python
R
Power BI
Tableau

KNOWLEDGE


web

Data analysis

The different phases of data analysis from asking effective questions for defining the problem, preparing/processing/analysing data, to sharing the results and key findings which helps in data-driven decision making

lightbulb

Analytical thinking

Identify and define problems in order to give recommendations by using data in an organized, step-by-step manner.

dynamic_form

Data manipulation

Data generating/capture, data cleaning, data management, data analysis, and data visualization.

speed

Design thinking and communication skill

Create visualizations and dashboards, present engaging data-driven stories.

RECENT PROJECTS


R web scraping analysis: Bicycle theft in the UK

R web scraping analysis:
Bicycle theft in the UK

View on Kaggle          View on Github          View on RPubs
Tool used: R
The aim of this project is to provide an overview of the bicycle thefts in the United Kingdom across the past three years (from 1st November 2019 to 31st October 2022), and to reveal any possible trend or pattern of the thefts and other insightful information.

Google Data Analytics Capstone Project: Bellabeat

Google Data Analytics
Capstone Project: Bellabeat

View on Kaggle          View on Github
Tools used: SQL (Google BigQuery), Tableau
The main objective of the project is to identify any possible trends in the fitness data from smart devices in order to provide recommendations for Bellabeat's (a company that manufactures health-focused smart products for women) marketing strategy to help reveal opportunities for the company's growth.

Small projects (just for fun :))

Small projects

View on Github
Tools used: Python, SQL (SQL Server)
Analysis on Microsoft's AdventureWorks2019 sample database.

View on Kaggle          View on Github
A simple Tic-Tac-Toe game in Python.

View on Kaggle          View on Github
The card game Blackjack (1 vs 1) in Python.

Visualisations

Visualisations projects

View on Github
Tool used: Power BI
Analysis on the public dataset Brazilian E-Commerce Public Dataset by olist about the sellers' performance. Identified insights and recommendations are shared to improve olist's revenue generated by their sellers.

digital_marketing

Digital Marketing

View on Github
Tools used: Python, Power BI
Digital marketing campaigns performance analysis of a fictional dataset which is provided by a client of a marketing agency. Analysis includes click-through rate, conversion rate, trends over time, month-over-month change, and performance in terms of the marketing funnel.

CONTACT


arrow_upward

Please feel free to contact

web counter