Building executive dashboards leadership actually opens

A dashboard nobody opens is usually not a data problem - it was built to display information rather than to support a decision. Those are different briefs, even when treated as one.

Work backward from the decision: what does leadership need to decide this week, and which three numbers inform that decision? Everything else is a candidate for removal.

Keep it to one screen. Once it requires scrolling, it is functionally two dashboards for two audiences, built as one.