JKISeason3-24_tark(2)
Level: Medium
Description: Your company wants to perform a cohort analysis to find customers that started purchasing goods on the same month (cohorts), and then track their persistence over time. To solve this challenge, you must explore a transactions dataset from 2016, identify its cohorts, calculate the customer retention ratio, separate the purchases month by month, and then visualize the persistence of the cohorts over time. Note: Customer retention rate (CRR) is the percentage of customers a company retains over a period of time. If E is the number of customers at the end of 2016, N is the number of new customers during the period, and S is the number of customers in the beginning of 2016, then CRR = [(E - N) / S] * 100.
Author: Aline Bessa
Dataset: Transactions Data in the KNIME Community Hub
URL: Just KNIME It https://www.knime.com/just-knime-it
URL: Dataset https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2024%20-%20Dataset~7XFBbPM5culJ6Abm/
URL: This challenge thread https://forum.knime.com/t/solutions-to-just-knime-it-challenge-24-season-3/84045
Nodes
- GroupBy9 ×
- Column Renamer8 ×
- Constant Value Column4 ×
- Math Formula4 ×
- Column Appender3 ×
- Show all 27 nodes
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Excel Support
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)
- FeatureKNIME Views
Links
- No links available