In this tutorial, you will find out many ways to find substrings in SQL regardless of the DBMS. We will cover conventional operators like ‘LIKE’, ‘CONTAINS’, ‘CHARINDEX’, and many others. So buckle up and get started or just scroll to find the exact way to use find exactly where strings contain substring Watch The Video […]
Imagine you have a magical data transformation tool that can be your personal time-saver for all things related to data. You know those moments when you find yourself dealing with repetitive tasks like copying, pasting, and column mixing? Well, Power Query jumps in and says, ‘Hey, let me handle that for you!’ So, let’s explore […]
Power Query in Excel is a great tool to use in data preparation and when you need to concatenate or combine, values from different columns or rows even files. In this article, we’ll dive into how you can use Power Query to concatenate values. What is Concatenation? Concatenation refers to the process of joining two […]
Cutting a cell value entails extracting the content from a specific cell or range of cells in a Microsoft Excel spreadsheet. This action removes the selected data and places it on the clipboard, making it ready to be pasted into another location. Here is the use case that you may be looking for : Short […]
Entering the world of data analysis can be very confusing. However, the spectrum of techniques helps to address several use cases. Let’s explore all the different types of analysis that are used in data analysis. However, this list isn’t exhaustive but it will cover the fundamentals. Types of Analysis Description Comparison Prediction Time Series Categorization […]
In this blog post we’ll talk about spill errors and describe how to fix them. We’ll also see how to prevent spill errors and manage them when they do happen. This blog post is beneficial for both beginners and experienced Excel users! What is #SPILL error in Excel? When a dynamic array formula generates more […]
What is an Outlier? An outlier is a data point that differs significantly from other observations. Whether due to genuine variance or errors in data collection, outliers stand out from the rest. Why are Outliers Important? Outliers can skew results, misleading interpretations or significantly affecting statistical measures. Hence, it’s essential to detect and address them […]
Contrary to popular belief, data analysts don’t spend most of their time analyzing data. This is just a portion of what you are tasked to do. Remember you are a part of a team. So there are going to be meetings, requirements conversations, presentations,s and reporting that will take a large portion of your time. […]
Every Excel user is familiar with charts and how to generate them easily using templates. However, the Gantt chart is one graph type that many people still find confusing because there is no built-in template for Gantt Chart. So, in this blog, we’ll comprehensively cover all aspects of the Gantt Chart. What is Gantt Chart? […]
Why do you need to wrap text? Text wrapping ensures that lengthy text that overflows its cell is rearranged. Text wrapping makes your text appear on multiple lines within the cell. This does not involve any changes to the data or the insertion of line break characters. This means the text merely appears to be […]