DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

Predict new customers using Alteryx, SAP and Microsoft Power BI

26/3/2017

0 Comments

 
Picture
In this blog we will use Alteryx to build a model that produces a prioritized list of prospective customers for targeted marketing campaigns.

The Alteryx workflow builds a linear regression model using current customer data from SAP which is scored against prospective customer data from an Excel Sheet to produce a prioritized list of prospects.

​The data is then published to Microsoft Power BI.

Method

  1. ​Open the, “Predicting New Customers” workflow provided with the Alteryx Starter Kit for Microsoft.
  2. Adapt the workflow by replacing the Current Customers Excel Sheet data input source with an SAP data source.

Getting Started

To replicate the scenario you will need:
  1. Alteryx Designer –Request a trial here http://bit.ly/2mTkyxa
  2. Alteryx Connector for SAP –Request a trial here http://bit.ly/2nxlsfY
  3. Microsoft Power BI –Request a trial here http://bit.ly/2mEXHF4
  4. Alteryx Starter Kit for Microsoft –Download it here http://bit.ly/2mkmMSy
  5. Access to SAP BW

Data Sources

This workflow requires two data sources
Picture

1. Current Customers from SAP BW

There are multiple ways for us to access the data from SAP. In this example we are using a custom SAP BW InfoProvider. The data was previously loaded into SAP BW using the Alteryx Data Loader for SAP.

The SAP BW data is shown below.
Picture
The SAP Logon tool is used to connect to the SAP systems we want to use in the Alteryx workflow.
Picture
​The SAP BW InfoProvider tool is used to connect to the SAP BW Data Source.
Picture

 2. Prospective  Customers from Excel 

​The Prospective Customer data is provided in Excel format from the Alteryx Starter Kit for Microsoft.

The Excel data is shown below.
Picture
​Use the Input tool to connect to the Excel Sheet of Prospective Customers (This is provided in the Starter Kit).
Picture

Format and Blend the Data

Picture

1. Use the Data Time Tool

The Alteryx Date Time tool is used to convert the format of the SAP Customer Date of Birth(“ACSUSTDOB”) from a String Field to a new Date/Time Field, “DateTime_Out”
Picture

2. Use the Select Tool

​Use the Select tool on the SAP data to (1) select Fields relevant for the workflow, (2) change the Type of fields to “Double” so they can be used as Predictor Variables later in the workflow and (3) Rename fields so that they are consistent across the two data sources.
Picture

3. Use the Select Tool

​Use the Select tool on the Excel Sheet data to select the Fields required for the workflow. In this scenario no changes to Field Type or Description are necessary.
Picture

4. Use the Formula Tool

Use the Formula tool to determine the source of data and calculate the age of the customer.
  • Source: Identify the SAP Current Customer data as “Current Customer”
  • Age: Calculate the Age of the customer based on the Date of Birth and Current Date
Picture

5. Use the Formula Tool

Use the Formula tool to determine the source of data, calculate the age of the customer and provide a Total Sales value.
  • Source: Identify the Prospective Customer data as “Prospective Customer”
  • Age: Calculate the Age of the customer based on the Date of Birth and Current Date
  • TotalSales: Set the Total Sales value to NULL
Picture

6. Use the Union Tool

Use the Alteryx Union tool to merge data contained in both the SAP source and the Excel source. For this workflow the “Auto Config by Name” configuration option has been selected.
Picture

7. Use the Filter Tool

The Alteryx Filter tool is used to split the data into two streams. One stream for Current Customers and one for Prospective Customers.

Based on the Basic Filter applied in the configuration, data for Current Customers comes out of the “T” or True side of the tool. Data for Prospective Customers from the “F” or False side of the  tool.
Picture

Use Alteryx Predictive Tools

Picture

1. Use the Linear Regression Model Tool

Use the Linear Regression Model tool on the Current Customer data from SAP to test the statistical significance of  selected predictors.

Select the Predictor Variables for the Linear Regression Model tool. In this scenario, we are interested in using Martial Status, Gender, Number of Children, Number of Children Living at Home and Home Ownership as Predictor Variables.
Picture

2. Use the Browse Tool

Use the Browse tool to view the output of the Linear Regression Model tool.
Picture

3. Use the Stepwise Tool

Use the Stepwise tool to analyse the selected predictors in the linear regression model and create a model using the most significant predictors.

The Stepwise tool uses the output from the Linear Regression Model tool and the output from the Filter tool.
Picture

4. Use the Browse Tool

Use the Browse tool to view the output of the Stepwise tool.
Picture

5. Use the Score Tool

Use the Score tool apply the model created using the Stepwise tool to the Prospective Customer data. A Total Sales value is predicted and assigned to each Prospective Customer record.

Create a new Total Sales value field, “PredictedTotal Sales”
Picture

Prepare the Data for Microsoft Power BI

Picture

1. Use the Formula Tool

Use the Formula tool to create new columns and update existing columns.
  • Total Sales: Round PredictedTotalSales from the Score tool
  • Sales Potential: Convert the Total Sales value into “High”, “Medium” or “Low”
  • Marital Staus: If MaritalStatus = “M” then convert to “Married” otherwise “Single”
  • Home Owner Flag: If HouseOwnerFlag = 1 the convert to “Home Owner” else “Renter
Picture

2. Use the Select Tool

​Use the Select tool to prepare the output for Microsoft Power BI by renaming columns, updating data types, and removing  columns.
Picture

Publish to Microsoft Power BI

Picture

1. Publish to Microsoft Power BI Tool

​Use the Publish To Power BI tool. 
Picture

Use the Data in Microsoft Power BI

Run the Alteryx workflow. The Dataset is created in Power BI.
Picture
Picture

GET A FREE TRIAL OF THE ALTERYX CONNECTOR FOR SAP
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Categories

    All
    ACS
    ACS BusinessObjects
    ACS BW Write
    ACS Cloud
    ACS Metadata
    Alteryx
    Alteryx Gallery
    Alteryx Server
    Analytic Process Automation
    APA
    Audit
    BusinessObjects
    Consulting
    DVW Integration Platform
    DVW IP
    Inspire
    Jobs
    KCS
    KNIME
    Microsoft Azure
    Microsoft Power BI
    Office Of Finance
    Predictive Analytics
    Qlik
    Salesforce
    Salesforce Wave Analytics
    SAP BAPI Read Tool
    SAP BAPI Write Tool
    SAP BusinessObjects
    SAP Business Suite
    SAP BW
    SAP Data Migration
    SAP Document Tool
    SAP ECC
    SAP ERP
    SAP HANA
    SAP IDoc Tool
    SAP Query Tool
    SAP Read Tools
    SAP Report Tool
    SAP S/4HANA
    SAP Table Data Tool
    SAP Tables
    SAP Transaction Codes
    SAP Write Tools
    Services
    Tableau
    Tax
    TCS
    ThoughtSpot
    Top 10 Blog
    Training
    Webinar

    Archives

    December 2020
    November 2020
    October 2020
    July 2020
    June 2020
    May 2020
    February 2020
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    September 2018
    August 2018
    June 2018
    May 2018
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

PRODUCTS

ALTERYX CONNECTOR FOR SAP​
​
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
​ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​
​KNIME CONNECTOR FOR SAP

POWER BI CONNECTOR FOR SAP
TABLEAU CONNECTOR FOR SAP

SERVICES

PROFESSIONAL SERVICES
TRAINING

DEMOS

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
​
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​​
​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP

PRICING

BLOG

ABOUT US

CONTACT US

DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, KNIME, Power BI, Tableau & other global leaders in BI and analytics.

© COPYRIGHT 2003 - 2021 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS