The 21st Minute


Moving Forward with Data Analysis

Software Selection Guide

While data analysis tools have been around for more than 25 years, the rate of adoption is growing exponentially due to the amount of data auditors are required to analyze. The use of data analysis technology is part of a bigger movement to help auditors increase audit coverage, perform more thorough and consistent audits, and ultimately increase assurance levels. There are numerous technologies to choose from, and this guide offers some assistance in selecting the right professional-grade data analytics tools for your department. Follow the step-by-step process to narrow your choices, then complete the Software Selection Matrix.

Data Analysis Process

The components of a robust data analysis tool

Software Selection Matrix

  1. Use your needs analysis to rank the different features available in most professional data analysis tools. Need: 0=Needless; 1=Nice to Have; 2=Desireable; 4=Mandatory
  2. Rank your top 3 software selections based on the features available. Rank: 0=Doesn’t satisfy requirements; 2=Satisfies; 4=Surpasses
  3. Multiply the Need times the Rank to determine the Score of the software in each category. (Need x Rank = Score)
  4. Total the scores in each category to get a weighted score.
  5. Total the final scores for each category. The software with the highest total is the best fit for your company.

CaseWare IDEA , Tech Tip

Posted By


Related Posts
Give Python a Go
Mar 29 Python is considered the official programming language for non-programmers. It gives you increased flexibility and expansive access to your data. For those usin...
Unconventional Analysis
Jan 24 Data is often underutilized. The opportunity to use data analytics to gain insights, add more value and unravel opportunities are endless. We’ve rounded u...
5 Avenues for Importing Data into IDEA
Nov 21 One of the greatest benefits to CaseWare IDEA is the sheer amount of data it can read and make universally consumable – both in file types and in data...

This website has been designed for modern browsers. Please update. Update my browser now