by Camille Shi | May 13, 2022 | Camille Shi
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...
by Camille Shi | Jan 9, 2022 | Camille Shi
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...
by Camille Shi | Jan 7, 2022 | Camille Shi
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...
by Camille Shi | Jan 7, 2022 | Camille Shi
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...
by Camille Shi | Jan 5, 2022 | Camille Shi
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...
by Camille Shi | Jan 3, 2022 | Camille Shi
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...
