The Data School Blog

Web Scraping with Alteryx

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....

read more
Customise Your Colour Legend in Tableau

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...

read more
Installing libraries in Alteryx Python Tool

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...

read more
Multiple selections for analytical apps

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...

read more
Nested Sort in Tableau with Rank Table Calculation

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...

read more
HTML to know for web scraping

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...

read more
What did it take to get into DSAU12?

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...

read more
Museum of Modern Arts | Catalogue

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...

read more
Build a calendar in Tableau

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...

read more
Sentiment analysis of YouTube Videos

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...

read more
Surviving Dashboard Week

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...

read more
Dashboard Week Day 4: Boston 311 Service Requests

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...

read more