by Joe Chan | Oct 11, 2022 | Joe Chan
What is LOD? LOD (Level of Detail) allows you to compute values at the level of data source and visualization. However, it gives you more control over the level of granularity you want to compute. In FIXED LOD, we can specify the level of granularity. This blog is...
by Joe Chan | Oct 1, 2022 | Joe Chan
Why do we need a Calendar Lookup table in the Power BI data model? A Calendar Lookup table can provide you with more information about the date. What’s more, it can make sure the consistency of the date. So it’s highly recommended to add the date table in...
by Joe Chan | Sep 24, 2022 | Joe Chan
What is the URL Action in Tableau? A URL action is a hyperlink that points to a web page, file, or other web-based resources outside of Tableau. You can use URL actions to create a link to additional information about your data. To customize links based on your data,...
by Joe Chan | Sep 22, 2022 | Joe Chan
What are spatial functions in Tableau? Spatial functions allow you to perform advanced spatial analysis and combine spatial files with data in other formats like text files or spreadsheets. In this blog, I’ll show you how to use the spatial functions in Tableau...
by Joe Chan | Sep 11, 2022 | Joe Chan
What is API? How to deal with the problem with Pagination API? An application programming interface (API) is a way for two or more computer programs to communicate with each other. Some APIs will provide you with a link to let you collect all the data. In this...
by Joe Chan | Sep 3, 2022 | Joe Chan
What is Pareto Chart? A Pareto chart contains columns sorted in descending order and a line representing the cumulative total percentage. It highlights the most significant factors in data and is considered one of the seven basic quality control tools as it’s...