Help on visualization

[Hugo99]

Dears

I want to display 6-8 KPIs for a retail business with about 100 branches. The KPIs should be displayed in line or bar charts, such as: #clients, revenue, #new clients, #product1, #product2, etc - everything over time (month, quater)

I can produce every chart on it's own, but i struggle to generate a usable and fancy dashboard out of that.

The user should be able filter/slice by: branch, period in time. Since we do have ~110 branches the slicer takes most of the screen, if i want to avoid scrolling trough the elements. a second slicer for period clutters up the screen even more.

Do you have any suggestion or example of a dashboard, which is easy to use and still clear despite a large amount of filters?

tnx!

[Sergii24 · Accepted solution]

Hi @Hugo99, it's hard to give an advice without spending some time to learn your data model and report requirements. I suggest you to search for ideas online: there are a lot of dataviz experts on LinkedIn (one of my favorite is https://www.linkedin.com/in/anhleimer/). Once you find what you like, try to design it (even in PowerPoint) and then, if you struggle with implmenting some part of it, let us know and the community will be glad to help you!

For instance, you're talking about slicer that takes most of the screen: you can use dropdown list with search function that helps to solve this problem. In case you have many filters, you can hide all of them using bookmark to obtain a similar result:

Good luck with your project!