Neil Li
Neil graduated from the University of Melbourne with a Master’s degree in Information Technology. He started his career as Data Analyst in a Tech Company in China. Recently, Neil moved back to Australia and decided to join The Data School, kick-starting his career with Data Analytics in Down Under. He looks forward to learning cutting edge skills and meeting fellow data enthusiasts who share a similar passion for data. In his man cave, you will spot Neil enjoying his video games and reading. He steps out with his racquets to swing it for Tennis and Badminton. Want to put a smile on his face? Ask him about the Chinese Hot Pot!
Dashboard Week 5 – Iowa Liquor Sales
The Challenge Finally, the last day! Today's challenge is simple. We got one Iowa liquor sales dataset and another Iowa population dataset. And there was no limit except time. We've got only 5 hours before the presentation, and I also got some other errands to run, so...
Dashboard Week 4 – My Solar Power System
The Challenge We are almost there! The day 4 challenge is quite interesting. We got a bunch of datasets for solar systems, which varies from individual systems to power stations. The requirements are challenging because we need to add external data to our chosen...
Dashboard Week 3 – Sample Superstore
The Challenge The challenge of today is quite different from the previous ones. Today is the design challenge. Design is never my strength, but I have to admit that it is necessary for a good visualisation. Anyway, we need to choose a company logo and use it as the...
Dashboard Week 2 – London Energy Consumption
The Challenge Now we are on Day 2, the challenge of today is to create a dashboard using Smart Meters in London dataset. The whole dataset includes supplementary data including Acorn, holidays and weather. The Data Firstly, I compared the date range among...
Dashboard Week 1 – Let’s Go Boating!
The Challenge Day 1's challenge is to download data using NSW Transport Open Data API and build a dashboard. The Data I decided to use the NSW Boating Ramps API. Due to my network issue, my Alteryx didn't work well with the API. Fortunately, I can run the query...
Understanding Tableau’s Order of Operations
When we see some new tricks in Tableau, most of the time, the first question pop out of our mind is: how can I do it? However, sometimes, learning how is not enough. What if we face a similar situation in which the old tricks cannot apply directly? Sometimes, the...
A Quick Guide of How to Choose the Right Calculation: Table Calc or LOD?
Sometimes, choosing the right type of calculation for a given problem can be challenging in Tableau. In fact, there is a simple and quick way to make the proper decision. I'll start with a brief introduction of three types of calculations in Tableau. Basic...
Tableau Tips: How to Make a Curved Line Chart
Why curved line Let's look at a picture, which one do you prefer? I guess you will more likely pick the left one. In fact, scientific studies have shown that this affection for curves isn’t just a matter of personal taste; it’s hard-wired into the brain. Humans prefer...
What makes Alteryx so magical in data analysis?
In many cases, data integration/preparation is the most painful and time-consuming step in a data analysis process. The most commonly used tools, such as Excel, SQL, and Python/R, all have their limitations. Excel is the most widely used tool for data analysis. The...