DATA ANALYTICS I

1
DATA ANALYTICS I

• M. Popowits
• Actg 537

2
What is Data Analytics?

• Process of systematically applying statistical
  and logical techniques to describe, summarize and
  compare data.
• Used extensively in auditing and fraud
  examination

3
Before your can do Data Analytics

• Must access client data connect to it and query
  out what you need
• Transfer ODBC, Internet, Disk
• Store Where? Security? Access?
• Massage get data into useable form

4
Massaging Data

• Harmonize or convert file formats, units of
  measure, date formats, table structures

5
What is Data Analytics?

• Two Basic Types
• Exploratory looks for patterns, differences,
  matches and anomalies in data
• Airline ex. Are certain geographic locations
  more prone to lost luggage?
• Confirmatory confirm or reject whether expected
  patterns in data exist
• Airline ex. Are duty free sales on
  international flights increasing or decreasing on
  a per passenger basis?

6
What software is used in Data Analytics?

• Excel Access
• Audit Applications IDEA ACL
• Computer Forensics EnCase Forensic Toolkit
• Scripting Languages write your own programs in
  VB, Perl

7
What software is used in Data Analytics?

• Excel Access
• Audit Applications IDEA ACL
• Computer Forensics EnCase Forensic Toolkit
• Scripting Languages write your own programs in
  VB, Perl

8
MSExcel as Audit Software

• Familiar and readily available
• Has limitations
• Can only handle 65,000 records
• Does not document the auditors work
• Data can be changed in spreadsheet
• Cumbersome for some tests sampling
• Can read a limited set of file types

9
MSAccess as Audit Software

• Familiar and readily available
• Can handle larger data sets than Excel
• Has built-in functions better querying ability
  than Excel
• Has limitations compared to specialized software
• Does not document the auditors work
• Data can be changed in database
• Might be slower
• Must build functions that are automatic in IDEA
  or ACL

10
Access Excel

• Access
• Connects to company database and downloads
  (imports) data sets
• Provides powerful query ability
• Excel further processes data and presents
  results
• Pivot tables
• Graphs and Charts Trends and Histograms

11
Data Analytics in Access ExcelThe Basics

• So now lets assume the data has already been
• Accessed
• Transferred
• Stored
• Massaged

12
Data Analytics in Access ExcelThe Basics

• Data Import
• Data Profiling - Control totals to reconcile
  to financial records Field
  statistics - Stratification Profile

13
ENDDATA ANALYTICS

• M. Popowits
• Actg 537