Customer Transactions Analysis

5.Merge the Data

2.Transactions Table

1. Access the Data

2.Clean the Data

Clean the Customer Information System 1

• From File(s)

1.

2.

3.

• From a Database

3.Data Transformation

4.Data Cleaning and Data Transformation Metanode

Customer Information System 2

Transform the Customer Information System 1

L1 Project - Excercises

Customer Transactions Analysis --Part 1--

Table Check and Final Transformations

Table Check and Final Transformations

1.Concatenate the two customer tables

Append StoreType

Append Price

3.Join Customers with Transactions

6.Aggregate the Data

1.Row Aggregator node

2.GroupBy & Pivot Node

7.Data Export, Visualization and Reporting

1. Export the Data with Excel Writer

2. Visualize the Data

3.Final Transformations , Dashboard and Reporting

L1 Project - Excercises

Customer Transactions Analysis --Part 2--