Buddy Functions in IDEA
Hi,
While IDEA Data Analysis Software is replete with a bevy of top notch features and functionalities, there are few features which I would like to call 'Buddy Functions' in IDEA which go well together in meeting the analytical purpose on hand.
Let us take a look at some of these 'Buddy Functions' over a few posts.
(a) Top Records Extraction and Aging
Top Records Extraction falls under the Extract category in the IDEA menu toolbar while Aging falls under the Categorize group in the IDEA menu toolbar.
Top Records Extraction allows the IDEA user to extract the last known incident of an event from a group like the last instalment credit date on a credit facility.
Aging when applied to the Top Records child file allows the user to profile the records into buckets based on the last known incident of an event from a group like aging the last instalment credit date against a credit facility into 0-30, 31-60....180 and more. Its the 180 and more which would feature in our list of red flagged borrower classification.
In our next post we will take a look at Duplicate Key Exclusion and Summarization
Kind Regards
Jairam
Another follow-up from Jairam
Another follow-up from Jairam.
Hi,
Hi,
Hi,
Field Statistics and Stratification are two features in IDEA which can be applied in tandem to study distribution of values and outliers for numerical data sets in any active database.
Field Statistics generate 'Minimum', 'Maximum' and 'Average' statistics for numerical fields in any active database.
Take an example of 'Minimum', 'Maximum' and 'Average' statistics for 'Transaction Amount' in a General Ledger. The Field Statistics reveal a 'Minimum' of Rs. 5,000 an 'Average' of Rs. 45,000 and a 'Maximum' of Rs. 12,50,000
Using these statistics, an IDEA user can apply Stratification to create intervals/buckets of 5000-50000, 50000-95000 and 95000 +
The subjective intervals in the Stratification are based on the logic of the 'Average' being Rs. 45,000. Using the 'Average' of Rs. 45,000 intervals are created from 5000 to 50000, 50000 to 95000 and 95000 + (all having uniform stratum intervals of Rs. 45,000)
** please note you can also apply variable intervals.
The Stratification result reveals an ABC-analysis (High-Medium-Low Pareto Analysis) of 'Transaction Amount' values in the General Ledger.
Kind Regards
Jairam
A follow up post from Jairam
A follow up post from Jairam
Hi,