Icon

Customer Transactions Analysis

With this data app workflow, you can better understand the effects of Ad Campaigns and Demographic data to make informed decisions about where to focus your marketing efforts.

This workflow combines combines and cleans customer and transaction data from excel and .csv before displaying in an interactive data app page.

Data Blending, Cleaning, Transforming

Data Sources




Data Visualization







Customer_Data.xlsx
Excel Reader
Remove outliersbased on age
Numeric Outliers
Customer_Group_Lookup.xlsx
Excel Reader
Map customer groups.(ex: CC1 = First Time Buyers)
String Replacer (Dictionary)
Interactive Dashboard
Analysis Dashboard
Remove duplicatesbased on CustomerID
Duplicate Row Filter
Remove rows with missing age
Missing Value
Join Customers toTransactions based onCustomerID
Joiner
Transactions_Table.csv
CSV Reader

Nodes

Extensions

Links