2 days agoFull Beginner Data Analyst Project in TableauAnother super detailed follow-along project in Tableau with the awesome YouTuber — Alex the Analyst! Hi everyone, my name is Yuen :) For today’s article, I would like to do another follow-along project in Tableau with Alex the Analyst, here’s the link to his YouTube tutorial: Full Beginner Project in…Tableau6 min readTableau6 min read
Nov 19Data Analyst Project Part II — Exploratory Data Analysis in RIn this article, we will perform some EDA on the fitness/pilates related data we extracted from YouTube API in part I. Hello everyone, my name is Yuen :) Welcome to the part II of my DA project!! In part I, I demonstrated a step-by-step process of extracting fitness/pilates data using…Data Analysis8 min readData Analysis8 min read
Nov 5Data Analyst Project Part I — YouTube API Data Extraction (in R)Extract a selection of 8 most popular fitness/Pilates YouTuber’s data for further analysis. Hello everyone, my name is Yuen :) Little background story: 2022 is a revolutionary year for me — I have discovered a new passion in Pilates :)) After spending hours practicing and analyzing online datasets I don’t…Data Analysis6 min readData Analysis6 min read
Oct 1Practice SQL Interview Questions on StrataScratchsharing SQL learning resources and experience of using StrataScratch Hi everyone, my name is Yuen :) Today I would like to share some of my favorite’s SQL learning resources & platforms to prepare for SQL interview questions! I’ve had some professional experience in SQL and database management, but I haven’t…Towards Data Science3 min readTowards Data Science3 min read
Sep 23No More Pain When Importing CSV Into BigQueryI spent two days working on this issue, trust me, you wanna read this Hi everyone, my name is Yuen :) Have you run into one of the following errors when importing CSV files into BigQuery? I’m sure I’m not the only one hehe, please read along~Towards Data Science2 min readTowards Data Science2 min read
Sep 20Data Analyst Portfolio Project Part II: Tableau Data VisualizationsFollow-along portfolio project (part 2) from Alex the Analyst on Youtube. Dashboard with 4 different kinds of visualizations on worldwide covid tracking dataset. Hello everyone, my name is Yuen :) Today I’m going to do a follow-along Tableau portfolio project from the YouTuber Alex the Analyst. I enjoy watching his…Tableau7 min readTableau7 min read
Sep 20Hong Kong FoodPanda Interview Questionssharing FoodPanda Data Analyst interview questions for anyone’s inference! Hi everyone, my name is Yuen :) Currently I’m working on my portfolio projects and actively applying for Data/Business Analyst positions in Hong Kong. I applied for FoodPanda’s Data and Insights Analyst position and received an email from them to complete…Interview3 min readInterview3 min read
Sep 19Data Analyst Portfolio Project Part I: SQL Data ExplorationFollow-along portfolio project (part 1) from Alex the Analyst on Youtube. Basic SQL queries on worldwide covid tracking dataset. Hello everyone, my name is Yuen :) Today I’m going to do a follow-along SQL portfolio project from the YouTuber Alex the Analyst. This part one project performs some data exploration…Towards Data Science5 min readTowards Data Science5 min read
