220 likes | 236 Views
Detecting the Undetected – Fraud Detection Analytics at Carnival. Daniel Bukowski, CPA, CIA, CFE. Age- nda. Carnival Background Data Analytics for Internal Audit Identifying Non-PO Vendor Risk Alteryx Workflows Questions. Carnival Corporation&plc. Application of Data Analytics.
E N D
Detecting the Undetected – Fraud Detection Analytics at Carnival Daniel Bukowski, CPA, CIA, CFE
Age-nda • Carnival Background • Data Analytics for Internal Audit • Identifying Non-PO Vendor Risk • Alteryx Workflows • Questions
Application of Data Analytics Stippich, W.W., & Preber, B.J. (2016). Data Analytics: Elevating Internal Audit’s Value. Altamonte Springs, FL: IIA Research Foundation
The AuditorMindset You want to take my Excel…? Alter This!
‘Alter’The AuditorMindset Auditors Excel Alteryx
Cluster Analysis • Unsupervised machine learning • Identify latent relationships in the data • Principle components • Identify outliers
Cluster 8 Cluster 8 Centroid Cluster 8
Summary Data analytics with Alteryx enables internal audit to: • Do more, faster • Share processes visually • Automate manual processes • Analyze data at a greater level of detail • Focus manual procedures on the most important areas
Daniel J Bukowski • dbukowski@carnival.com • www.linkedin.com/in/danieljbukowski • Please complete a • feedback survey! THANKYOU
Non-PO Vendor Risk Review Project Goal: Identify the highest-risk vendors within the vendor populations of each Carnival operating company • Alteryx: Convert manual, sample-based procedures into an automated, repeatable workflow that analyzes entire populations 2017 Scope: 10k vendors, 275k invoices, over $2bn spend