Customer Purchase Behavior question

[lhii0109]

Hi,

I am new to here. I found this forum is extremely useful for me. Is it possible for powerpivot to perform following task.

I have sale data like below where saleID is unique key.
[TABLE="width: 500"]
<tbody>[TR]
[TD]saleID[/TD]
[TD]userID[/TD]
[TD]ProductID[/TD]
[TD]PurchaseDate[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]123[/TD]
[TD]2[/TD]
[TD]11-01-2013[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]254[/TD]
[TD]2[/TD]
[TD]11-10-2013[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]123[/TD]
[TD]1[/TD]
[TD]11-11-2013[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]123[/TD]
[TD]3[/TD]
[TD]11-12-2013[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]254[/TD]
[TD]5[/TD]
[TD]11-12-2013[/TD]
[/TR]
</tbody>[/TABLE]


Is it possible for PowerPivot to have a pivot table that show what will the customer buy after buying let say productID = 2?

(The table is just for illustration. It can be changed as long it answers question above.)
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Next Purchase (Count UserID)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ProductID[/TD]
[TD]Count of UserID[/TD]
[TD]ProductID = 1[/TD]
[TD]ProductID=2[/TD]
[TD]ProductID=3[/TD]
[TD]Productid=5[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


I appreciate if you can leave comment or have any idea like other approach. Thank you!

 

[cyrilbrd]

Hi,

In your remarks you mentioned 'Is it possible for PowerPivot to have a pivot table that show what will the customer buy after buying let say productID = 2?', Yes, you may place productID in the filter field and select the data of your choice, the pivot will limit it's query to whatever is stated in the filter field.
Would that work for you?

 

[lhii0109]

Hi cyrilbrd,

Thank you for your input. When I placed productID in filter field and filter productID = 3, and values - Count of UserID. It shows number of users buying ProductID 3. (For example 150 users). This is first step. From here, I am interested to look at out of 150 how many users will buy productID 1 or 2... or no purchase after purchasing productID 3. Thanks!