See How Data Engineering Gets Done on Our Do-It-Yourself Data Webcast Series

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
All Templates

Perform Sentiment Analysis and Easily Calculate Net Promoter Scores

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

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.


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