Course Hero Logo

Illustration 59 dashboards with visualizations are

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 18 - 20 out of 30 pages.

ILLUSTRATION 5.9Dashboards with Visualizations Are Graphical Representations of Information and Data.181Critical299High201Medium245LowAll Tickets68%13%19%Satisfaction RateTickets by Status32.4%SLA Violations—AllTickets by Customer—AllSoftwareApplicationPCNetworkFacilitiesEmailPrinterSecurityPhoneMainframeFinancial SystemsRequestHRPharma EquipmentMedical EquipmentHardwareIT Service DeskTickets by Category—All Property050100150200SLA Violations by MonthCriticalHighMediumLowJanFebFebMarAprMayJunJulAugSepOctNovDec34.3%33.3%InGenCrawfordGlobexAviatoAxe CapitalRekallProperty of John Wiley & Sons, Inc. Not for general redistribution.
5-18CHAPTER 5Data Storage and AnalysisTABLE 5.5Auditing and Data AnalyticsType of AnalysisAudit Examples1. Descriptive(What is?)Three-way match for Purchasing:For the whole population of inventory purchases for the period, match the firm’s purchase order withthe firm’s receiving documentation and the vendor’s invoice. Agree the quantity per the invoice tothe quantity received and to the quantity ordered. Agree the price per the invoice to the price on thepurchase order. Then examine discrepancies and determine internal control deficiencies.2. Diagnostic(Why?)Three-way match for Purchasing:Descriptive analysis results revealed that 0.9% of the transactions were not subject to the three-way match.Drilling down to the data and investigating revealed that only one vendor and one accounts payablesupervisor were involved in these transactions. The supervisor manually approved the invoices for payment,without matching purchase orders and receiving documentation. This led to the discovery of a purchasingfraud scheme. The brother of the supervisor received payment for nonexistent purchases.3. Predictive(What will happen?)Allowance for Doubtful Accounts:Build a model to predict the amount of the allowance for doubtful accounts by using inputs such aspayment history, debt types, and industry norms. Compare this prediction to the balance in the ledger.4. Prescriptive(What should happen?)Inventory count:Use artificial intelligence, aerial photos from a drone, and counting software to identify and countinventory. An example would be counting cattle on a large farm. This count would provide a goodestimate of what the quantity should be in the inventory records.The Big Four public accounting firms all use audit data analytics. For example, Ernst &Young’s Helix includes a series of visual ledgers that allow auditors to follow the flow of trans-actions through all stages of the reporting process. The software flags suspicious transactions.Its dashboards are fully interactive. By clicking on the graphics, an auditor can drill down tothe underlying data.Table 5.5shows examples of audit data analytics for each of the four types of data analytics.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 30 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Johnson
Tags
Data Management, The American, Database management system

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture