Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

closed as off-topic by Kin, RolandoMySQLDBA, Shawn Melton, Mark Storey-Smith, Paul White Dec 29 '13 at 23:12

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Tip of the iceberg - the question or comments reveal an underlying issue that would need extensive investigation by a consultant or database vendor support team: issues like this do not fit the SE Q&A model well. For more information see this meta post." – Kin, RolandoMySQLDBA, Shawn Melton, Mark Storey-Smith, Paul White
If this question can be reworded to fit the rules in the help center, please edit the question.

You probably need to be much more specific, the expected datatypes of the measures and so fourth, to get particularly useful answer to this. Most importantly, what do you wish to do with the data once it has been collected? The sort of reports and other output you need can have quite an effect on what sort of structure is optimal. – David Spillett Dec 29 '13 at 11:36
Hi David, Thanks for your prompt response. Ideally we will collect the data from our business partners and end of day we will prepare org level dashboard. (For example) We will show what is the AHT/Abandon rate for the business unit/Vericals/Division wise. – Krishna Dec 29 '13 at 16:29