Hello, good friends. The next step in our Analytics Journey takes us to the second iteration of Data Preparation. This is the third step of the CRISP-DM method.
Today, we are going to look at one of the most common data quality issues in Spotfire: the NULL, aka missing values. While there are many ways to address NULL values like imputation (a lesson for another day), the first step is simply identifying them. We will walk through Spotfire’s built in NULL identifier and also a more advanced TERR based method.