On this page

Analyze and assess audit data anomalies using data visualization techniques

By: Xia Li 1
1Yunnan Technology and Business University, Kunming, Yunnan, 650000, China

Abstract

The purpose of this paper is to analyze the use of big data visualization technology in the audit project, combined with the importance of visual analysis technology in the audit project to explore and the advantages of visual analysis technology in the audit project. By drawing on the application of visual analytics in government auditing, the TF-IDF algorithm is used and improved to a keyword classification method based on the TF-IDF-MP algorithm, which extracts the core vocabulary in the text to be audited, clarifies the focus of the audit, and achieves the purpose of improving the efficiency of the auditor’s work. Compare the classification accuracy of the improved method with the common text classification methods in the public dataset. Take the internal audit of enterprises as an example to analyze the application of big data technology in the company’s sales business audit and expense audit. The purchasing volume of Z products in each month from January 2023 to September 2023 was screened using SQL statements. Predict the value of the company’s purchasing expenses expenditure for the following three quarters. Comparing the predicted values with the true values, the rate of difference is less than 4%, which concludes that there is no anomaly in the company’s expense spending.