Binbin Chen
Binbin came to Australia in 2011 and completed his bachelor’s degree in mechanical engineering at Monash University. He then pursued a PhD degree and worked as a part-time teaching associate at Monash University during the period.
When working on research projects involving human eye movements, he had the opportunity to analyse clinical data and seek insights from it. That’s where he discovered his passion for data.
With the logical thinking and engineering skills he acquired from his academic background and the data analysis tools and skills he learned in the Data School, he can wrangle data effectively and provide valuable insights.
Outside of work, Binbin enjoys watching historical videos. He is also an anime fan!
Three steps to build a Tableau viz based on a template
Have you ever wanted to build a fancy chart in Tableau but don’t know how to start? In this case, using a template is a good starting point. Here, I want to share three simple steps to build your chart based on a template. Structure your data in the same format that...
Dashboard Week – Day 5: How did BASIX certified single dwellings use rainwater?
Finally, the last challenge of Dashboard Week!! Today we have less time to complete the dashboard and blog because we need to present at 3 pm. We were given the BASIX certificate data for single dwellings from 2011-12 to 2018-19. Data wrangling: The data is very...
Dashboard Week – Day 4: Web scraping and Tableau server
Web scraping! This is the challenge we were given on day 4 of the dashboard week. The website we need to scraping is the CWUR world university rankings page. Our target is the table in the webpage, and we need to use the table to build a dashboard purely on the...
Dashboard Week – Day 3: Cryptocurrency volatility
Today is day 3 of the dashboard week. We are halfway through!! The challenge assigned to us this morning was the API challenge. We need to download the cryptocurrency data from the Coinpaprika API and, as always, build a tableau dashboard. The dashboard I built Today...
Dashboard Week – Day 2: World Bank Projects and GDP
On day 2 of the dashboard week, we were given World Bank FMIS Projects data to build a dashboard. The data is well-formatted in excel for humans to consume, but it's a nightmare to be used in tableau and Alteryx. I would love to sit down and find a technical solution...
Dashboard Week – Day 1: If it wasn’t for COVID, was it a good decision to open a pub in Melbourne in 2019?
This week we welcome our early dashboard week due to the change of schedule. On the first day, we are asked to choose a topic and build a dashboard based on the Melbourne city Census of Land Use and Employment (CLUE) data. Seeing that the latest data is taken from...
Alteryx: issues and tips when using dynamic select in batch macros
When building batch macros, you may want to use the dynamic select tool to adjust input columns. Here, I want to share some issues you may come across when doing this and the tips to address these issues. Issue 1, indeterminable column name Suppose we are building the...
Build candlestick chart in Tableau II: adjustable interval
Source: QuoteInspector.com In the previous blog, I demonstrated how to build a candlestick chart with a fixed interval in Tableau. In this blog, I will demonstrate how to build a candlestick chart with adjustable intervals. My method requires a column that indexes...
Build candlestick chart in Tableau I: fixed interval
Previously, I introduced in my blog how to download stock market data from the Yahoo Finance API. This time I want to use the download data to build a candlestick chart in Tableau. I will use the SPY ETF data I downloaded in the previous blog to build the chart. In...
Use Alteryx to download stock market data via Yahoo Finance API
If you invest in the stock market, you may be interested in obtaining market data for further analysis. Here I want to share how to use Alteryx to download stock market data from Yahoo Finance API. There are several stock-market APIs available. If you decide to try a...