Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Wrangle Summit 2021 On Demand

You can still experience the best people, ideas and technology in data engineering, all in one place

Get All-Access Pass
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 to Trifacta?

Sign up below to our free 30-day trial to use this template.


Already have an account?

Download template (Trifacta version) and import it on the Flows page.

Is your data on Google Cloud?

  1. Download template (Dataprep version)
  2. Launch Dataprep on Google Cloud
  3. Import it on Flows page

Learn more about Dataprep

How to Import