4 ms·
I am not a specialist of this field but here is how I would deal with this problem: My understanding is that it is possible to find the main components (items,
by JPLeRouzic 7y ago
I am not a specialist of this field but here is how I would deal with this problem:
My understanding is that it is possible to find the main components (items, regions, etc) in a dataset, for example with PCA [0]. However it will not name those components, but it might be quite easy to infer the name of each component.
Once you know the data in one component, you can find their min/max.
I guess there are several similar mathematical techniques to do the same job and there are also several user friendly Business Intelligence software.
[0] https://en.wikipedia.org/wiki/Principal_component_analysis https://en.wikipedia.org/wiki/Principal_component_analysis
- akudha 7y agoIf I had a CSV, I can import it into a database and simply run queries, systematically, isn't it?
- JPLeRouzic 7y agoYou can alway do that, the question is (as the other comments told) "will your users get meaningful answers?" You could simply use Excel (it has PCA) also to test your ideas. There are many resources on Internet.