Have you ever stopped to think about it?
Gather your team for one day, decide what information you want, define KPIs, scorecards, metrics, etc ... Draw in a paper the structure of the report that you would like to have and the source where to get that data, what kind of graphics, with or without thematic maps, what time you want to receive on a daily basis and more ... Build your report for analysis of your business in only one file, build your dashboard. Get the most out of Excel and your team!