My experience is that ascertaining exactly what the report consumer wants to see on a dashboard report is, by far, the most difficult part of the process.
Often the consumer would want a visual way to confirm a vague feeling. By the time a data team can ascertain what the consumer actually needs to see, collects and wrangles the data, and builds the dashboard, the consumer may have lost interest or become frustrated and moved on.
Identifying a feeling and graphically representing it with data is an extremely difficult thing which led me to a place of great despair at a previous job.
Anyway, I don't have a good answer for this but I hope you can crack it and become wildly successful doing so!
Often the consumer would want a visual way to confirm a vague feeling. By the time a data team can ascertain what the consumer actually needs to see, collects and wrangles the data, and builds the dashboard, the consumer may have lost interest or become frustrated and moved on.
Identifying a feeling and graphically representing it with data is an extremely difficult thing which led me to a place of great despair at a previous job.
Anyway, I don't have a good answer for this but I hope you can crack it and become wildly successful doing so!