Build the matrix into the data warehouse where it can be used with an SSRS or Power BI.

I find the mega matrix useful however I need to modify it to remove information that is not required, such as secondary roles not applicable to the departmental matrix. It would be good to be able to set the matrix to how you would like it so that you could just run an updated version each week, rather then have do do that same modifications. The multiple tabs makes it not user friendly to the end user, nor print friendly