Book Image

Mastering QlikView Data Visualization

By : Karl Pover
Book Image

Mastering QlikView Data Visualization

By: Karl Pover

Overview of this book

Just because you know how to swing a hammer doesn't mean you know how to build a house. Now that you've learned how to use QlikView, it's time to learn how to develop meaningful QlikView applications that deliver what your business users need. You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced QlikView functions, chart object property options, and extensions to solve real-world challenges.
Table of Contents (18 chapters)
Mastering QlikView Data Visualization
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Customer churn


Customer churn is a measure of the company's tendency to lose customers. Our user story speaks of the need to detect at-risk customers and prevent them from becoming a lost customer.

Note

As a sales representative, I want to see which customers I'm at risk of losing so that I can take action today to prevent their leaving.

Surely, there are many variables that we may use to predict customer churn. In this case we expect customers to consistently make a purchase every so many days, so we will use a variable called customer purchase frequency to detect those that we are at risk of losing.

We could calculate the average number of days between purchases and warn sales representatives when the number of days since a customer's last purchase exceeds that average.

However, a simple average may not always be an accurate measure of a customer's true purchasing behavior. If we assume that their purchase frequency is normally distributed then we use the t-test to determine within what range...