I prepared dynamic KPI and productivity reporting models with Excel and Power BI. The models provide a general view for weekly business reviews and senior management reporting, while allowing performance to be reviewed at person and line level when needed.
I prepared the reports so weekly and senior management reviews could use the same definitions. The models were designed to give weekly and senior management reviews a shared starting point.