The marketing team wants to understand our vendors a bit better. Their questions are:

a) Is there any order imbalance per vendor in each market? b) Could we identify some relevant segments of vendors? c) Are there any other interesting insights you would share with them?

Use the orders data provided. Given the request and the available data:

1. With a tool of your choice (R/Python, SQL etc), use the shared data to build an analysis that could answer their questions. 2. Aside from the available data, what other features would you include for an effective segmentation?

3. How could the marketing team use this output to improve their marketing performance?

Please share your workings and assumptions made. The goal of this task is to understand how you approach solving a problem with data.

Dataset link:

https://drive.google.com/drive/folders/1tlWx_xcbPhfJSNEYAeVB5vcozUSbF3DC?usp=sharing