Wednesday, December 05, 2012 8:20 AM
I am not familiar with SSRS, I need to analyze user actions from the following table:
The thought is finding correlation between feature usages. So, arriving at a conclusion that the users who use Feature A, tend to use Feature B and C as well. The "SequenceNum" can be used to identify the orders of feature usage per session. Finally the report should like this:
UserAction UsageCount FeatureA -> FeatureB 3825 FeatureA -> FeatureB -> FeatureC 3014 FeatureB -> FeatureC 2825 FeatureC -> FeatureB 2736 FeatureB -> FeatureA 1987
I guess I need use BIDS to analyze it, but don't know how to start. Really appreciate it if you can guide me to achieve it!
Wednesday, December 05, 2012 5:37 PM
You are looking at Market basket analysis and trying to extract association rules for your features.
You can use Sql server analysis services(SSAS) - Data mining to run association rules algorithm to model a solution. And report out the results using DMX and SSRS.
please remember to mark as answered if the post helped resolve the issue. "Essentially, all models are wrong, but some are useful"" - George E.P.Box
- Marked As Answer by JLiu0728 Friday, December 07, 2012 3:45 AM
Thursday, December 06, 2012 7:25 AMModerator
You need create a Market Basket Structure and Model that is based on the Microsoft Association algorithm. After the models have been processed, you can use the information about associations stored in the model to create predictions. Please refer to the following links as example:
Building a Market Basket Scenario (Intermediate Data Mining Tutorial): http://msdn.microsoft.com/en-us/library/ms167047.aspx
Mining Model Content for Association Models (Analysis Services - Data Mining): http://msdn.microsoft.com/en-us/library/cc645767.aspx
If you have any feedback on our support, please click here
TechNet Community Support
Friday, December 07, 2012 3:46 AM
Thank you very much for your useful replies, I'll take a look at it later!
Friday, December 07, 2012 3:48 AM
Thank you very much for your detail information, I'll go through the tutorials later.