You are currently browsing the archives for the Data Classification category.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Nov | ||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | 31 | ||||
- Audit sampling (7)
- Audit Software (17)
- Data Classification (6)
- Data Extraction (12)
- Data Validation (16)
- Data Validation and conversion (1)
- Database (2)
- Database functions (1)
- Error identification (3)
- Excluded Providers (1)
- Validation (3)
- Web Log Analytics (3)
- November 22, 2008: Planned charting software
- November 22, 2008: Release of stand-alone version of Audit Commander (1.61)
- April 22, 2008: Version 1.56 released, as well as articles
- February 23, 2008: Release 1.52 of the XL Audit Commander is available
- November 27, 2007: Version 1.42 released, handles CSV and print files, has help
- October 28, 2007: What's new in version 1.36
- October 5, 2007: XL Audit Commander version 1.32 released
- September 2, 2007: Three articles on audit topics
- June 29, 2007: Establishment of "Auditor's Corner"
- June 3, 2007: A more efficient way to perform audit procedures from within Excel
Archive for the Data Classification Category
Planned charting software
November 22, 2008 by Mike.Blakley.
Version 1.62 of Audit Commander will contain charting abilities for histograms, basic population statistics, Benford’s Law, round numbers, day of week statistics, holidays and more. Details are available for viewing as a PDF document.
Posted in Data Classification, Audit Software | No Comments »
Version 1.56 released, as well as articles
April 22, 2008 by Mike.Blakley.
Version 1.56 includes faster sorting speeds for files of up to 2 billion rows with sorting by up to 200 columns. Also included is the ability to run XL Audit Commander using either Excel macros or through the Windows Scripting Host. A paper on the topic is available which describes the process. An Excel macro workbook named Macros.xls is included with the installation software. Note that version 1.56 is required in order to run these macros or scripts. The setup program (11.9 MB) is available for download.
Hope to see you at the IIA Fraud Forum in Bonita Springs, FL on May 16th. Topic is the use of digital analysis for the detection of fraud patterns.
Posted in Data Extraction, Data Classification, Audit Software | 2 Comments »
Release 1.52 of the XL Audit Commander is available
February 23, 2008 by Mike.Blakley.
Support is now provided for both comma separated value format files (CSV), as well as “print” files through the use of file specifications. Further information is available. Also, there are now a variety of tutorials available in shockwave format to demonstrate the system in action. Information about system limitations is now available.
Posted in Data Extraction, Error identification, Audit sampling, Data Classification, Audit Software, Data Validation and conversion, Data Validation | 1 Comment »
Version 1.42 released, handles CSV and print files, has help
November 27, 2007 by Mike.Blakley.
The latest version, released 11/24/2007, includes support for CSV files and “print” files and also includes a “help” button on the forms screen. Further, there are several examples demonstrating its use: 1) interval sampling, 2) testing Benford’s law in MS-Access database, 3) Data Stratification and 4) Date checking. Other examples and articles have been added.
A demo of the system is available for viewing.
Posted in Data Extraction, Audit sampling, Data Classification, Audit Software | No Comments »
Establishment of “Auditor’s Corner”
June 29, 2007 by Mike.Blakley.
I have established a web page devoted to sharing articles and ideas on IT auditing. Part of it consists of tutorial modules as shown below. Some are VBA classes for use within Excel, others pertain to use of the XL Audit Commander.
| General Audit Topics | ||||
| Module | Description | Approx Length | With Quiz? | Last Update |
|---|---|---|---|---|
| Module-1 | Obtaining Basic Population Statistics | 15 minutes | Yes | 06-22-2007 |
| Module-2 | Audit uses for Benford’s Law | 15 minutes | Yes | 06-22-2007 |
| Module-3 | Use of histograms in audits | 15 minutes | Yes | 06-23-2007 |
| Module-4 | SQLite as an Audit Tool | 30 min | No | 06-29-07 |
| Module | Description | Approx Length | With Quiz? | Last Update |
| Module-5 | Beyond the COUNTIF and SUMIF functions | 20 min | No | 06-25-07 |
| Module-6 | A work-around for very large files | 20 min | No | 06-29-07 |
| Module-7 | Identifying duplicates and gaps in large files | 20 min | No | 06-29-07 |
| Module-8 | Sizing up the population - Going to Extremes | 20 min | No | 06-29-07 |
Posted in Data Extraction, Data Classification, Audit Software, Data Validation | No Comments »
Classifying data in Excel
January 20, 2007 by Mike.Blakley.
Two common audit procedures are to classify data by their frequency of occurrence and to determine if there are any duplicate items. Often, this data may reside within an Excel spreadsheet. Both procedures can be done manually within Excel - for example by first sorting the data, doing subtotals, etc. However, this procedure can be both time consuming as well as error prone.
Here I discuss how this can be done very quickly, and I provide example procedure steps and screen shots of the results.
A simple procedure for stratifying data in Excel:
Select the menu item “data stratification” .
Select the Excel work book
Select the work sheet
Select the work sheet
Select the column of interest - i.e. data to be stratified.
Specify the stratification values to be used
Click the “Run” button to produce the chart.
Note there is also a text file produced that can be pasted into Excel to see the results as text. There is no charge for the software - it may be used for any purpose, including commercial and educational.
More info is available.
Posted in Data Classification | No Comments »