Hi Shivakumar,
It really depends on how many metrics there are and how much normalization is needed. If its a simple set of one record with say 20 metrics, it should not take more than a few hours, but if its a set of records with say 50 fields in each, it can take up to a week or 2.
How many metrics did you have in mind?
Regards
Jitesh