General discussion

After over a year I finally wrote a new blog post.  I need time to do more of these.  So this blog is about how to localize your script.  I would enjoy any comments you might have it.  You can find the link on the front page.

This slideshow shows the differences between using Excel and a Data Analytics Tool like IDEA.

https://www.slideshare.net/slideshow/embed_code/48485593

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.