JKISeason3-24_​tark

0 ×

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