getting more from idea - idea data analysis · ardent advocate of computer assisted audit...

Getting More from IDEA

James Loughlin – AuditWare Systems Ltd

4th November 2019

Introductions

James Loughlin

▪ Head of Technical & Training Services

▪ Joined AuditWare Systems in 2009 as a software trainer and technical consultant,

▪ Background in data analytics.

▪ Heads up the Technical and Training areas of AuditWare Systems, steering the changes of direction in CAATS education and services.

▪ Ardent advocate of Computer Assisted Audit Techniques and Tools, providing varying levels of training and consultancy, as well as speaking at various events on the benefits of audit analytics.

Introductions

AuditWare Systems

• Established in 1987, AuditWare helped to introduce and develop computer assisted audit techniques to the UK and Ireland, and is a national leader in supplying the most powerful data analytics software available, globally.

▪ Provided solutions to audit professionals for more than 30 years

▪ Trained over 30,000 professionals

▪ Consulting team with extensive experience and best practice knowledge

▪ Targeted focus on Audit, Tax, Finance, Fraud, Risk and Compliance - Continuous Monitoring.

Introductions

CaseWare Family

EngagementManagement

Risk ManagementFinancialReporting

Data Analytics

Monitoring

CaseWare Solutions

IFRS, GAAP, GASB, XBRL, SAP ETL, P2P, O2C, Purchasing Cards, Payroll & HR, Fraud Management, Collaboration, Revenue Assurance, Reconciliations, Continuous Auditing and Monitoring

Introductions

CaseWare Product Suite

Why do users like IDEA?

• Imports data from a number of differing sources into a single format

• ETL tools

• Protected environment

• “Point and click” functionality

• Audit focused data analysis features

• Data visualisation capabilities

• Speed improvements over conventional Data Analysis software

• Comprehensive audit trail

• Automation functionality

How can users get more from IDEA?

• Applying the software to as many “data rich” audits as possible

• Further training – advanced concepts, business process specific, etc…

• Dedicated Guides – Business Applications for IDEA, Analytics for External Auditors

• CaseWare Passport – videos, tutorials, webinars, whitepapers

How can users get more from IDEA?

IDEA Script Apps:

• Accumulated Total• Add Benford's Law Z-Statistic• Add Date• Age Calculator• Amounts by Month• Append All Databases• Calculate Maximum Value• Coefficient of Variance• Convert a Numeric Date Value to Date

Format• Copy Header Information• Count Words in a Text Field• Cross Join

• Database Creation• Export Delimited• Export Multiple Databases• Export Multiple Databases to Access• Export Multiple Databases to Access

2007• Export Multiple Databases to Excel• Extract File Name from Database Name• Fill Down• Fill Gaps• Find Name and Path for the Active

Database• Fuzzy Match

How can users get more from IDEA?

IDEA Script Apps:

• GDPR Compliance Checker• GEL 1 Test• GEL 2 Test• Get ASCII Character Code• HTML Table Import• IDEAScript Manager• Import a DBF File• Import Multiple Excel Worksheets• Import Multiple Files• Mail IDEA Database• Mail Multiple IDEA Databases• Median• Message Box with Timeout

• Minimum and Maximum Ratio Analysis• Mod Calculations• Multi-line Text Box Example• Multiple Folder Join• Number Duplication Test• OLE Example• Payment Date vs Due Date• Percentage• Progress Bar• Raising Errors• Random Date Sampler• Refresh the File Explorer• Relative Size Factor Test

How can users get more from IDEA?

IDEA Script Apps:

• Review Status• Running Index Total• Same, Same, Different Test• Same, Same, Same, Test• Setup Dialog• Simple Database Copy• SQL Server Exporter• String Concatenation• Subroutine Example - Difference• Subroutine Example - Square Root• Text Search• Top Extraction Exclusion• Unicode to ASCII

• VLookup• Z-Score

IDEA Script Apps

How can users get more from IDEA?

IDEA Lab Apps:

• Outliers (Machine Learning – OVSM, LOF, Isolation Forest)

▪ Machine Learning (ML)

• Unsupervised (unlabelled data)

• Supervised - (labelled data)

• Reinforced

Pic Credit: Linked IN | Machine Learning vs Deep Learning

How can users get more from IDEA?

IDEA Lab Apps:

• New Apps:

▪ Currency Converter

▪ Fuzzy Join

▪ Python Profiling

▪ Range Join

▪ Word Find

IDEA Lab Apps

How can users get more from IDEA?

SmartAnalyzer Apps▪ SmartAnalyzer Automated Reporting Framework

How can users get more from IDEA?

SmartAnalyzer Apps

• SmartAnalyzer Financials App (57 Tests)

New SmartAnalyzer Apps

• CaseWare Audit Solutions (180 Tests):▪ Accounts Payable

▪ Expense Controls

▪ Fixed Assets

▪ General Ledger

▪ Inventory Controls

▪ Journal Entries

▪ Payroll Controls

▪ Procurement

▪ Travel

• Exceptional Exceptions

New SmartAnalyzer Apps

Thank you for your time.

Any Questions?