James Pan

User banner image
User avatar
  • James Pan

Posts

How and why to avoid many-to-many relationship in Power BI

This blog aims to help those who are struggling to avoid many-to-many relationships in Power BI. Although Power BI supports many-to-many relationships, they are often...

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

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

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

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

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

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

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

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

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