Longyan Chen

Longyan graduated with a master’s degree in Business Systems Analysis and Design from the City, University of London. During her master's program, she encountered Tableau and the art of data visualisation. This leads her career into the world of data.

During her time at the Data School and the placement at PwC DA, she extensively used Tableau, Alteryx, and Power BI to work with client projects and trained the PwC employees focusing on data preparation and data visualisation.

When she is not immersed in data analysis, you'll find her practicing yoga, engaging in cardio workouts, and exploring diverse cuisines from around the world. She has a penchant for watching documentaries that offer insights into various cultures.  

Certifications:  

Certifications

Blog Posts

Avatar
Fri 30 Sep 2022 | Longyan Chen
Dashboard Week Day - 5
The dashboard task is not as complicated as previous days, which is nice:) The data I downloaded are from the internet boyband database gathered by Billboard.com Dataset for bands : https://github.com/the-pudding/data/blob/master/boybands/bands.csv Dataset for boys: https://github
Avatar
Thu 29 Sep 2022 | Longyan Chen
Dashboard Week-- Day 4
Today's task is to use API to download Characters, episodes, quotes, and deaths from every episode of Breaking Bad and Better Call Saul. Then build a dashboard about it. First I used Alteryx to download all information from API
Avatar
Wed 28 Sep 2022 | Longyan Chen
Dashboard week-- day 3
Today's task is to build an accessibility dashboard based on FixMyStreet Pothole data in Glasgow
Avatar
Tue 27 Sep 2022 | Longyan Chen
Dashboard Week Day-2
Task for today: Using Mockaroo to build a dataset and build a dashboard in Power BI. My data will include following elements: The following picture shows how it looks like within Mockaroo: After I have built the data, I sketched what I would like to include in my dashboard
Avatar
Mon 26 Sep 2022 | Longyan Chen
Dashboard Week --Day 1
Time Flies, I cannot imagine it is my last week of training now. Mixed feelings:) For today's task is a bit challenge as Alteryx app and API are not my strong suit. I spent a lot of time making Alteryx flow working
Avatar
Tue 30 Aug 2022 | Longyan Chen
How to Calculate Profit Ratio in Power BI?
Task: What's the overall profit ratio within Sample Superstore? First, go to Transform data in the top pane, then click Add Column on the pop up window. Then, click Custom Column, follow the calculated formula above then hit OK. The new column will appear in the table sheet
Avatar
Sat 27 Aug 2022 | Longyan Chen
How to Create a Stage Table and File Format on Snowflake?
Task: Create a stage table and a file format on Snowflake. First, log into the Snowflake website and then go to databases on the top left. Choose the database name. I have chose TIL_DATASCHOOL here. Then, go to Stages and click Create... A pop up window will guide you to AWS S3 and click next
Avatar
Sat 27 Aug 2022 | Longyan Chen
How to upload files on S3 AWS?
Requirement: Manually upload a file on to S3 bucket on Amazon Web Services. First, use your user name and password to log into the website https://til-internal-ds.signin.aws.amazon.com/console Then, go to S3 bucket and find a bucket name if it has been existed or you can create a bucket
Avatar
Thu 04 Aug 2022 | Longyan Chen
How to make Z-Score in Tableau
Requirement: Make the Z-Score to outliers of average price by room type. The solutions shows below: After this , please remember to right click Z-Score from the card and edit the table calculation
Avatar
Wed 03 Aug 2022 | Longyan Chen
How to Make a Quadrant Scatterplot
Requirement: For Customers in California, create a scatterplot of Quantity vs. Profit Ratio. Make it a quadrant chart. The upper right quadrant are customers in the top 200 for profit ratio and top 100 for quantity
Avatar
Thu 14 Jul 2022 | Longyan Chen
How to Make Line and Bar Chart in One Worksheet
How to build a worksheet with either line or bar chart by choosing different chart type?
Avatar
Mon 11 Jul 2022 | Longyan Chen
How to make a dynamic sorting APP?
We did Macro and APP for today's training and I am going to make a dynamic sorting APP for one of the exercises we had earlier. The task is to read in the file and sort the file by numeric and date field dynamically in the dropdown
Avatar
Wed 06 Jul 2022 | Longyan Chen
How to Make Airline Routes?
Let's say we want to build Airline Routes for the airports in the US. After connecting the Air routes data to Tableau, first, I would like to see where those origin and destination airports are in the map. So I need to create two calculated fields, Origin and Destination
Avatar
Tue 05 Jul 2022 | Longyan Chen
How to use parameter action to drill down?
I would like to build bar chart with a drill down in category and let users to change a parameter value through direct interaction with my Viz by clicking different categories and explore more detail information in sub-category
Avatar
Thu 30 Jun 2022 | Longyan Chen
Regex Day
Today's training was about Regex and this was the first time I have heard about Regex. What is Regex? Regex is short for regular expression, a regex is a string of text that allows you to create patterns that help match, parse, and manage text. We used Regex in Alteryx and did some exercises
Avatar
Sun 19 Jun 2022 | Longyan Chen
How to Build Reference Line Parameter Action
I have shown how to build reference line parameter action step by step.
Avatar
Fri 17 Jun 2022 | Longyan Chen
Notes for Week 2 training
What is the difference between discrete and continuous data in Tableau?
Avatar
Thu 16 Jun 2022 | Longyan Chen
How to Make Dynamic Heatmap
Questions: How to build a dynamic heatmap by using date level parameters such as, Year, Quarter, Month, and Weekday? Answer: Create two parameters for the Column and Row on the worksheet
Avatar
Fri 10 Jun 2022 | Longyan Chen
First week project
Time flies, the first week is done now. It has been a stressful and fulfilled five days. For the past week, we mainly focused on Alteryx and Tableau prep. Today we had our first week project
Avatar
Mon 06 Jun 2022 | Longyan Chen
The journey to The Data School
Some resources that I used to get into The Data School.
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