Spotfire Filters Don’t Recognize Special Characters

Julie Schellberg of Big Mountain Analytics, LLC Spotfire Leave a comment

It’s FRIDAY!!!  I know you are all looking forward to the weekend, but I learned something new again this week and wanted to share it. This little tip is related to filers and special characters.

List Box Filters & Special Characters

I noticed a long time ago that the Spotfire list box filter (and presumably text filters) don’t respond to special characters, as shown below.  I didn’t really know what to do about it until recently.Search without special characters Search with special characters

Solution

It turns out, the solution is really simple.  Just ignore the special character.  Don’t type it, and the search function in the filter will work.

Special characters solutoin

 

Data Science Toolkit Improvements

Julie Schellberg of Big Mountain Analytics, LLC Data Science, Spotfire Leave a comment

This week, I was able to test out the latest and greatest changes to the Ruths.ai Data Science Toolkit.  New options and features allow users to easily split test and training data sets prior to model building, as all good data scientists should!  This new functionality speeds up your analysis by making model build and evaluation faster and more efficient.  I worked up this video to demonstrate.

 Data Science Toolkit for Spotfire

The Data Science Toolkit brings the power of advanced data science to Spotfire.  Ruths.ai designed it with simplicity and efficiency in mind to support a wide range of analytics applications. This extension is coupled with comprehensive training that provides both beginner and experienced users a strong foothold in data science analysis.  The Data Science Toolkit is available to Premium subscribers.  Once deployed on your Spotfire server, quickly and easily access the toolkit via the Tools menu as shown below.  Find out more, including videos, at this link.

Data Science Toolkit menu

Please feel free to reach out to me or anyone else on the Ruths.ai team to learn more about this amazing product.  We love to talk about it!

 

CRISP-DM Modeling: Forward and Backward Selection

Jason May Analytics Journey Series 1 Comment

Welcome back everyone to our Analytics Journey series.  Those of us in Houston have been through a trying time, and our thoughts are with the community.  We will try to return to a semblance of normalcy by continuing where we left off in our journey.

With all of our hard work in understanding and preparing the data during previous steps of the CRISP-DM method–exploring data, choosing a model space, removing NULLs, removing Multicollinearity–it’s time to have some fun with the Modeling stage.  Today, we’ll look at an aspect of Multiple Linear Regression:  Forward and Backward Selection.

Read More

CRISP DM Data Preparation: Finding and Counting NULL Values in Spotfire

Jason May Analytics Journey Series Leave a comment

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.

Read More