Sijia Wei

Sijia Wei

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.

How to create Step Area Charts in Tableau?

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. Step 1: You need a calculated field for the sum of sales of the current month Step 2: You need a...

Alteryx Tool – Make Columns

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....

Exploring the ‘show only relevant values’ option

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’. The Subject filter has a very long list, the users could get confused if they were to click on one of those courses...

Comparing Two or Three Categories in Tableau

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. Step1: Put Dimensions and Measures on Columns and Rows, Category on Colour...

Tableau Show/Hide Button

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...

Tableau Set Actions Refresher

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. Put Category and Subcategory on rows, Step1: Create a Set from Category Step2: Create...

Annual Calendar in Tableau – 2. Filling in the Gaps

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...

Annual Calendar in Tableau – 1. Creating the Framework

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. Step 1: Decide what you want in Columns and Rows Columns: Number of Months within a Quarter >>...

Text to Column – – – Just Smart Enough

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. For example, we want to split: into: The ‘Text to Column’ tool actually allows...