gavin steinberg angus gray ian craigen - satori group · gavin steinberg angus gray ian craigen ......
TRANSCRIPT
![Page 1: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/1.jpg)
Gavin Steinberg Angus Gray Ian CraigenManaging Director NZ BDM Senior Consultant
![Page 2: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/2.jpg)
The Satori Group
Started in 2002 and 23 employees in the team
Offices in Sydney, Melbourne, Wellington, Pune (India)
Territory covers Australia, New Zealand and South
Pacific Islands
Partnership with Prodigy Group (Singapore, Indo, Phil,
Malaysia)
Over 400 corporate clients in our region
Over 40 clients in New Zealand and growing
![Page 3: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/3.jpg)
The Satori Team Structure
Gavin
BFRAndrew Bond
Manura
Matt
Assurance Account Managers
Vic, ACT, Wellington, SP
Angus
NSW1Phil
NSW2, QLDTroy
New Business
SatoriCCM MS / EnvisageRobyn
ACL GRCPat
Analytics Project Delivery
Rebecca M
Analytics
Jehan
Ian
Nancy
Noris
Support
Jeffrey
Pentana Team
Denae
Andrew T
Jeff
Admin / Mkting / Training
Rebecca N
Pat
Trainers
Denae
FinanceOlga
Envisage DevDavid
AndyT Thai
![Page 4: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/4.jpg)
AFFCO Holdings Ltd. Airways New Zealand ANZ National Bank ASB Bank Auckland District Health Board Auckland University of Technology Audit New Zealand Bay of Plenty DHB Canterbury District Health Board Department of Conservation (NZ) Department of Corrections (NZ) Farmers Trading Company Fisher & Paykel Finance Limited Fletcher Building Limited (NZ) Fonterra Health Alliance Health Intelligence Inland Revenue Department Kiwi Bank Limited KPMG Wellington Lakes District Health
Ministry of Business, Innovation and Employment
Ministry of Education NZ Ministry of the Environment NZ Ministry of Health New Zealand Defence Force New Zealand Post New Zealand Racing Board New Zealand Trade and Enterprise New Zealand Transport Agency Nelson DHB NIWA Palmerston North City Council PGG Wrightson Southern District Health Board Talley's Group Ltd Telecom NZ Ltd Waikato District Health Board Wellington City Council …
![Page 5: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/5.jpg)
Our solutions
![Page 6: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/6.jpg)
Our Product Range
ACL
• ACL Analysis Desktop
• ACL Analysis Exchange (AX)
• SAP Direct Link
• ACL GRC-Risk-Project Manager-Results Manager
• EVA• AP• VM• EM• CC
Caseware Monitor
• Ver 3.3• Ver 4.0
Pentana
• PAWS 8.x• Vision 2.1• Retain
SatoriCCM
• Managed Services
• Hosted SAAS
• EVA• Specialised
Apps
BFR
• Envisage• proCube• Dundas• CDM
![Page 7: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/7.jpg)
Satori Offering
• Support• Managed Services
• Training• Services
Analytical Solutions
Audit Management
Continuous Monitoring
Budgeting, Forecasting,
Reporting and Visualisation
![Page 8: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/8.jpg)
![Page 9: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/9.jpg)
![Page 10: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/10.jpg)
Audit Dashboards
![Page 11: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/11.jpg)
![Page 12: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/12.jpg)
![Page 13: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/13.jpg)
Why Dashboards
Communicate what Audit is doing effectively
Give insight to management to data they cannot get
Raise Internal Audit profile
Share Audit insight with company
Great Insight into the business
Add significant value to business
Oversight on performance
Communication
![Page 14: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/14.jpg)
Strictly Confidential—not for distribution
![Page 15: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/15.jpg)
Dan Zitting, CPA, CISA, GRCPVP, Product Management & Design
Email: [email protected]: (212) 202-2183Twitter: @danzittingLinkedIn: http://www.linkedin.com/in/danzitting
![Page 16: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/16.jpg)
“INTEGRATED GRC” (100%)
ACL’s Customers: The IIA Three Lines of Defense Model
GRC FUNCTIONS (90%)
GRC STAKEHOLDERS
AUDIT (70%)
![Page 17: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/17.jpg)
17© ACL Services Ltd.ACL | Connections 2013
ACL Vision for Audit & Risk Technology
![Page 18: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/18.jpg)
Complete Technology Platform
Integrated RiskAssessmentIntegrated RiskAssessment
IntegratedContentIntegratedContent
Project & Controls Mgmt
Project & Controls Mgmt
Risk & ControlAnalyticsRisk & ControlAnalytics
![Page 19: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/19.jpg)
DATA ANALYSIS
• Ad-hoc analysis of data populations designed to detect transactions that manifest the occurrence of business risk
ENTERPRISE CONTINUOUS MONITORING
• Recurring analysis of transactional data designed to prevent occurrence of risk through identification of operational deficiencies or control gaps
GRC
• Management and measurement of risks and controls against business objectives in accordance with regulations, standards, policies and business decisions.
ACL’s 3 Core Value Propositions
Powered by…ACL Analytics Desktop
Powered by…ACL Analytics Exchange (AX)
Powered by…ACL GRC
![Page 20: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/20.jpg)
Transformational Value in Audit & Risk
“Data-Driven GRC”(GRC + DA + ECM)
“Data-Led GRC”(GRC + DA)
Data Analysis (DA)
Enterprise Continuous Monitoring (ECM)
GRC
![Page 21: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/21.jpg)
![Page 22: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/22.jpg)
Complacency may be the next biggest danger companies face in FY13/14
Annual Kroll Fraud Report 2012/13
![Page 23: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/23.jpg)
Reference: AuditNet Analytic Survey
What are the main obstacles preventing auditors from using audit analytics?
![Page 24: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/24.jpg)
Audit Analytic Capability Model
Sophistication
Audit
Con
tribu
tion
Hindsight
Insight
Foresight
ad hoc repetitive continuous
Level 1Basic/adhoc
Level 1Basic/adhoc
![Page 25: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/25.jpg)
Basic Sophisticated Once Off Analytics
Data Access & Acquisition
Analysis
Reporting
Challenges Data and access to data
Understanding of what to do
Time to do it properly
The software (typically last used 1 year ago)
Understanding the data and what / how to analyse the data
Typically once off
Don’t know what you are looking for until you find (need skill)
![Page 26: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/26.jpg)
Audit Analytic Capability Model
Sophistication
Audit
Con
tribu
tion
Hindsight
Insight
Foresight
ad hoc repetitive continuous
Level 2Applied
Level 2Applied
Level 1Basic/adhoc
Level 1Basic/adhoc
![Page 27: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/27.jpg)
A Variety of Analytic Techniques Calculation of statistical
parameters
Classifications
Stratifications
Digital analysis ie using Benford’sLaw
“Fuzzy Logic”
Duplicates testing
Gaps testing
Ageing
Control total summation
Joining and matching data fields
![Page 28: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/28.jpg)
Ranges of a Numeric Field
Groups transactions into specified ranges or strata of values
Show me the number of contracts within various strata of the contract amount fieldAmount Count Ave$
– $0 - $1,000 16,703– $1,001 - $49,999 19,650– $45,001 - $49,000 61,203– $49,001 - $50,000 4,251– $50,001 - $100,000 58– $100,001 - $1,000,000 4
![Page 29: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/29.jpg)
Totals by a Character field
Counts the number of unique values in a selected character field(s) and the corresponding totals of other numeric fields
Show me how many hysterectomy procedures have been performed, by gender:– Female: 127– Male: 3– [field blank]: 12
![Page 30: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/30.jpg)
2 Ratio Analysis
Unit Prices Item High_Price High_Price2 Ratio
#198 $101.46 $98.91 1.026#773 $123.48 $57.23 2.158#861 $ 51.23 $50.84 1.008#634 $ 26.31 $11.63 2.262
#992 $124.78 $124.03 1.006
![Page 31: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/31.jpg)
2 Ratio analysis
Apr May Jun Jul Aug Max 2Max RatioExpense 1 125 124 135 12,500 125 12,500 135 92.59 Expense 2 98 99 99 101 98 101 99 1.03 Expense 3 78.31 78.64 78.75 158.29 78.93 158.29 78.93 2.01
![Page 32: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/32.jpg)
Realisation
• Script Tests
• Beginning of specialisation
• Acceptance of AA
• Continuous Usage of AA
• Understanding of Data and ERP
tables
• Std Data requests for IT
• Structure around AA process
• Automation Beginning
![Page 33: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/33.jpg)
> Starts to become part of every Audit– Pre, during, post– Ability to repeat in an instant
> Yields results> Quality, trust output> Re-use and basis for extension of AA> ? What happens to output
Level 2 – Repetitive Analytics
![Page 34: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/34.jpg)
Audit Analytic Capability Model
Sophistication
Audit
Con
tribu
tion
Hindsight
Insight
Foresight
ad hoc repetitive continuous
Level 2Applied
Level 2Applied
Level 3Managed
Level 3Managed
Level 1Basic/adhoc
Level 1Basic/adhoc
![Page 35: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/35.jpg)
Managed AnalyticsSome subject Areas for Audit Analytics / Fraud Detection
Accounts Payable
Accounts Receivable
Bid Rigging
Credit Card Management
Deposits
General Ledger
Supplier Collusion
Loans
Inventory Control
Policy and Administration
Purchase Order Management
Retail Loss Prevention
Salaries and Payroll
Sales Analysis
Claims
Vendor Management
![Page 36: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/36.jpg)
Purchase to Payment CycleCritical Processes & Activities
![Page 37: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/37.jpg)
Match Standard Analytics against Payables Processes
![Page 38: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/38.jpg)
PayrollCritical Processes & Activities
Creating Employees Manage Payroll
Payroll Calculation Payments
•Create New Employee•Entering Employee Data•Referral Awards•Maintain Records prices
•Assign salary / Rate Grade•Approve Rates•Transfers and Promotions•Retirement & Termination –Discontinue Payroll &Benefits
•Modify Time & Attendance•Modify Overtime•Statutory Holiday Calculations•Calculate Banked Time•Deduction calculations•Payroll Exceptions•Commissions & Bonuses•R/T – Calculate Final Pay
•Generate Payments•Update Accrued Leave / vacation•Balances•Calculate Final Cycle Pay•Post Payroll•Transmit to service provider
•Enter Time•Approve Overtime•Approve Contractors•T&A Interfaces
Time & Attendance
![Page 39: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/39.jpg)
Standard Analytics against Payroll Processes
Creating Employees SOD: Enter Vs. Approve OFAC Employee Match Duplicate Employees Employee Vendor Match SOD: Update Vs. Approve Ghost Employees – PIN
Payroll Calculations SOD: Adjustment Vs. Approval Overtime Threshold Unauthorized Commissions Payroll Cut Off Dates SOD: Termination Enter Vs.
Approve Termination – New Hires
Manage Payroll Invalid Rate Terminated Employees –
Termination Date Terminated Employee –
Employee Status
Time and Attendance SOD: Time Entry Vs.
Approval Time Entry Vs. Expected
Hours Time Differentials
Payments SOD: Create Vs. Approve Duplicate Payments Suspicious Payments - Employee
Start Date Suspicious Payments – Phantom
Employees Service Providers – Two Way Match
![Page 40: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/40.jpg)
Level 3 : Managed Analytics
Multiple Scripts “Ready to go”
Centralised Server (need server technology)
Core experts, many different user skills levels
Accepted as part of every audit (pre, during, post)
ROI Massive (values, Efficiency, Effectiveness)
Increase in Budget
Other departments wanting some
![Page 41: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/41.jpg)
Audit Analytic Capability Model
Sophistication
Audit
Con
tribu
tion
Hindsight
Insight
Foresight
ad hoc repetitive continuous
Level 2Applied
Level 2Applied
Level 3Managed
Level 3Managed
Level 4Automated
Level 4Automated
Level 1Basic/adhoc
Level 1Basic/adhoc
![Page 42: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/42.jpg)
Automated Analytics - “Continuous Auditing”
•Secure and central environment
•Virtually limitless server processing power
•Automate analysis
•Integrated exception review
•“Self Service”
•Focus on results / exceptions
•Get exceptions sent to you
![Page 43: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/43.jpg)
Analytic Capability Model
Sophistication
Audit
Con
tribu
tion
Hindsight
Insight
Foresight Level 5Monitoring
Level 5Monitoring
ad hoc repetitive continuous
Level 2Applied
Level 2Applied
Level 3Managed
Level 3Managed
Level 4Automated
Level 4Automated
Level 1Basic/adhoc
Level 1Basic/adhoc
![Page 44: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/44.jpg)
Source – Ernst and Young ISACA presentation January 2008, Virginia USA
![Page 45: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/45.jpg)
ACL Product Updates
![Page 46: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/46.jpg)
Growing R&D Investment
0%
5%
10%
15%
20%
25%
30%
35%
2011 2012 2013
50% increase in R&D
Expanded analytics teams
Dedicated resources
55%30%
15%
Analytics ECM GRC
![Page 47: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/47.jpg)
GRC & Analytics Integration
ACL Desktop Audit Exchange
ACL Workpapers
ACL Analytics Analytics Exchange
ACL GRC:Project Manager
ACL GRC:Results Manager
ACL GRC:Risk Manager
ACL GRC: Risk Manager• Assess strategic risk and develop
mitigation efforts• Visualize risk in your
organizational landscape
ACL GRC: Results Manager• Receives analytic results directly
from ACL Analytics or AX• Integrate those results into the
GRC architecture, projects, and issue tracking
![Page 48: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/48.jpg)
AX 3.1
We’ve been busy @ ACL
Analytics 10
Enterprise (AX)
Workpapers 2
iPad
Desktop 9.3
Direct Link 4GB Analytics Exchange 4
AX 4.0.2
iPhone
Risk Manager
Results Manager
Project Manager
Data Analysis (Desktop) GRC
![Page 49: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/49.jpg)
![Page 50: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/50.jpg)
25+ Improvements
Date & Time
ACL Desktop becomes ACL Analytics Desktop Focus on increasing Analytic Capabilities Focus on improving Ease of Use
Product Update – Analytics v10
ExecutePerformance
Multiple Tables Integration
![Page 51: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/51.jpg)
ACL™ Analytics Releases
May 2013
v.10July 2012Fuzzy DuplicatesColour Script Editor
v.9.3Aug 2011Key field harmonization for JOINEnhanced Command LogExcel Import/Export
v.9.2Feb 2011Data Definition Wizard Improvements
v.9.1.8
April 2009
v.9.1.4May 2008
v. 9.1
May 2013
![Page 52: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/52.jpg)
![Page 53: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/53.jpg)
ACL Desktop 9.3
English language edition: 9.3.0 All other language editions: 9.3.1 Compatibility upgrade for AX Core 3.0, 3.0.1 and 3.1 New Script Editor Features - Line numbering, Colour
encoding, Colour encoding editing, Word Wrap Fuzzy Duplicates command (FUZZYDUP) - Used to
detect nearly identical values in a character field ISFUZZYDUP() Function - Returns a logical value
indicating whether a string is a fuzzy duplicate of a comparison string
![Page 54: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/54.jpg)
ACL Desktop 9.3 – cont.
LEVDIST() Function - Returns the LevenshteinDistance between two specified strings, which is a measurement of how much the two strings differ
OMIT() Function - Returns a string with one or more specified substrings removed
Resize all columns through right click menu Filter and command line functions in right click menu New Right Mouse click menu option-> Replace filter Current script being executed is displayed in the status
bar Addition of a ‘Run’ pushbutton in the Script Toolbar
![Page 55: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/55.jpg)
ACL Desktop 9.3 – cont.
‘Add table’ icon in toolbar ‘Display variables’ icon in toolbar New links on welcome page (product feedback,
customer survey, What’s New) Ability to delete a field from the table layout dialog or
command even if a view is open Warning message when deleting items from log using
right click Ability to change thousands and decimal separators
from within a script Field definitions with multi-line conditional fields written
to the log file can now be saved and run in a script
![Page 56: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/56.jpg)
Execute command New datetime data type and new functions to support Open multiple tables at the same time Export directly to Results Manager Performance improvements Defect corrections Improved user experience
ACL Analytics 10
![Page 57: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/57.jpg)
0 25 50 75 100 125 150 175 200
DuplicatesExport CSVExport XLS
ExtractImport CSV
Import ExcelIndex
JoinSampling
SortStatistics
Summarize
DT93 AA10
ACL Analytics 10 is the fastest version yet
![Page 58: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/58.jpg)
ACL Analytics 10 can now define and work with date and time data
Date and time data
19:20:307:20:30 PM2012-05-20T19:20:302012/05/20 7:20:30PM2012-05-20T19:20:30-08:00
![Page 59: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/59.jpg)
CTODT() - converts character or numeric value to Date and Time
CTOT() - converts character or numeric value to a Time
STOD() - converts serial Date to Date STOT() – converts serial Date to Time STODT() - converts serial Date to Date and Time DATETIME() - converts Date and Time to character
New functions
![Page 60: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/60.jpg)
NOW() - returns the current system time TODAY() - returns the current system date CMOY() - returns the name of the month for a specified
date EOMONTH() - returns the last day of the month GOMONTH() - returns the date X number of months
away
New functions
![Page 61: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/61.jpg)
YEAR() - extracts the year from a specified date MONTH() - extracts the month from a specified date DAY() - extracts the day of the month from a date HOUR() - extracts the hour from a specified Date and
Time MINUTE() - extracts the minutes from a specified Date
and Time SECOND() - extracts the seconds from a specified
Date and Time
New functions
![Page 62: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/62.jpg)
CTOD() TIME() DATE() AGE() CDOW() DOW()
Updated functions
![Page 63: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/63.jpg)
ACL Analytics 10 uses serial Datetimes to evaluate date and time values 42004 = January 1, 2015 42004.50000 = January 1, 2015 12:00:00 0.75000 = 18:00:00New functions help convert these into recognizable date and times: STOD() – Serial to Date STODT() – Serial to Date and Time STOT() – Serial to Time
Serial date and time
![Page 64: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/64.jpg)
Export to Results Manager
ACL Analytics 10 Results ManagerEXPORT
![Page 65: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/65.jpg)
EXECUTE Command
Used to execute an application or process external to ACL Analytics 10
Emulates the Windows Run command
![Page 66: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/66.jpg)
EXECUTE “Windows_Run_command_syntax” <ASYNC>
Command issued as part of a script ASYNC is Optional and specifies asynchronous
mode—the script will not pause and wait for the external process to complete
Creates a new system variable RETURN_CODE
EXECUTE Command
![Page 67: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/67.jpg)
Examples of EXECUTE Command Open other applications and perform tasks required by
the script Open any file in its default application Perform file and folder administrative tasks Run external scripts or non-ACL batch files (.bat) Pass parameters to a batch file Run scripts in other projects Incorporate waiting periods in scripts Access data from network locations
![Page 68: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/68.jpg)
Use FTP to access data from remote locations Zip or unzip data Encrypt or decrypt data Integrate with SQL databases Incorporate Active Directory account lists Integrate with VBScript Incorporate Windows task scheduling in scripts Open web pages
Examples of EXECUTE Command
![Page 69: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/69.jpg)
Utilities for ACL
ABNChecker AddressChecker DirectorChecker_4_NZ DirectorChecker_4_AUS ?? Other…
Value added Utilities– free if on annual support, will only work if license is current
![Page 70: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/70.jpg)
![Page 71: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/71.jpg)
ACL Analytics 10 is the evolution of ACL™ Desktop Look forward to hearing your feedback Development team is already working on the next
release of ACL Analytics 10.x, due to be released in six months
Summary
![Page 72: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/72.jpg)
Ask the Audience
Where would you like to see ACL improve?
– 1. Improved data access– 2. Improved free training for new / infrequent users– 3. Improved script development for power users– 4. Improved reporting and visualization tools– 5. New UI
![Page 73: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/73.jpg)
![Page 74: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/74.jpg)
![Page 75: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/75.jpg)
![Page 76: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/76.jpg)
![Page 77: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/77.jpg)
![Page 78: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/78.jpg)
![Page 79: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/79.jpg)
![Page 80: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/80.jpg)
![Page 81: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/81.jpg)
![Page 82: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/82.jpg)
![Page 83: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/83.jpg)
![Page 84: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/84.jpg)
![Page 85: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/85.jpg)
![Page 86: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/86.jpg)
![Page 87: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/87.jpg)
![Page 88: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/88.jpg)
![Page 89: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/89.jpg)
![Page 90: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/90.jpg)
![Page 91: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/91.jpg)
![Page 92: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/92.jpg)
V4.0.2
![Page 93: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/93.jpg)
File Server
DATA
DATA
DATA
Versus…
![Page 94: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/94.jpg)
ACL AX Solution
Managed Environment
SAP
ERP
AX Server
Data
ACL Desktop
MS Excel
Browser/Excel
![Page 95: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/95.jpg)
Secure Data Access
Secure, Managed Environment
Data
Data
ACL AX SERVER
DataVersus…
![Page 96: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/96.jpg)
ACL
Automation – Built-in Analytic Scheduler Server Analytic Processing Power
Content Management – Any File Type
Create analytics, perform ad-hoc analysis and remote analysis
Users access via Excel / Browser to run their own Analytics
Enterprise Data
SQL
ERP
Access virtually any data source and automate data feeds
AX Server
Manage the Exceptions
![Page 97: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/97.jpg)
Audit Exchange becomes Analytics Exchange Platform for Enterprise Continuous Monitoring Improved Organization, Reuse & Results
Product Update – Analytics Exchange v4
Archive/RestoreAPI
Analytic Results
Analytic Chains
Install / Config 25+ Improvements
![Page 98: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/98.jpg)
Automate Risk and Control Methodology – Project Manager
Provide Executive Relevance - Risk Manager (new!) Expanding the Reach of Analytics - Results Manager
(new!)
Product Update – ACL GRC
Data-drivenCloud
Context
Mobile
Alignment Value
![Page 99: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/99.jpg)
Benefits of AX
Automate data extraction from multiple sources Administer roles & access permissions Share all analytics & engagements Enhanced security in a server environment Schedule and automate recurring tests to detects
exceptions as they happen Assign & automate exception management workflow Report exceptions in interactive dashboards Conduct ad-hoc investigation on analytic results with
server power
![Page 100: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/100.jpg)
EVA Standard Suite of Analytical Tests
EVA for SAP ORACLE F1 …
VM
AP
CC
EM
Payroll
Inventory
SOD
![Page 101: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/101.jpg)
Technical Support (0800 AuditNet Online Training Audit Videos Account representative Satori Support
ACL Support
![Page 102: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/102.jpg)
![Page 103: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/103.jpg)
ACL GRC
• Cloud based Audit Management solution
• Central repository for all data and information
• Standardise workflow and methodology
• Increase efficiency and productivity
• Facilitates communication between team and other
stakeholders
• Low cost of Ownership / High ROI
![Page 104: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/104.jpg)
ACL GRC
Management tool for the complete audit cycle
3 Key Modules:• Risk Manager: Enterprise Risk Management• Project Manager: Electronic Workpapers, One Touch Reporting• Results Manager: ACL Analytics Integration, Exceptions
Management
![Page 105: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/105.jpg)
ACL GRC
![Page 106: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/106.jpg)
Risk Manager
Create your own Audit Universe
![Page 107: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/107.jpg)
Risk Manager
Risk Assessment
![Page 108: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/108.jpg)
Risk Manager
Graphical Visualisation
![Page 109: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/109.jpg)
Projects Manager
Overview for Audit Manager
![Page 110: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/110.jpg)
Projects Manager
Audit Log
![Page 111: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/111.jpg)
Projects Manager Time Keeping
Audit Planning
![Page 112: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/112.jpg)
Projects Manager Electronic Workpapers
![Page 113: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/113.jpg)
Projects Manager Customisable One Touch Reporting
– Data draws directly from ACL GRC
![Page 114: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/114.jpg)
Projects Manager Track-able requests to stakeholders
![Page 115: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/115.jpg)
Results Manager Integration with ACL Analytics 10, ACL Analytics Exchange
![Page 116: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/116.jpg)
Results Manager
Manage Exceptions
![Page 117: Gavin Steinberg Angus Gray Ian Craigen - Satori Group · Gavin Steinberg Angus Gray Ian Craigen ... Malaysia) Over 400 corporate clients in our region ... ACL GRC Pat Analytics Project](https://reader030.vdocuments.us/reader030/viewer/2022020315/5ac03eeb7f8b9add5f8eb9ce/html5/thumbnails/117.jpg)
Thank You!
www.satorigroup.com.au