Sunday, April 13, 2008

Market Basket Analysis

Some time ago, one of the Accounting Division’s staff asked me to reveal if the last decision of the Bank about introducing new participation papers were successful or not; also, he asked me to specify what percent of its sales were because of changing other deposits.
It was a hard job, because we had not any clear idea on how to deal with this matter! It had done, but I kept thinking about solving this problem via Business Intelligence Solutions rather than executing complex queries on databases.
When I was reading “The Data Warehouse Toolkit Second Edition”, I realized that it is very similar to “Market Basket Analysis” concept, and after doing some search it began to sink in.
Indeed, I found it out that it could be done via association algorithm of the Data Mining. This subject is about the market basket analysis, and finding the association of products based on their sales, in order to offer new discount for increasing the sales.
For instance, you can imagine that when you find it out that the toothpaste and toothbrush were sold together in most situations, it could be a good starting point for designing new promotion!

4 comments:

Pedro said...

HI Amin!
Could you describe in more detail what you did in that project! Seems to be very interesting!!
Cheers!!
Pedro

Amin said...

Hi Pedro,
Off course, but I think it shouldn't be very interesting for you because what I did in that project was just about complicated SQL and Excel, instead of that I think it is better if I describe its Business Intelligence solution. So I describe it soon.

Regards,
Amin

Pedro said...

hey... where is your post!!?? :-(
Cheers!!!

Anonymous said...

bisolutions.blogspot.com is very informative. The article is very professionally written. I enjoy reading bisolutions.blogspot.com every day.
bad credit cash loans
loans