Webclass 98: What are the most popular data analytics tools today for internal audit?

Q1. According to 6Sense.com, which data analytics tool had the most market share?

Tableau

Correct Incorrect Correct answer

QLIK

Correct Incorrect Correct answer

Q2. When looking at blogs on “Best data analytics tools” which data tools were mentioned the most often?

Tableau, PowerBI, Google, ApacheSpark, Data Wrapper, R, Excel, QLIK, python, Knime

Correct Incorrect Correct answer

PowerBI, Tableau, QLIK, ACL, IDEA, Alteryx

Correct Incorrect Correct answer

Q3. Why would be important to consider if you need your data to be Cloud/ On-Premise?

Because you might not be allowed to move data outside of your VPN

Correct Incorrect Correct answer

Because working in the cloud is slower

Correct Incorrect Correct answer

Q4. What might be the inconvenience of using a free tool?

Lack of support, restrictions on size of data, missing functionalities, lack of future developments

Correct Incorrect Correct answer

Free tools can only be used in the cloud

Correct Incorrect Correct answer

Q5. Is python a good tool for large data sizes or will you be restricted?

Python can work on any data size as long as the hardware and operating system specifications are sufficient

Correct Incorrect Correct answer

Python becomes paid when you want to analyze large data sets

Correct Incorrect Correct answer

Q6. Is PBI free?

The "free" verson of PBI desktop comes with Microsoft 365, however, when we want to analyze very large data sets, we need to get the paid version or pay for an SQL server installation to support it

Correct Incorrect Correct answer

Yes, PBI is free

Correct Incorrect Correct answer

Q7. What is the difference between an audit management tool and a data analytics tool?

An audit management tool is more used for planning audits, managing follow-up of action plans, managing workflows and centralizing audit documentation

Correct Incorrect Correct answer

An audit manageemnt tool is used to show the results of data analytics

Correct Incorrect Correct answer

Q8. What is maybe the most important consideration when choosing a tool?

Will it be supported in five years' time?

Correct Incorrect Correct answer

Does it make the most beautiful graphs

Correct Incorrect Correct answer

Q9. What are the main steps to find flip-flop IBAN?

1/ Append CDPOS_VALUE_OLD to CDPOS_VALUE_NEW to obtain a list of all values 2/ Add the change document header information 3/ Create a table of all combinations of values per 3rd party 4/ Filter on change date/time 1< change date/time 2 5/ Identify where 3rd party + value 1+ value 2 = 3rd party + value 2+value 1 6/ Filter on change date/ time 1<change date/time 3 AND change date/ time 2<= change date/ time 3

Correct Incorrect Correct answer

Load the change document header and change document detail tables into the data visualization tool and create graphs through drag and drop interface to show the flip-flop cases

Correct Incorrect Correct answer

Q10. What did the participants think was the most complex part of the case-study?

Understanding the data and determining logical steps that need to be done

Correct Incorrect Correct answer

The programming language

Correct Incorrect Correct answer

Q11. How might chatGPT replace data analysts?

ChatGPT can help us to make the program quicker, however, when using it, we currently need to guide it carefully as to the logical steps that need to be carried out, based on our understanding of the data and the fraud case we are looking for. The code from ChatGPT will need to be rewritten to make it simple, easy to maintain and following the organizations naming convention standards and documentation standards.

Correct Incorrect Correct answer

ChatGPT can write the program completely for us, we just need to say "flip-flop IBAN for SAP data" and ChatGPT will produce the code and logical steps in any programming language

Correct Incorrect Correct answer

WC098 – What are the most popular data analytics tools today for internal audit?

Quizzes

Participants 13

Webclass 98: What are the most popular data analytics tools today for internal audit?

admin June 9, 2026

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question