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.