Net Promoter Scores Are Fiendishly Simple to Calculate in Power Pivot
What is “Net Promoter Score?”
Fundamentally, it’s a measure of how many of your customers love you, minus how many of them dislike you. Hence the name – Net Promoter Score.
WARNING: I am personally no expert here. I am doing my usual thing: take a small amount of knowledge and wield it like a battle axe. I was helping a client today (Monday) with this, and am writing about it a mere three hours later. But I figure there are lots of people out there who need to do this sort of thing, and THEY get what it all means. So allow me to share how EASY these calcs are in Power Pivot.
NetPromoter.com describes NPS as: