Hey There.. Is there a way we could combine those two ranges(A6:DC37 and N73:DP193) if they dont share the common headers.( If they share common header we can combine with Joins). Kindly help!!
Hello Sir, Is it possible to perform data cleaning processes similar to what we can do in Python or SQL? For example, changing data types and modifying null values with mean, median, or mode values.
Nice video, just one doubt., what if we have multiple sheets with same issue, how to union with wildcard.!? If i union with wildcard, its picking non cleansed data. Please suggest. Thank you.
Hi, Can you please tell how can we refresh that file which gets created after using data interpreter. My base file updates daily but I am unable to see that updated information in cleaned file.
Hello Sir Suppose we have data for hospitality and if u have to calculate average daily rate regarding sold out room vs unsold room then how can we calculate using tableau
To calculate average daily rate, you would divide the sum of the revenue by the sum of the rooms sold. It should be an aggregate calculation, otherwise it won't work properly.
Hey There..
Is there a way we could combine those two ranges(A6:DC37 and N73:DP193) if they dont share the common headers.( If they share common header we can combine with Joins). Kindly help!!
Hello Sir,
Is it possible to perform data cleaning processes similar to what we can do in Python or SQL? For example, changing data types and modifying null values with mean, median, or mode values.
Nice video, just one doubt., what if we have multiple sheets with same issue, how to union with wildcard.!? If i union with wildcard, its picking non cleansed data. Please suggest. Thank you.
Don't get it. What are the changes?
Hi, Can you please tell how can we refresh that file which gets created after using data interpreter. My base file updates daily but I am unable to see that updated information in cleaned file.
If some how you are able to set the solution please share with me
Hello Sir
Suppose we have data for hospitality and if u have to calculate average daily rate regarding sold out room vs unsold room then how can we calculate using tableau
To calculate average daily rate, you would divide the sum of the revenue by the sum of the rooms sold. It should be an aggregate calculation, otherwise it won't work properly.
please share the excel file as well
nice video. kuch smj ni aaya