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.
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:
- 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