Advanced predictive analytics

The task below will be automatically checked off once you complete watching the video.


[progressally_media media_id='1']

  • With some simple Excel hacks, you can do basic machine learning
  • These are good techniques to familiarize yourself with, and they offer an idea of what’s possible with more digging.
  • Linear Regression: Use when you want to forecast a future number like, for example, total dollars spent or the number of logins to expect in the next six months.
  • Logistic Regression: Use this to solve an either/or event, like either a member renews or they don’t. This helps with identifying the probability that someone won’t renew.
  • Clustering: Look at shared behaviors across all metrics and segment users/members based on how they behave across multiple metrics.

Additional Tools

Open or download the Predicting Member Churn Spreadsheet to view the Advanced tab.

[accessally_course_navigation prev_button='Previous' next_button='Next']

[progressally_note note_id='1' allow_attachment='no']

Share your progress!

[progressally_social_share type='facebook' share_id='1' post_id='42'][/progressally_social_share][progressally_social_share type='twitter' share_id='1' post_id='42'][/progressally_social_share][progressally_social_share type='email' share_id='1' post_id='42'][/progressally_social_share]