10 Functions that Help you Crunch Text Strings in Excel

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

How can I analyse a text string in Tableau?

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?