We are currently working on project to get KPI metrics from out account partners,We want to design a table and It will have
3 Major Business units 4 Business Verticals (Service Desk, Knowledge Management,..) 20 divisions (Messaging, Application Management,..)
Ideally we will be receiving KPI metrics from the divisions on daily basis.
Right now we have 20 metrics like (AHT, Abandon rate, etc) this might go upto 80 metrics. We want to set up a table in such a way it has to accommodate data and easy to retrieve.
Note: Each Division will be having different metrics.