Test only - size reduction

Data Analysis template

Steps:

1)import of: Order data, SKU master data & stock snapshort

2) configure data type, naming convention and dimension of SKU & clean data (double lines, negative Quantities,...)

3) Enter AS bin types

4) Different standard analysis are available

1) Import Order data:

• import order data files

• if several files use "concentante node" to apped files (columns if different files should have same naming and same data type)

  • if problems try to import as data type "String" under sheet "Transformation"

  • usefull nodes "Concentenate" & String Manipulation"

  • typical nodes (CSV reader, excel reader, file reader) :

2) Import Master data:

• import master data file

• if problems try to import as data type "String" under sheet "Transformation"

  • typical nodes:

3) Import Stock data:

• import stock data file

• if problems try to import as data type "String" under sheet "Transformation"

• ATTENTION if multiple days in stock snapshot

Import order data:

1.1) Configure:

• Renaming of columns to fit the right naming

• IF necessary convert Date from String to Date format

• If necessary convert Qty to Integer from String

2.1) Configure:

• Renaming of columns to fit the right naming

3.1) Configure:

• Renaming of columns to fit the right naming

Order data Data cleaning process

• Convert date format

• filter: only lines with Integer Qty => 1

• Double lines: Same Date, Order_ID and SKU_ID are grouped and the qty is summed up (possible consequence: reduced number of order lines per day)

SKU: Data cleaning process

• missing dimensions / weight is replace with 0

  • alternative approaches are not in

• conversion into Kg and mm

• lines with neg or 0 dim (length or width or height are filter out)

• only one line per SKU (first line considered)

• Calculation of Volume in l

Stock: Data cleaning process

• conversion to int for QTY

• Search for peak day by qty

• sum up stock over possbile different lines for same SKU

  • consider only positive summed up stock

2.2) Configure

• define UOM in original master data

Criteria for double lines

• Date, Order Id & SKU

Posiiblity to add STring columns in group node:

• all string columns could be filter in analysis

Merge Data Files

Order, Sku Master & Stock

Overview Data Quality

Container Assignment Tool

4) Choose TU Types

Test only

1.3) Data Analysis (order data)

1.4) Bin and Task distribution & Hitrate

5) with or/and without master data

6) analysis with or/and without master data