Data Engineering Template:

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?

If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Designer Cloud.

Use in Designer Cloud Use in Dataprep