by James Pan | Nov 9, 2024 | James Pan
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 avoided or used with caution because they can lead to unexpected outcomes. A many-to-many...
by James Pan | Nov 9, 2024 | James Pan
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...
by James Pan | Nov 9, 2024 | James Pan
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....
by James Pan | Oct 31, 2024 | James Pan
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...
by James Pan | Oct 31, 2024 | James Pan
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...
by James Pan | Oct 29, 2024 | James Pan
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...
