Stanley Chan

Meet Stanley, a dynamic and versatile professional with a passion for data analysis. With a Bachelor's degree in Biology from the University of Hong Kong and a Research Master from UCL, he brings a unique perspective to the world of data.

Prior to joining The Information Lab (TIL), Stanley worked as a marine biologist and gained valuable critical thinking and problem-solving skills from Academia. He now boasts an impressive range of data analysis skills, including:

  • Automation & Data transformation
  • Data Query (SQL) & Warehousing
  • API connection
  • Web scraping
  • Cloud usage
  • Statistically testing, ML , forecasting & optimization
  • Dashboarding

As a highly technical person, Stanley has adapted to various industry-recognized software, including Alteryx, Tableau, Power BI, python, R, Snowflake, DBT and AWS.

Apart from technical side, Stanley has acquired valuable skills in agile project management, team collaboration, and concise insight delivery through his previous work in various science, charity, and financial sector projects. His warm and easy-going attitude makes him an ideal team player, and his technical expertise makes him a valuable asset to any organization. Apart from work, Stanley is passionate on microscopy, Jujitsu and wildlife exploration.

In addition to his work experience, he has obtained well-recognized certifications, demonstrating his dedication to continuous learning and professional development:

Certifications

Blog Posts

Avatar
Fri 31 Mar 2023 | Stanley Chan
Dashboard week day 5 - Sleep Quality Survey
Last day of the dashboard week! I am very happy to announce that I made it! Today task is visualize the data from Sleep Efficiency Dataset (https://www.kaggle.com/datasets/equilibriumm/sleep-efficiency) in 3.5 hours
Avatar
Thu 30 Mar 2023 | Stanley Chan
Dashboard week day 4 - Citizen service requests
Today is dashboard week day 4. The data was taken from Season 2's Real World Fake Data (#RWFD; https://exchange.tableau.com/en-gb/products/621)
Avatar
Wed 29 Mar 2023 | Stanley Chan
Dashboard week day3 - Power Bi with web scraping
Today we need to solely use Power BI and scrap the basketball statistics from https://www.basketball-reference.com. We need to extract the data from each year
Avatar
Tue 28 Mar 2023 | Stanley Chan
Dashboard week day 2 - cat tracker
Today is the day 2 of the dashboard week. Today my teammate and me need to visualize a dataset about the cat movement tracker. When I received this data, I am not so sure how to deal with it. I have spent a long time looking through the whole documentation
Avatar
Mon 27 Mar 2023 | Stanley Chan
Dashboard week day 1 - Accessibility (keyboard-only users)
When we design dashboard, our ultimate goal is to make it easier to use in order to deliver the information and insight to users. It is important to make sure that these visualizations are accessible to most of the people. However, not everyone can use the dashboard in a same way
Avatar
Tue 07 Mar 2023 | Stanley Chan
Personal Advice of Web Scraping in Alteryx
Web Scraping means to extract the information from the webpage. In Alteryx, we can easily extract the HTML information from a webpage . However, I found that the downstream procedure is what makes it difficult. Here is what I think being important to know or consider
Avatar
Thu 09 Feb 2023 | Stanley Chan
What is Z-score and how do we use it?
To understand what Z-score does, we need to first understand some basic statistic knowledge - normal distribution and standard score
Avatar
Wed 25 Jan 2023 | Stanley Chan
Recursive Indexing Using Multi-Row Tool in Alteryx
Here is just a very quick tip on recursive Indexing by using a multi-row tool. Let's say you have some data which measure order is "Name>Gender>Age>Name>Gender>...". In order to do some pivoting you need to identify what the measures are
Avatar
Thu 05 Jan 2023 | Stanley Chan
Drilling down to data points by clicking category in Tableau
Today I would like to share how to make the chart below, where you can click the category (here is the region) to drill down all the data points in that selected category. 1. Put Region on columns and average Sales on rows 2. Create a Parameter that will be changed by our action
Avatar
Wed 04 Jan 2023 | Stanley Chan
Specific Dimensions in Table Calculation in Tableau
This blog is for those who have a basic understanding of table calculation. Very often when we use the table calculation with specific dimensions. It is sometimes quite confusing how the calculation is computed
Avatar
Thu 29 Dec 2022 | Stanley Chan
Add a label above every horizontal bar in Tableau
Hi, today I would like to share a trick I learned, which is to add a label above every horizontal bar in Tableau. Let's use the superstore data to create a basic bar chart, with sum of profit on columns shelf and region in the rows shelf. The next is to create a dummy row above each bar
Avatar
Tue 27 Dec 2022 | Stanley Chan
XML parse tool in Alteryx
 In the previous blog, I discussed what XML is and its basic structure. Today I am going to talk about how to use the XML parse tool to put the information wrapped by specific tags into columns. Please make sure you are familiar with the terminology like root, child and XML tree
Avatar
Fri 23 Dec 2022 | Stanley Chan
Introduction of XML
Yesterday I was doing Alteryx weekly challenge #37, which required me to parse the XML formatted text. Obviously, it demands the usage of the XML parse tool, which I have never tried before! Good chance to learn it
Avatar
Tue 20 Dec 2022 | Stanley Chan
Find Replace tool in Alteryx
Find Replace is a tool for matching the value in the target table using a lookup table. Don't fool by its name, 'find and replace' isn't its only function. It has two use cases
Avatar
Fri 16 Dec 2022 | Stanley Chan
Redesign my application viz to DS
In the last blog, I discussed how my failed application viz to DS was terrible. Today I have redesigned it in a more pleasant way! The link to the redesigned viz is here: https://public.tableau.com/app/profile/stanleykinnok
Avatar
Thu 15 Dec 2022 | Stanley Chan
How to change table orientation in Alteryx (2 mins reading)
 This blog is about changing table orientation (or say rotating the table), which I just learn in doing the Alteryx weekly challenge. In excel, we can copy the range of the table and then right-click and select paste with 'transpose'.  In Alteryx, there is no single tool to do this task
Avatar
Wed 14 Dec 2022 | Stanley Chan
Tableau - Dynamic axis using parameter
When making charts for dashboards, very often we analysts have decided which measures be to the x/y axis
Avatar
Tue 13 Dec 2022 | Stanley Chan
A self-reflection on my failed application viz
Hi, I am Stanley, a new guy getting into the Data School as a member of cohort 37. In a blink of time, I have gone through my first week in Data School. I feel Data School is a place where you can learn state-of-the-art data techniques
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab