How to find commonly purchased items from sales table, so that we increase the sale if any of the commonset if items are purchased and recommend the other sets along with it. Similar to market basket.
I have a Sales table, with list of Geography wise, Customers, Dept, Items sold with Sales total for each item etc.
If we need to find common items purchased by 2 or more dept areas and more than 2 Customers etc. This will help to sell more on those items as well stock them adequately.
North America (Geo), Stationary, tools, Furniture (departments), common items purchased are Note books, wooden table, Hammer - by 40 customers and the combinations of items can be 10 + and its total Customers count and Sale value.
Something like Apriori or FPgrowth algorithm type of solutions.
Please let me know, if we can do this using Power BI.