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
Tech Tip: Transforming Your Data
May 15 We are inundated with data on a daily basis. Here are a few time-saving tips for transforming your raw or jumbled data into useful information.   Adding...
Task Automation Using IDEA
Apr 16 Audit scenarios rarely require an entirely unique process. Having a preferred set of tests ready to go is a great time saver, but that can be further improved i...
Gain Productivity with RPA
Apr 16 Leaders of professional associations are urging auditors to embrace emerging technologies to advance the industry, create audit efficiencies and manage organiza...

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