|
Overview of IDEA Data Analysis
Software Version 8.4 with Case Studies
Case Studies Presentation by Jairam
Rajshekhar
Recognizing skewed patterns arising out of
circumvention of threshold ordering limits leading
to improved fraud detection through the
application of Benford’s Law.
Drawing an optimum sample base randomly for ledger
scrutiny based on the materiality of transaction
amounts in different segments or strata using
Stratified Random Sampling.
Measuring the linear relationship between two
variables like seasonal sales for a given branch
of a FMCG compared to company wide sales using
Correlation tools.
Automating repetitive tasks and building
macros for inventory control checks without any
programming experience making the process more
efficient.
Auto escalation of real-time exceptions arising
out of reviews to Process Owners through mail
exchange giving early warning signals to officials
who need to take action.
Identify fictitious vendors or employees in Master
batch files.
Performing Google like search capabilities on Bank
Customer Master data to filter accounts opened
with prohibited party names thus improving KYC
processes.
Making a complex multi-line Fixed Assets ledger in
a PDF form conformable to Asset Scrutiny for tests
of valuation and existence.
Sharing of practical tips through the IDEA Google
Group and IDEA Open House on a continuous basis |
