I need a script/program to take a CSV file and visualize its contents.
The file has the following columns:
Customer ID - a unique ID for each customer in a retailer's database.
Purchase date - the date when a customer made a purchase.
Product - which product the said customer purchased on the said date.
Quantity - how many units were purchased.
There are returning customers, that is customers which bought more than once. The can buy several items, however only one type of product per each purchase they make. One step at a time.
The script needs to visualize the product sales and the customer journey (i.e. X% customers which bought product X in their first purchase carried on to buy product Y, etc.) in a tree like fashion. The order will be determined by the purchase date.
Please see the sample CSV for you to work with and the powerpoint with what I had in mind. (the numbers in the powerpoint don't match the ones in the CSV. they are made up numbers for presentation purposes).
THE BEST WAY TO GET THE JOB IS TO GENERATE THE VISUALIZATION OR AT LEAST A PART OF IT.
If you can't produce everything I ask for in the presentation, please consult with me.
Feel free to PM with any questions.
Additional Project Description:
04/11/2013 at 12:29 AKDT
NOTE!! There was an error with the budget allocation! The budget itself is really <$100.