Unrelated captions to main picture, it just proves my love of HIKING.

▪ Computer Skills: Python, SQL, BigQuery, Excel, VBA, Google Data Studio, Cloud Dataprep

▪ Marketing Channels: Google SSC, Google ADs, SEO, Google Tag Manage (GTM)

During my university years, I majored in International Business and the department offered fewer courses related to data analysis, so to expand my interest in learning about data, I took different types of programming courses in winter and summer or elective modules at Soochow University.

SQL With Basic Syntaxes

Learning Period:

2023/03

Certificate Validity:

Forever

Tutorial:

Creating programming environment with SQLiteStudio and practicing how to insert, update, delete and integrate data with complex database.

• Movie data / IMDB website
• Player and team data / NBA website
• Covid19 data
• Election data / the National Election Committee.

Basic Syntaxes includes CASE, JOIN, WHERE, GROUP BY, HAVING, UNION, ORDER BY, LIMIT, universal functions(LENGTH, SUBSTR, STRFTIME …), aggregate functions(AVG, COUNT,SUM …), CREATE TABLE, DROP TABLE …

BigQuery

Learning Period:

2023/02

Certificate Validity:

Forever

Tutorial:

Creating programming environment with Google Cloud BigQuery

• Query and draw insight from BigQuery public datasets.
• Write and troubleshoot SQL on a real Google Analytics e-commerce dataset to drive marketing insights.
• Assess the quality of a dataset and develop an automated data cleansing pipeline that will output to BigQuery.

Excel function and big data VBA automation

Learning Period:

2020/09-2021/06

Score:

82 (2 credits)

Tutorial:

Creating marketing environment with offline excel

• Concepts of VBA variables, constants, functions and logic.
• Five types of custom functions: Text and data functions, logic functions, Date and time functions, Mathematics and trigonometry and Inspect and reference functions.
• Combination of EXCEL and database or use EXCEL as a database.

Google Analytics 3

Learning Period:

2020/02

Certificate Validity:

Forever

Tutorial:

Creating marketing environment with GA3

• Getting started eith establishing test website and adding tracking code to the webpage.
• Basic concept and statistical report, such as Event, Page View,Session, Engagement Rate, Demographics report, Acquisition report.
• Tracking customised event code and the effectiveness of advertising campaigns and customizing traffic sources.

Python

Learning Period:

2019/02

Certificate Validity:

Forever

Tutorial:

Creating programming environment with Jupyter Notebook , Python 3.x

• What is Variables, Operations and Statements
• Exercise and application: Input and output, Data structures and Program modules
• Special Topic: Application of Python and Data Science