I would like to start a discussion about how you do or how would you do benchmarking in GoodData. I would like to provide my customers which are in the same business some comparison of some key metrics against aggregated data from all customers / industry standard.
I was playing with a dummy model and data and it seems that something simple as second dataset with the aggregated data works well:
Is this a good approach? Anything you would recommend me?
Hello Robin, yes this is good approach - this is exactly how you do benchmarks in GoodData - add a new dataset into which you load aggregated data from all the customers and connect this dataset to the rest of your model by a “shared dimensions” - those by which you want to benchmark. This will allow you as well as your users with ad-hoc permission to use the benchmark data.
A few notes to it for some best practices:
Hello Michal H.
Thank you very much for your reply. I am glad that I put together something meaningful. Actually it was logical and also easy to create.
I really appreciate the tips you mentioned. I am already working on a prototype and so far it goes well. I had to make some changes in the model, but it will allow me benchmark by different attributes. It was really great advice! I am looking forward to finish it and release it for testing.