Neal Wang

Neal graduated from the University of New South Wales with a double degree in Commerce and Science. Following an honours degree in Mining Engineering, he entered the world of geological data and attracted by the beauty of data visualisation. Data School down under inspired him to pursue a career in data analytics and made it real. He is a super fan of DOTA, a game which he has played for more than 10 years and you will feel his passion in snowboarding during winter.

Dashboard Week Day 2

Welcome to Dashboard Week Day 2. Today our challenge is sports data, an American Baseball DataSet. Sean Lahman has been contributing to building a comprehensive database for Baseball and nowadays, cutting edge technology was also introduced to baseball to collect more...

Dashboard Week Day 1: Donor VS Recipient

This week is Dashboard week and today is day 1. We are given a big dataset called Aiddata Core Research which represents the most comprehensive project-level data tracking international development finance. The base of the Research Release is all core data exported...

Iterative Macro – Part 1 Iteration Concept

Iterative Macro Part 1 - Iteration Concept 1.Iterative Marco Definition An Iterative Macro will run through every record and then loop the records back through the workflow, repeating the entire process as many times as is specified, or until a condition is met.​s 2....

How to understand the process of creating a macro?

How to understand the process of building a macro? When I first learn macro, my biggest challenge is understanding the principle of macro. I knew that the aim of macro is to generalise a workflow so that it can work on any input as long as the input matches the input...

Alteryx Macro Input Tool

Alteryx Macro is a tool which isolates an Alteryx workflow and packs in one tool. By definition, a Macro Workflow is a workflow that has the flexibility to be run as a single tool within another workflow. Macros save with an *.yxmc extension. Macro Input In a normal...

Download tool with Google Geocoding API

Downloading data from download tool via API is similar to ordering a Macdonald's meal via Uber Eats. Step 1: Choose your store : URL The URL of an API tells download tool which website do you choose for downloading your data. Take google geocoding as an example, its...

How to prepare your DS interviews?

This is my first blog after becoming a member of Data School Australia Big Family and I would like to share some of experience and thinking during my preparation. I created a flow chart to outline the whole process and answered some of the most challenging questions...