Pak Wai Chow - Portfolio Projects

About

Hi, I am Pak Wai Chow and you can also call me Owen. I am a graduate student who studied MSc Management at University of Bath and BSc Chemistry at UCL. This repository serves to showcase my skills and as a platform to share my projects.

Table of contents

• About
• Portfolio Projects
• Contacts

Portfolio Projects

In this section I will list the portfolio projects briefly describing the software used to solve cases.

Netflix Content Exploratory Data Analysis

Code:Link
Presentation:Tableau Public
Description: Dataset containing data of the TV shows and Movies on Netflix is collected from Kaggle. This project includes the following steps: utilising SQL for data cleaning and exploration data analysis, and Tableau Public for visulisations. Insights are created and included in the visulisations.
Skills: Data cleaning, Data Analysis, Data visulisations
Software: SQL, Tableau

SQL Data Cleaning Portfolio Project(New York Airbnb Data)

Code: Link
Description: Data was collected from Kaggle containing New York Airbnb Open Data. The dataset was created for data cleaning and learning purpose. This project includes cleaning the data, such as removing special characters, and transforming the data, such as converting the data type. Cleaning the data allow further exploration on the data and creating visulisations.
Skills: Data cleaning, Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Converting Data Types, User-Defined Functions
Software: SQL

London Airbnb Visulisations Portfolio Project 2023

Presentation:Tableau Public
Description: Data was collected from Inside Airbnb for London, England, United Kingdom. Visulisations was made to provide insights on the London Airbnb market.
Skills: Data Visulisations, Dashboards, Worksheets, Data Analysis
Software: Tableau Public

Contacts

• E-mail: pw.chow.12@gmail.com
• Linkedin: Pak Wai Chow