James Pan

James graduated from Sydney University with a master’s degree in Business, Data Analytics and Marketing. He is fascinated by exploring hidden patterns in large datasets, which often lead to unpredictable but meaningful insights for decision-making purposes. This motivated him to delve deeper into the world of data analytics, and to start his future career in the data industry at the Data School Down Under.
In his spare time, James enjoys going to the gym and taking tours with his friends – particularly to taste all kinds of delicious cuisines!

Swap Measures Using a Parameter in Tableau

Swap Measures Using a Parameter in Tableau

Swap measures using a parameter in Tableau can reduce clutter effectively. Instead of using multiple charts of the same type for different measures, a single chart with a parameter allows users to toggle between multiple measures, helping to maintain a clean and tidy...

How to Set Up Row-Level Security in a Power BI Report

How to Set Up Row-Level Security in a Power BI Report

If you are trying to solve the problem of creating different views for different users when they are using your report, this is the blog for you. Row Level Security (RLS) in Power BI allows you to set different restrictions on data access based on specific user types....

Dashboard Week #4

Dashboard Week #4

Dataset Overview: It’s the fourth day of dashboard week. Today, our task is to build a dashboard based on the given data about the infectious disease dengue and any supplementary data that we are curious about. The provided data includes limited information on the...

Dashboard Week #3

Dashboard Week #3

Dataset Overview: It's the third day of dashboard week. Today, out task is to connect to a national park API to retrieve the data, and build a dashboard based on the data. The API provides information on activities, alerts, amenities, events, campgrounds, and...

Dashboard Week #2

Dashboard Week #2

Dataset Overview: Today is the second day of the dashboard week, we were given a  dataset about mines. It covers 1171 individual mines in 80 different countries, reporting mine-level production for 80 different materials in the period 2000-2021. Furthermore, also data...

Dashboard Week #1

Dashboard Week #1

Overview: Today is the first day of our dashboard week. The dataset we were given is about boating accidents occurring in U.S. coastal jurisdictions. The data has three major sections: accident information, vessel details, and casualties involved in the accidents. It...

How to connect to Snowflake from Alteryx

How to connect to Snowflake from Alteryx

Alteryx supports connecting to data from different sources, including databases stored in Snowflake. I will cover the entire connection process step by step in this blog. I hope it will be helpful for those trying to set up this connection but encountering...

Information Button in Power BI

Information Button in Power BI

A button that provides quick access to guidance and explanations about the data or metrics being displayed can be especially useful when you want to offer more detailed information to audiences. I’m going to show how to create an information button that contains sales...

How to Label Exact Dates in Tableau

How to Label Exact Dates in Tableau

It's common these days to highlight few dates among all the data and label them with different colours or sizes compared to other date data points for each customer or transaction. Table calculations are the most efficient way to solve this problem in this scenario....