Data Processing

After introducing the case background, you can upload and process data, and associate data in multiple tables by using Join and Model View.

Sample data: Product Table.xlsx; Order Table.xlsx; VIP Table.xlsx.

Data Uploading

You can download the sample data and upload it to an analysis subject, as shown in the following figure.

Data Editing

Since the fields VIP Birthday and Registration Date are displayed in numerical value format rather than timestamps, relevant functions need to be used for data processing, as shown in the following figure.

Similarly, you can duplicate the Birthday field and replace VIP Birthday with Registration Date, as shown in the following figure.

You can use the Time Interval function to calculate the customer's age, as shown in the following figure.

Multiple Tables Association

When analyzing multiple tables, you can establish data relationships between tables through two approaches, Join and Model View. 

Note: 

The Join function is used in this example.

Join 

Join Product Table to Order Table first, as shown in the following figure.

Join VIP Table similarly, as shown in the following figure.

Model View 

Create a model view between Order Table and Product Table, as shown in the following figure.

Create a model view between Order Table and VIP Table, as shown in the following figure.

Save and update the data after processing.

After completing the study of this document, you are advised to proceed to the next document, Finding Required Products for Customers, for further learning.