Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
 
All Templates

Perform Sentiment Analysis and Easily Calculate Net Promoter Scores

NPS and Sentiment Analysis of Reviews Flow The flow view of this template

Transformations:
case, sum, groupby (aggregation), extractlist, countif

This example flow shows how you can perform a NPS and sentiment analysis of review data. The flow makes use of example hotel review data, on a rating scale of 1-5. It computes the NPS rating from mapping promoters and detractors against the rating scale. It also tries to extract out keywords from the text reviews and correlate the NPS ratings against them.

You can use the same technique in this flow to perform NPS calculations for other types of review use cases. Additional analysis can also be done on the keywords that have been identified to correlate strongly with positive or negative ratings.

USE IN TRIFACTA USE IN DATAPREP

New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep