The Data School Blog
Web Scraping with Alteryx
We've learnt web scraping with Alteryx this month, and I found this skill very useful to get data on a website because data doesn't always come in table. And recently when I was searching for my next brunch destination, I saw Good Food Guide 2022: Top 50 Sydney cafes....
Customise Your Colour Legend in Tableau
Situation During the past week when working on our first client project, I encountered a colouring problem when building my dashboard. Specifically, the value I wanted to use for colouring the bars has a couple of extremely high values, so the whole viz was looking...
Installing libraries in Alteryx Python Tool
Alteryx provides an easy interface for python via the Python Tool. The Python Tool contains Jupyter Notebook with of cause Python which as limited number of preinstalled libraries: ayx: Alteryx API jupyter: Jupyter Metapackage matplotlib: Python Plotting Package...
Multiple selections for analytical apps
Analytical apps in Alteryx are useful for allowing the user to select the parameters which they need and grab snippets of the data. Here is a blog highlighting the uses of analytical apps. Here is how to make a list box with multiple selections. Step 1: Filter To...
Nested Sort in Tableau with Rank Table Calculation
Sorting the measures is an important step in building a vizualisation as it helps us digest the data on display quicker. Nested sorting is required when there is more than one dimension in the view. I’m using superstore data set for this exercise, I want to find the...
HTML to know for web scraping
Recently our team has learnt about web scraping using Alteryx. Alteryx allows us to send a URL of a webpage to download the HTML file sent back and then we can continue to parse this page out to get the data we need. There is a few things to know about how HTML works...
What did it take to get into DSAU12?
The quality of applications to get into the Data School Down Under is getting better and better! For each cohort, I will be compiling the submitted vizzes to show what it takes to get a spot in our program. Let’s take a look at DSAU12’s applications in this blog. For...
Museum of Modern Arts | Catalogue
For day three of dashboard week, we had a dataset from the Museum of Modern Art. I created a catalogue that helps to drill down bases on artists' nationality. You can see all artists united by this nationality. Then, choosing the artist name you can see his or her...
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...
Sentiment analysis of YouTube Videos
The second Dashboard of the Dashboard week at the Data School was based on the Kaggle dataset named "YouTube Trending Video Dataset". I am keen on Data Science and Machine Learning, so I decided to investigate this data set using sentiment analysis. Sentiment analysis...
Surviving Dashboard Week
A small blog on how to tackle Dashboard week at DSDU. Now that the Christmas vacations had been thoroughly 'vacationed', we were greeted by the much coveted 'Dashboard Week' (DW). The 3 syllables that has struck fears into the heart of every DS Cohort (At least the...
Dashboard Week Day 4: Boston 311 Service Requests
Last day of Dashboard Week!! Today, we only had 5 hours to build the dashboard, luckily we didn't need to use Alteryx. The data we were given was on 311 Service requests for Boston, one csv per year starting from 2014. This was a big data set. In Tableau, I unioned...