data analytics i l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
DATA ANALYTICS I PowerPoint Presentation
Download Presentation
DATA ANALYTICS I

Loading in 2 Seconds...

play fullscreen
1 / 14

DATA ANALYTICS I - PowerPoint PPT Presentation


  • 168 Views
  • Uploaded on

DATA ANALYTICS I. M. Popowits Actg 537 . 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 . Before your can do Data Analytics….

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'DATA ANALYTICS I' - sherine


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
data analytics i
DATA ANALYTICS I

M. Popowits

Actg 537

what is data analytics
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
before your can do data analytics
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
massaging data
Massaging Data
  • Harmonize or convert file formats, units of measure, date formats, table structures…
what is data analytics5
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?”
what software is used in data analytics
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
what software is used in data analytics7
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
msexcel as audit software
MSExcel as Audit Software
  • Familiar and readily available
  • Has limitations
    • Excel 2003 can only handle 65,000 records; Excel 2007 does not have this limitation
    • Does not document the auditor’s work
    • Data can be changed in spreadsheet
    • Cumbersome for some tests: sampling
    • Can read a limited set of file types
msaccess as audit software
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 auditor’s work
    • Data can be changed in database
    • Might be slower
    • Must build functions that are automatic in IDEA or ACL
access excel
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
data analytics in access excel the basics
Data Analytics in Access & ExcelThe Basics

So now let’s assume the data has already been:

  • Accessed
  • Transferred
  • Stored
  • “Massaged”
data analytics in access excel the basics12
Data Analytics in Access & ExcelThe Basics
  • Data Import
  • Data Profiling - Gets Control Totals to reconcile to financial records (IDEA calls these “Field Statistics”) - Stratifies Data

- Why to we stratify?

- To get subgroups that are more homogeneous than the total population

- we may test subgroups differently

histograms
Histograms
  • An excellent charting technique to get an overview of data frequency
end data analytics i
ENDDATA ANALYTICS I

M. Popowits

Actg 537

Demo