In this section, we will cover Text Analysis techniques that will help make your data cleaner, more organized and easier to work with. As an Analyst, sometimes the data given to you are not great (to say the least) and knowing how to process them will lead you to get more insightful and accurate outcomes!
Here are the concepts we will be covering:
- Using LEFT, RIGHT and LENGTH: These functions are used to extract specific parts of a string and to determine its length
- Using TRIM: This function is used to remove unwanted spaces from a string, either from the beginning, end, or both
- Using CONCAT: To combine multiple strings into one
- Using STRING Aggregation: This is used to combine values from multiple rows into a single string
- Using REGEX (stands for Regular Expressions): This is used for string pattern matching. For example, if you’re dealing with text data like customer feedback and you want to extract or replace specific patterns (like email addresses, dates, or specific keywords), you will use REGEX!
Well, we have a LOT to cover! Buckle up and let's do it! 🙇♂️
