Here is a high-level proposal for developing a smart dashboard for executives and incident management, based on your requirements and the provided data.

initial commit