Thao Tran
Thao is an experienced 3PL Warehouse Administrator and Retail Assistant Manager. Driven by a passion for data analytics and information technology, she takes pride in providing the best analysis to help businesses in making data driven decisions and tackling their issues. As a Data Analyst Consultant at The Data School, her goals include learning from the best people in the data industry and up skilling herself with relevant and powerful tools like Tableau, Alteryx, Power BI, etc.
She adores applying process automation to improve her productivity and efficiency at work. When Thao is not keeping busy with data, you can find her enjoying collecting Pandora charms and baking chocolate mint cookies. She also loves dining out and a meal that never fails her is spicy Pad Thai paired with a Vodka Sunrise!
BBL – Dashboard Week Day 4
Okay it is the last day of dashboard week, let's go straight in. THE DATA For Day 4 of the dashboard week, we were given the Big Bash League, Australia Cricket Data set. We have shorter time span for today topic, we needed to present the dashboard at 3pm, so I only...
Victoria Census Data – Dashboard Week Day 3
Hello, I’m back with Dashboard week - Day 3 Challenge: Victoria Census Data Requirement: Build a dashboard from the provided dataset Victoria | Region summary | Data by region | Australian Bureau of Statistics (abs.gov.au) Be specific with a chosen topic and we could...
The Next Cafe – Dashboard Week Day 2
Hello, I’m back with Dashboard week - Day 2’s blog. The data for Day 2 is Melbourne City Council Data guys and girls! We were given a task to solve the business question of where to open a new café in Melbourne City? The main data set for this challenge is Café,...
The MealDB Cookbook – Dashboard Week Day 1
Hello! Welcome to my dashboard week blogs. Today is the first project of all, we were given the task of building an Alteryx workflow to download data from the MealDB API, and use the downloaded data to create a dashboard. This is a fun project as all the meals look so...
WHAT IS SQL CTE?
WHAT IS CTE? CTE is short for Common Table Expression. It is a temporary result set, which is used as a sub query for a main query (SELECT, INSERT, UPDATE or DELETE). CTEs are used for better readability and organization of SQL queries. Main steps: Assign a name to a...
How to Personalize your Alteryx Canvas
Hello! I am so excited to share with you this blog: How to Personalize your Alteryx Canvas! It is getting very close to Christmas , and I am thinking why not giving my Alteryx workflow a festive make-over? Believe it or not there are options in Alteryx to allow you to...
Retro Arcade Game in Alteryx
Woo Hoo! Time for some arcade game in Alteryx! Did you know that there are retro arcade games built and hidden in Alteryx? Building workflows can be exhausting sometimes. You could take a break and play some arcade games instead. To access the games: First click on...
Alteryx Pro Tip – Remove Multiple Duplicate Fields from the Join Tool
If you have been using Alteryx for a while and have used the Join tool, I am quite confident that you have come across this scenario a few times. When you join two data sets using specific fields that have identical field names, you will have duplicate values from the...
Using Scatter plot to explore relationship between measures
Scatter plot displays lots of data points at once yet still enable you to quickly identify clusters, correlations, trends, outliers. You can use scatter plot to identify and explore relationships between 2 measures. Firstly, we add 2 measures on opposite axis (row and...
Why doesn’t Tableau filter work for me? Context Filter explained!
Have you ever been frustrated by getting unwanted result from Tableau filters? Count me in and follow me along as you may not know about Context Filter. Dataset used in this blog: (you can download and explore it by yourself too)...