The time is over for off-the-shelf products, when you can take a solution and use its components to conveniently build analytical reports. Limitations force us either to use poorly designed products or to develop dashboards ourselves.
Have you chosen the second way? So, I’m going to tell about stages of dashboards development analysis. Defining the set of indicators, visualisations, types of dashboard calculations and the required features for the user on the dashboard.
My experience will be useful both to those who have never experienced dashboard development and don't know where to start, and to those who do it often. Perhaps you will reconsider your approach somewhere or find valuable ideas for yourself.