Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three related tables:
- Sales,
-Customers (associated with the customer number with sales),
- Products (associated product number with sales).
The customer table shows customer details.
The product table contains various data on products, including the product group that is important for us from the point of view of the case.
I wonder how to make a model that (after selecting a given customer), in addition to selling in a given period, will show data about other customers with a similar purchasing profile (i.e. those who most often buy products in the most similar product groups).
Do you have any idea?
Please upload some sample data and expected output for faster response.