Open Framework, Information Management Strategy & Collaborative Governance | Data & Social Methodology - MIKE2.0 Methodology
Wiki Home
Collapse Expand Close

Members
Collapse Expand Close

To join, please contact us.

Improve MIKE 2.0
Collapse Expand Close
Need somewhere to start? How about the most wanted pages; or the pages we know need more work; or even the stub that somebody else has started, but hasn't been able to finish. Or create a ticket for any issues you have found.

Benford's Law

From MIKE2.0 Methodology

Share/Save/Bookmark
Jump to: navigation, search

Benford's Law has some interesting applications to Data Quality. The following is a presentation delivered to the ARK Group's "DQ Asia Pacific 2009" conference in Sydney, Australia (March 2009). This is a relatively non-technical yet practical look at the background to Benford's Law and how it can be applied in every day data analysis/data quality activities. It has particular relevance to anyone interested in identifying possible fraud events and also for extending data quality profiling to identify possible errors in data transformation and data migration. A simple method for its application using Microsoft Excel, is also provided, along with real examples of the application of the technique to large data warehouse extracts (6.5 million records), GL record extracts (60,000 records), and even to a small (less than 1,000 record) data set, i.e. the author's own credit card transactions.

Wiki Contributors
Collapse Expand Close