Camille Shi
Camille always be passionate about visualising data and she studied Big Data and Business Analytics for her master degree in University of Sydney. Camille considered the Data School as an ideal place to start her career as she can gain some technical skills related to data and consulting skills there . She hopes to learn various approaches to bring out insights and interesting stories from raw data.
Outside of work, Camille loves to watch thrilling football games or go for a refreshing swim in summer, and she’s a big fan of Messi. Her favourite food is the Chinese hot pot and could easily have it as the only meal for the rest of her life!
Showing Values for Overlapping Time Ranges in a Table
To view the business performance, especially the financial numbers, sometimes people need to see the numbers for some overlapping periods, like the Last 6 Months, Last 1 Year, and Total Period to Date so that users can compare the performance over these periods. See...
Build a calendar in Tableau
Have you considered if a calendar can be used as a chart in Tableau? The answer is Yes! But the Calendar is actually a heat map that uses colours to show the value of each day. For example, the following chart shows the daily profit in different months by using a...
Dashboard week – Day 4 BOS: 311 Non-Emergency Cases in Boston
Finally, we get to the final day of Dashboard week! Today we are given data from BOS: 311, which is an agency to handle non-emergency cases. The data is clean, I used data from 2011 to 2020 and input them into Alteryx and I got the year from the file name. Here is my...
Dashboard week – Day 2 Youtube Trending Videos
Yes, it's the second day of dashboard week! Today we are given data about Trending videos on Youtube. The data was quite clean so the Alteryx workflow is simple, as shown below: I used a wildcard to input all the datasets and output filename so that I could get the...
Dashboard week – Day 1 Ice and Fire
The first challenge of dashboard week is about a popular TV series Ice and Fire. We need to use API to get the data and then visualize the data. Let's take a look at how to do it! In Ateryx In order to get most data, I downloaded data from API - The Books firstly and...
Bar in Bar Chart and Reference Line (Part 2)
We've finished building the bar in the chart in Part1 Blog. Now we're going to add two reference lines to the chart. One shows the average sales in 2018 and another one shows average sales in 2019. Step 1: Click Analysis on the left and Drag Reference Line to Table....
Bar in Bar Chart and Reference Line (Part 1)
Bar in Bar chart is very useful for comparing values, which is intuitive. Reference Line is commonly used to show a standard that can show if the value above the standard or not. The following chart shows the sales of different sub-categories in 2018 and 2019 using a...
How to do dynamically group in Tableau?
It is easy to create a "Group" of a dimension in Tableau, but how to make this process dynamic? For instance, you have a dimension called "States" that includes different states' names and another dimension "Sales" showing the sales of each state. And you create a bar...
Standard Macro, Batch Macro, Iterative Macro
What is an Alteryx Macro? Alteryx Macro is a workflow or a group of tools built into a single tool that can be inserted into another workflow, which is essential when you repeat an analytics process several times. There are 4 types of Macros including Standard Macro,...
Build a Football Field with Tableau
Every Tableau user should be familiar with mapping. But do you know that you can create a customized background to visualize the data by mapping? Let's see how to build a football field in Tableau! There is something that should be prepared before the creation starts,...