It has often been the case in the course of my assignments that I've had to do quite some data prep in Excel before I could have a clean dataset to crunch. If you also need to do this in Excel, below are 10 functions that I have found indispensable. The datasets I'm going to … Continue reading 10 Functions that Help you Crunch Text Strings in Excel
It's not much different than analysing a text string in SQL 😉 Tableau uses more or less the same standard text functions that you will find in SQL. Let's use a sample dataset of TEDx videos - ted_main Assuming I want to check if there is any correlation between the number of views a video … Continue reading How can I analyse a text string in Tableau?