Fighting Churn

Customer Behavior you own this product

This project is part of the liveProject series Fighting Churn with Manning's liveBook Data
prerequisites
basic Python • basic PostgreSQL
skills learned
loading data into a database • design and calculate customer metrics • perform quality assurance analytics
Carl Gold
1 week · 12-15 hours per week · INTERMEDIATE
Included with a Manning Online subscription
try now

pro $24.99 per month

  • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
  • choose one free eBook per month to keep
  • exclusive 50% discount on all purchases

lite $19.99 per month

  • access to all Manning books, including MEAPs!

team

5, 10 or 20 seats+ for your team - learn more

Look inside
In this liveProject, you’ll clean and process data from Manning’s liveBook platform and prepare it for investigatory analysis to discover causes of customer churn. You’ll load a raw data dump of customer behavior data into PostgreSQL for analysis, categorize and check the event records for bad data, and calculate a basic set of interpretable customer metrics. Some SQL skills and a little Python is all you need to produce a clean and easy-to-interpret data set of customer behavior.
This project is designed for learning purposes and is not a complete, production-ready application or solution.

book resources

When you start your liveProject, you get full access to the following books for 90 days.

project author

Carl Gold
Carl Gold is the senior data science manager for financial startup Migo.money. He has previously worked as chief data scientist for Zuora, the industry-leading subscription management platform. He has a PhD from the California Institute of Technology.

prerequisites

This liveProject is suitable for anyone with a basic background in programming and data analysis, who wants to really make a difference to a business's churn. To begin this liveProject you will need to be familiar with:

TOOLS
  • Basic Python
  • Basic PostgreSQL

you will learn

In this liveProject, you’ll master practical techniques from wrangling a raw set of data into something usable by your company in fighting churn.
  • Loading data into a database and analyzing loaded data with SQL and Python
  • Feature engineering to design and calculate customer metrics with SQL
  • Perform quality assurance analytics with SQL data collection and Python analytics and visualization

    • features

    Self-paced
    You choose the schedule and decide how much time to invest as you build your project.
    Project roadmap
    Each project is divided into several achievable steps.
    Get Help
    While within the liveProject platform, get help from other participants and our expert mentors.
    Compare with others
    For each step, compare your deliverable to the solutions by the author and other participants.
    book resources
    Get full access to select books for 90 days. Permanent access to excerpts from Manning products are also included, as well as references to other resources.

    choose your plan

    pro

    monthly
    annual
    $24.99
    $249.99
    only $20.83 per month
    • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
    • choose another free product every time you renew
    • choose twelve free products per year
    • exclusive 50% discount on all purchases
    • Customer Behavior project for free

    team

    monthly
    annual
    $49.99
    $499.99
    only $41.67 per month
    • five seats for your team
    • access to all Manning books, MEAPs, liveVideos, liveProjects, and audiobooks!
    • choose another free product every time you renew
    • choose twelve free products per year
    • exclusive 50% discount on all purchases
    • Customer Behavior project for free