Sijia Wei

Sijia has a background in Behavioural and Experimental Economics, she joined the Data School after completing a PhD degree at Durham University. Data visualisation to her is both an art and science, it’s amazing how effectively it makes complex data more accessible. Sijia’s passionate about working with data and providing data-driven insights into human perception which enables confident strategic decision-making.

She’s been so impressed with the eye-catching dashboards Tableau creates, it is the best tool to show potential connections and to assist digital storytelling. Outside work, Sijia plays a beautiful Chinese musical instrument, she also does photo shoot for bloggers, and enjoys spending her time in kitchen cooking and making cocktails with friends.

Blog Posts

Avatar
Wed 20 May 2020 | Sijia Wei
How to create Step Area Charts in Tableau?
A step area chart tells you the increase and decrease of sales compared to the previous months. For each month, the step line connects the previous sales with the current
Avatar
Tue 12 May 2020 | Sijia Wei
Alteryx Tool - Make Columns
We did predictive tools in training today with Gwilym and Bene. Instead of pivoting and joining the table we attached a Make Columns tool after the K Nearest Neighbours analysis to tidy up the data. The tool takes rows of data and arranges them into multiple columns
Avatar
Sun 10 May 2020 | Sijia Wei
Exploring the ‘show only relevant values’ option
The problem: We were working on National Student Survey data last week, most of us had filters for ‘University Group’, ‘University Name’, and ‘Subject’
Avatar
Thu 07 May 2020 | Sijia Wei
Alteryx Server Beginner - How to publish an Alteryx analytical app with macro to the Gallery?
Thanks Ben and Jonathan for explaining this to me a few weeks ago. Hope this is helpful to those who are also new to the server. You can skip the first two steps if you are just publishing a workflow with macro
Avatar
Thu 23 Apr 2020 | Sijia Wei
Correlation Matrix in Tableau – How do you hide the symmetric half?
Brian in DS12 wrote a great blog post on how to make a correlation matrix in Tableau. It is a very useful chart type, and it is really cool that the cells in the matrix can be used as filters for the scatter plot of the two comparing categories
Avatar
Wed 22 Apr 2020 | Sijia Wei
Tableau Tips – How do you change the font for everything on your dashboard in one click?
I was exploring cool fonts in Tableau, well, it is a good effort to select and change each title, filter, colour legend, etc. one by one. Luckily, there is a quick way of doing that
Avatar
Tue 21 Apr 2020 | Sijia Wei
How do you import data from folders within folders within folders… - The Directory Tool in Alteryx
Avatar
Mon 20 Apr 2020 | Sijia Wei
Comparing Two or Three Categories in Tableau
I quite like this chart type we did with Andy, he calls it ‘Peas in a Pod’. I like the way it looks, and it works very effectively when comparing between categories, eg. Gender, Party, etc
Avatar
Thu 02 Apr 2020 | Sijia Wei
Tableau Show/Hide Button
This week we are working on survey data for a client project. We have a fairly long list of filters to include in the viz for the demographic information that has been collected in the survey. A show/hide button enables us to provide a much cleaner view on the final dashboards
Avatar
Mon 23 Mar 2020 | Sijia Wei
Tableau Set Actions Refresher
Basically, it is a bar chart that drills down when you click on it. We’ve used it a lot in our last client project, it worked quite well for everyone. Let’s go straight to the topic
Avatar
Sun 08 Mar 2020 | Sijia Wei
Annual Calendar in Tableau - 4. Two Colours for Two Different Fields
Avatar
Sun 08 Mar 2020 | Sijia Wei
Annual Calendar in Tableau – 3. Dynamic Calendar & Default Week Start
Sometimes the space on the dashboard is limited, let’s see how do we make a 12-week dynamic Calendar. Step 1: Create a Date Parameter for users to select the start date on the calendar Step 2: Define a Start Date on the calendar (e.g
Avatar
Sat 07 Mar 2020 | Sijia Wei
Annual Calendar in Tableau – 2. Filling in the Gaps
There are two ways to fill in the gaps on the calendar. One, we can add the missing dates in the dataset, but there is something else we can do without touching the data. Step 1: Start a new worksheet for a ‘Background Calendar’, create a calculated field using the ‘MakeDate’ function
Avatar
Sat 07 Mar 2020 | Sijia Wei
Annual Calendar in Tableau - 1. Creating the Framework
Thanks Andy for giving me the challenge to complete the #WorkoutWednesday week44. I’ll explain how to make annual calendars in Tableau using the Superstore Data
Avatar
Sun 16 Feb 2020 | Sijia Wei
Text to Column - - - Just Smart Enough
One thing Carl spotted from my first Friday’s presentation was that the ‘Text to Column’ tool can be used to split the text entry in one column into multiples based on multiple delimiters
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