{"id":2018,"date":"2020-10-01T00:00:14","date_gmt":"2020-09-30T22:00:14","guid":{"rendered":"https:\/\/devstage.bix-consulting.com\/?p=2018"},"modified":"2023-05-24T09:42:59","modified_gmt":"2023-05-24T07:42:59","slug":"bix-ai-tools-fallbeispiel-customer-churn-prevention","status":"publish","type":"post","link":"https:\/\/teststage.bix-consulting.com\/en\/bix-ai-tools-fallbeispiel-customer-churn-prevention\/","title":{"rendered":"biX AI Tools - Case Study: Customer Churn Prevention"},"content":{"rendered":"

[et_pb_section fb_built=“1″ _builder_version=“4.16″ _module_preset=“default“ border_color_bottom=“#e08a00″ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

Customer-Churn is the termination of a contract by the customer. Predicting such events before they occur is of great interest in many business areas. Focusing countermeasures on relevant customers reduces the effort and prevents a sleeper effect with customers who are not at risk.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

One possible way of predicting churn will be shown here using decision trees from the SAP HANA Predictive Analysis Library (PAL). A data set of customer data from a telecommunications company with known churn events serves as the data basis.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ min_height=“159px“ border_width_all=“2px“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

\n

\n

\u00a0\u00a0The sleeper effect describes that customers only evaluate their contract conditions through the established contact and then cancel.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

A decision tree separates the data set as precisely as possible into churn customers and non-churn customers. To do this, it creates decision rules for which it uses customer characteristics, such as \"Monthly turnover > X\" or \"Use of streaming offers yes\/no\". The combination of the individual rules then finally allows the decision tree to assign a customer to churn\/non-churn.<\/p>\n

[\/et_pb_text][et_pb_image src=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/10\/customer-churn.png“ title_text=“customer-churn“ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_text_color=“#919191″ text_font_size=“12px“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

Figure 1: Section of a possible decision tree<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=“1_2,1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

The choice of parameters when creating a decision tree influences both the accuracy of the assignment and the complexity of the rules. If one sets the value of simplicity high, the rules become less specific, but the accuracy of the classification usually decreases. So there is a trade-off between readability and better separation.<\/p>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=“1_2″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ min_height=“177px“ border_width_all=“2px“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

\n

\n

Simplicity here describes the necessary number of clients described by a rule. If this value is not reached, the rule is not formed and further division ends in this branch.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“17px“ text_line_height=“1.9em“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

For the creation of the decision tree and the verification of the created rules, training and test datasets are needed. In this example, the data set is in aDSO in SAP BW. Training set and test set are persisted as tables for comparability of runs from the data set. Data preprocessing and splitting was done using ABAP.<\/p>\n

\"\"\u00a0<\/p>
Figure 2: Query on connection ADSO<\/figcaption><\/figure>\n

After creating the separated sets, the quality of the created decision trees is assessed first with the training set then with the test set. If the accuracy of the separation of churn and non-churn is satisfactory, a final decision tree is created based jointly on training and test data. The decision trees are created with a call to SAP HANA PAL in ABAP. The created and combined rules from the PAL are difficult to read without further formatting and are not yet assigned to individual customers. However, an insight is desirable for checking the correct application of the master and transaction data in the rules. In addition, looking at which rule applies to a customer can give clues as to which aspects can avert the churn event. Therefore, the rules are formatted in further ABAP programs and the applied rule is assigned to each customer. The formatted rules are merged with the customer data in aDSO and can be evaluated by query.<\/p>\n

\"\"\u00a0<\/p>
Figure 3: Evaluation at rule level<\/figcaption><\/figure>\n

With a simplicity of 150, an accuracy of over 75% is achieved over the entire data set. However, looking at the rule level also allows the evaluation of the accuracy of the individual rules, which can also reach more than 90%.<\/p>\n

Thus, churn prevention measures can be focused on vulnerable customers with sufficient predictive accuracy. This can reduce costs for sales measures and increase efficiency by avoiding false customer contacts.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=“4.16″ _module_preset=“default“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_column type=“4_4″ _builder_version=“4.16″ _module_preset=“default“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“30px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

Contact Person<\/span><\/p>\n

[\/et_pb_text][et_pb_image src=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/08\/Oliver-Ossenbrink-e1598705178874.png“ align=“center“ _builder_version=“4.16″ _module_preset=“default“ transform_translate=“-4px|22px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][\/et_pb_image][et_pb_text _builder_version=“4.16″ _module_preset=“default“ text_font=“Roboto|300|||||||“ text_font_size=“16px“ transform_translate=“-3px|30px“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“]<\/p>\n

\n
\n

Oliver Ossenbrink<\/h3>\n<\/div>\n<\/div>\n
\n
\n

Management of sales and HR<\/p>\n<\/div>\n<\/div>\n

[\/et_pb_text][et_pb_social_media_follow _builder_version=“4.16″ _module_preset=“default“ transform_scale_linked=“off“ transform_translate=“0px|35px“ transform_translate_linked=“off“ text_orientation=“center“ locked=“off“ global_colors_info=“{}“ theme_builder_area=“post_content“][et_pb_social_media_follow_network url=“mailto:oliver.ossenbrink@bix-consulting.de?cc=vertrieb@bix-consulting.de“ _builder_version=“4.16″ _module_preset=“default“ background_image=“https:\/\/teststage.bix-consulting.com\/wp-content\/uploads\/2020\/08\/E-Mail.png“ background_enable_image=“on“ background_size=“contain“ global_colors_info=“{}“ theme_builder_area=“post_content“ follow_button=“off“ url_new_window=“on“][\/et_pb_social_media_follow_network][\/et_pb_social_media_follow][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>","protected":false},"excerpt":{"rendered":"

Customer-Churn ist die vom Kunden ausgehende K\u00fcndigung. Die Vorhersage solcher Ereignisse vor dem Eintreten ist in vielen Gesch\u00e4ftsbereichen von gro\u00dfem Interesse. Die Fokussierung von Gegenma\u00dfnahmen auf relevante Kunden verringert den Aufwand und verhindert einen Schl\u00e4fereffekt bei nicht gef\u00e4hrdeten Kunden.Ein m\u00f6glicher Weg zur Vorhersage von Churn soll hier mittels Decision Trees aus der SAP HANA Predictive […]<\/p>","protected":false},"author":6,"featured_media":979,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[18],"tags":[154,158,43,39,26,156,45,29,30,31,160,48,100,99,40,159,155,98,161,38,27,44,41,50,28,42,49,103,46,47,157,82],"modified_by":"admin","_links":{"self":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2018"}],"collection":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/comments?post=2018"}],"version-history":[{"count":0,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/posts\/2018\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media\/979"}],"wp:attachment":[{"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/media?parent=2018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/categories?post=2018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teststage.bix-consulting.com\/en\/wp-json\/wp\/v2\/tags?post=2018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}