Postings from the India IDEA data Analysis software users group

Hi,

Here is a short note on diagnosing and resolving errors in IDEA's Equation Editor.

The Equation Editor is IDEA's powerhouse of arithmetical, conditional, what-If, statistical computations.

While building equations/criteria/logic within IDEA's Equation Editor we may come across specific error states. The note below will help us understand the error states and resolve them appropriately.

Error State 1 - Invalid Parameter

Every condition statement must have three components - viz - Field, Arithmetical Operator and Value/Field

Hi,

Hi,

Hi,

Hi All,

The @Functions in IDEA are well distributed between Numeric, Character, Date and Time fields.

@Functions can be deployed through Field Manipulation for computations and / or through Extraction for condition based filters.

Listed below are a few @Functions which are most effective in Fraud Analytics.

@isini

Used to look for an occurrence of a word in a character field.

Example - @isini("gift", narration) will look for the word gift in a general ledger narration

@dow

Interesting posting on the India IDEA google groups.

Hi All,

I remembered an IDEA user mentioning that the greatest benefit which IDEA Software can provide to an organisation is its tremendous value proposition from hindsight to insight to foresight into any business process and the state of its internal controls.

Hindsight allows the IDEA user to examine historical issues like 'Was there an inventory outage?', 'What caused the outage - which controls failed to operate?', 'What loss did it result into?', 'What safeguards were placed to avoid recurrence of outages?'

Hi,

It would be interesting to take a look at the endless possibilities of Data Analytics which touches our lives on a daily basis. 

Your visit to a Super Market may trigger an email alert to your registered email account with the Tax Invoice/Cash Memo as a PDF file.

Now at the end of each month you have a bunch of PDF files representing multiple visits to the Market.

Using IDEA Software's revolutionary Report Reader, you can capture all the PDF files in IDEA as independent databases.

Hi All,

IDEA's Field Statistics property provides a summary of the statistical values and distribution characteristics for each numeric, date and time field in the active database.

Field Statistics is both a statistical snapshot and a data reconciliation tool. It instantly shrinks the data haystack, making it easier to reconcile totals, inspect value ranges and identify indicators of fraud and error.

Here are few interesting applications of Field Statistics to practical cases -

Hi All,

Hi All,

IDEA's Visual Script is versatile and dynamic in nature.

Lets say you have recorded a Visual Script for date wise, product wise, tenor wise, amount wise, constitution wise variation in interest on loans using Duplicate Key Exclusion.

Now you would like to extend the Visual Script to reflect the 'Max' and 'Min' interest on loans per combination of date, product, tenor, amount and borrower constitution using Summarization.