Litigation Data Analysis/Auditing/ETL for BI: Triples Separated at Birth

This paper shows how the steps in Litigation Data Analysis (hereafter Litigation Analysis), Auditing and Extract-Transform-Load for Business Intelligence (ETL for BI, or data warehousing for business data analysis) are inherently similar; it is just the emphasis and time spent on each step that varies, based on the participant’s goal. This is due to the commonality of the underlying principles of “Truth, ” Reproducibility and Time-Invariance (also seen as Time-Invariant). If the process is flawed, or if the data or processes are “out of sync, ” one with the other, then any subsequent decision based on that data or process is without merit. The paper will also cover the issue of time series data, and some of the problems it poses for each function. With more and more companies needing to meet the IS Audit Standard SAS 70 (and any/all of the other 90+ general plus numerous specialty) audit standards, with ever increasing numbers of lawsuits, and continuing pressure to get the “right data ” at “the right time ” for decision making, you need to get to the fundamentals or you truly are “betting the firm ” that you are ready for anything from a new data warehouse through an audit to presenting your corporate defense in court