IDEA Basics: Identifying Missing Days with Gap Detection
IDEA Data Analysis has, for many years, offered users the ability to use Gap Detection to test for gaps in date sequences based on dates falling on working or weekend days. This has been one of the more invaluable ways that IDEA helps to identify issues with data completeness and integrity. That said, the…
Read MoreIDEA Basics: How to use Join to combine two databases
Join is one of the most powerful capabilities within IDEA Data Analysis Software as it provides an easy to use and flexible way to combine multiple databases into a single dataset. It is used mainly for two reasons: Combining fields from two databases into a single database for analysis. For testing data which matches…
Read MoreHow do you use IDEA Data Analysis? – Technology Usage Survey 2019
6 Essential Steps to Implementing Data Analytics in Internal Audit
Data about your organization can be a powerful tool, and internal auditors are increasingly taking advantage of a variety of technologies like IDEA Data Analysis to incorporate data analytics in their audits. Yet, the use of data analytics can easily go awry if the insights that they bring to the decision-making process are not properly…
Read MoreIDEA 10.3 – What’s New?
CaseWare Analytics has now launched the latest version of IDEA® Data Analysis software, and this release offers a multitude of new features and general improvements designed to help make your audits run even more smoothly and efficiently than ever before. Take a peek at the top new features available in IDEA 10.3, including faster load…
Read MoreWhy You Need to Prepare Your Data
“When you’re cooking, preparation is an essential step. Ingredients need to be collected, peeled, marinated and put where you will be able to reach them when the oil is hot or the oven reaches the right temperature,” says Data Informed guest author, Bernard Marr, “this is also true in any business analytics and intelligence-driven process.”…
Read More5 ethics principles for Data Analytsts
Big Data is big. That much is obvious. What might not be so obvious is just how powerful and error prone it can also be. Susan Etlinger of Altimeter Group noted in her 2014 TED talk that “we can process exabytes of data at lightning speed, which also means we have the potential to make…
Read MoreDark data: You have the data, but do you need it?
Big Data equals big opportunities for organisations of all sizes. In fact, organisations that utilise data analytics in their decision-making process have a 5-6% better output, on average, than those who rely on experience and intuition. Lack of awareness has a part to play for this figure not being higher. The common misconception is that Data analytics is only suitable…
Read MoreThere is a 99% chance of an auditor being sued if fraud is not detected
The UK government last year estimated that the level of fraud in government spending represented just 0.02% of its total expenditure. Excluding tax credit and benefit fraud, the government detected between £27.6m and £72.9m in fraud out of its £306bn total expenditure in 2014/15. The National Audit Office’s fraud landscape review, however, found that there is…
Read More