General discussion

Hi there,
I would like to know whether IDEA could integrate with Ms.Outlook, example like, let say after I finish off my analysis and come out with the result, I could actually import it to the file that I wish to and finally integrate with my Outlook and send to my boss / team member for review.
I'm currently on v.9. Could it be happening via some script or have to wait for v.10?
Best regards, William.
 

Good day,
 
I would like to share my experience using Excel Multi-Select Dialog Box (MSDB) in IDEA.
First – some background. Probably the best places to learn how MSDB should work are here:
http://www.wiseowl.co.uk/blog/s209/type-filedialog.htm
and here: ( plus a useful example of how to use the File Dialog object)

The US General Accounting Office has just posted blog on big data that might be of interest to some users.

I just found this video on the business insider on Benford's law.  Gives some of the background on how it works.

There are a couple of new books out for IDEA.  One is "Fraud and Fraud Detection" by Sunder Gee who is one of my friends and a long-time IDEA user, trainer and consultant.  If you are having difficulty coming up with ways to use IDEA on your data you should pick-up a copy of the book as it will be a great help.

I just saw on Mark Nigrini's facebook page that there was a Wall Street Journal article last week on Benford's Law that quoted him.  You can find the article here.

For anyone who doesn't know Mark Nigrini, he is one of the father's of how we currently use Benford's Law and also has worked with IDEA on their Benford's Law routines and advanced analytical analysis.

I have a very annoying issue with IDEA. I'm importing tables through SQL server and the dates come as numeric, a 6 digit number that starts with 7.
I realize there are a gazillion functions to convert numeric to date, but none of those actually work. They run but I end up with "ERROR" in place of the date records, in the date fields. 
Any other solution mentioned here or by IDEA doesn't work. But the issue can be fixed in Access or SQL Server, but not within IDEA.

IDEA has recently released several videos on Benford's analysis, giving you the history, pratical applications and how to use Benford within IDEA.  You can find the videos here.

For anyone new that wants to join the site, I have had change the settings so that I now have to authorize any new members.  The reason for this is that the site has been flooded with false applications for users that want to flood the forums with spam.  By doing this I hope that these spam users will not get access to the site to post their spam.  If I happen to delete someone who wants to join the site please contact me directly and I will set you up.  Sorry for any inconvenience.

Caseware Analytics has just put out a series of videos taped at the 4th Annual North American Users Conference.  There are several videos from users and leaders within the industry.  You can find the videos here.