Tony Tan
Tony earned his Bachelor’s degree in Advertising and furthered his education at the University of New South Wales, obtaining a Master degree in Business Analytics & Enterprise Systems. His academic pursuits kindled a deep passion for data analytics, leading him to The Data School for an intensive exploration into the world of data.
Tony has amassed data analytic experience across a spectrum of industries including communication, property management, finance, and charity.
Beyond his proficiency in Tableau, Power BI, and Alteryx, Tony is adept in SQL, Python, and SAS.
Bar chart with customized shape
Boring with creating normal bar charts? A bar chart with a customized shape could be an option. If you want to create a bar chart with a customized shape, the first step is to determine the color of your dashboard background. In this example, I choose the color as...
Using DAX to alter context filter in Power BI- Part2
As mentioned in the last blog, to allow users to add new dimensions to the table without adding the context filter to the measure, we can use ALLEXCEPT function. To summarize our requirement now, we want the measure we created to be only filtered by the state no...
Using DAX to alter context filter in Power BI- Part1
This blog will explain how we can use the context filter function in Power BI. The DAX statements used in this blog are ALL, ALLEXCEPT and ALLSELECTED. The dataset applied in this blog is Sample Superstore which you can be easily found in the tableau repository....
Dashboard Week Day3- Pick up your favorite Brewdog Beer!
It comes to the Day 3 of the Dashboard Week. Today, I created an exploratory dashboard that enables users to pick up their favorite Brewdog Beer. At the very top of the dashboard, you will see four metrics that show the average value of different Brewdog beers like...
Dashboard Week Day4- Global Trade of Endangered species
In Day 4 Dashboard Week, we were given a dataset of endangered animal. I created a dashboard called global trade of endangered animal. To build this dashboard, I integrated the data from https://trade.cites.org/ which contains the global trade of endangered animal. At...
Create flight route map in tableau- Part 1 Basic spatial calculation
This article will show some basic spatial calculations of creating a flight route map in tableau. The dataset used as demonstration contains the following fields. This map is basically to show all the routes from the same original airports. Before creating the...
Power Bi Bookmark application- part1 Set up a help page with bookmark
Bookmark is an embedded function in Power bi. It could help us achieve better visualisation practice by combining with Button function. This article will introduce one of the applications of bookmark in Power bi. Help information page is to help users to better...
Create flight route map in tableau- Part 2 Buffer calculation and application
From the last blog, we learned how to create the basic spatial calculation and create multi-layer map visualisation. This blog will show how to add buffer to the original airport and highlight the route within the buffer. Step1: Create the parameter to control the...
How to create radial bar chart in Tableau
Radial bar chart could be quite useful and impressive when you want to present the change in time series data. This blog will show how to make Radial bar chart from scratch. The dataset used in this blog is Sample Superstore dataset which is embedded in Tableau...
Create dynamic Pareto chart in tableau
Pareto chart has been frequently used to find the most significant cause of a problem or achievement in business. This article will demonstrate how to create pareto chart in Tableau. The follow dataset- EU-Superstore will be used to create a pareto chart which can...