ALTERYX CONNECTORS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR SAP CX
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP RPA
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

KNIME CONNECTORS

KNIME CONNECTOR FOR SAP
KNIME CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS

TABLEAU CONNECTOR FOR SAP

POWER BI CONNECTORS

POWER BI CONNECTOR FOR SAP
FREE TRIAL
DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX RPA TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • DATAIKU CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • 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 BOP
    ACS CX
    ACS Metadata
    ACS SF
    Alteryx
    Alteryx Connector For BusinessObjects
    Alteryx Connector For SAP
    Alteryx Connector For SuccessFactors
    Alteryx Gallery
    Alteryx Inspire
    Alteryx RPA Tools
    Alteryx Server
    APA
    Audit
    BusinessObjects
    Data Migration
    DVW Integration Platform
    Finance
    KCS
    KNIME
    KNIME Connector For SAP
    Microsoft Azure
    Office Of Finance
    On Demand Webinar
    Power BI
    Power BI Connector For SAP
    Predictive Analytics
    Process Automation
    Professional Services
    Qlik
    Read Tools
    RPA
    Salesforce
    Salesforce Wave Analytics
    Sample Workflow
    SAP Business Suite
    SAP BW
    SAP C4C
    SAP ECC
    SAP ERP
    SAP HANA
    SAP S/4HANA
    SAP Tables
    SAP T Codes
    SAP T-Codes
    SAP Transaction Codes
    Snowflake
    Snowflake Connector For SAP
    SuccessFactors
    Tableau
    Tableau Connector For SAP
    Tableau Desktop
    Tableau Online
    Tableau Prep
    Tableau Server
    Tax
    TCS
    ThoughtSpot
    Tool: BOP Universe
    Tool: BOP Webi
    Tool: HTML RPA
    Tool: SAP BAPI Read
    Tool: SAP BAPI Write
    Tool: SAP BW Write
    Tool: SAP Document Read
    Tool: SAP IDoc
    Tool: SAP Query
    Tool: SAP Report
    Tool: SAP RPA
    Tool: SAP Spool Read
    Tool: SAP Table Data
    Tool: SuccessFactors Read
    Tool: SuccessFactors Write
    Top 10 Blog
    Webinar
    Write Tools

    Archives

    March 2023
    February 2023
    January 2023
    October 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    May 2021
    April 2021
    December 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
    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 CONNECTORS
​KNIME CONNECTORS
​POWER BI CONNECTORS
TABLEAU CONNECTORS
DATAIKU CONNECTORS
SNOWFLAKE CONNECTORS

FREE TRIAL

​ALTERYX CONNECTORS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
​FREE TRIAL OF ALTERYX RPA TOOLS
​FREE TRIAL OF ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS

​KNIME CONNECTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
FREE TRIAL OF KNIME CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF ​KNIME CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF KNIME CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

POWER BI CONNECTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF POWER BI CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

TABLEAU CONNECTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP
​​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)


SNOWFLAKE CONNECTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)

FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

SERVICES

PRICING

DEMOS

BLOG

HELP CENTRE

ABOUT US

CONTACT US

The DVW Integration Platform from DVW Analytics, brings the power of SAP to users of Alteryx, KNIME, Power BI, Tableau and other global software leaders for Analytics & Process Automation

© COPYRIGHT 2003 - 2023 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 RPA TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • DATAIKU CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS