Data Mining

Using the ExampleSets Products and Transactions in

Rapidminer to determine the top 5 customers by total sales

You are to turn in a Word document with two items.

1. An exported image of the Process frame showing the Operators used to get the results

2. A copy of the Results showing the Row No., Customer ID, and the Sum of Total Sales for the top five customers.

Hint: Here is a sample of steps for a solution. You are welcome to follow this guide or design your own Process solution.

1) The two datasets are obtained from Rapidminer data

2) The Join operator to combine the data. Use the appropriate key attribute

3) Since you need Total Sales (a calculated attribute) you will need the Generate Attribute operator

4) The Aggregate operator will help you create a new ExampleSet (dataset) having Total_sales grouped by the CustomerID

5) Use the Sort operator to sort Total Sales by CustomerlD

Posted by (Bilawal)