220 likes | 241 Vues
Dive into how data analytics with tools like Alteryx elevate internal audit's value, specifically in identifying non-PO vendor risk at Carnival Corporation & plc. Learn how to automate manual processes, analyze data in depth, and focus on crucial areas.
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