Consolidating Until You Can’t

If you’re building similar reports for multiple audiences, it may make sense to consolidate some of this work into a single report that all the audiences use. Benefits of having a single report include less maintenance, more consistency, and scalability. It’s always advantageous to consolidate into one report when you can, but what about when the requirements get complex?

There is a break-even point when a consolidated dashboard/report is doing too much customization and the maintenance would be less by just breaking the reports out as they become too complex. It’s more of an art than a science but if you’re finding yourself thinking “if I make this change for A it’s going to break the same report for B”, it may be the right time to break these out into their own reports.

A Daily Email From Me

Give me a couple minutes of your day and I promise to provide thought-provoking messages to help you level up your BI knowledge and run more successful data projects.

A Daily Email From Me

Subscribe to get daily tips/ideas for how to best run a data project.

    We won't send you spam. Unsubscribe at any time.