Course Information
Successful Audit Data Analytics
Parking for SAO, Professional Development courses is in Garage B (1511 San Jacinto Blvd.). The Garage signage may read 1511 San Jacinto or Garage B. The elevator in Garage B is not reliable. If you are unable to walk the stairs, please contact the professionaldevelopment@sao.texas.gov for alternate parking arrangements. Handicapped parking is free at the meters around the downtown area.
A course coordinator will Email you a parking permit prior to the course start date. A permit must be displayed or you will be ticketed.
Course Description
In this two-day seminar attendees will learn everything needed about effectively integrating data analytics, or CAATs (Computer Assisted Audit Techniques), into an audit process. You will learn how technology can be used to more efficiently and effectively achieve desired results and brainstorm analytics across most major business cycles. You will learn how to progress from basic analytics into a fully automated/repetitive mode, and learn the basics of Continuous Auditing. We will review common hurdles and hear how the most successful organizations in the world have been able to exploit the power of data analysis to achieve visible and sustainable value.
Whether you are in audit management, directing a team where you may never personally use the technology, or the person who will ultimately be performing data analysis techniques, this seminar provides critical experience. Participants in audit management will learn how to design effective strategies and programs to ensure sustainable results. Those who will play a hands-on role with analytics programs will get the opportunity to work on real-world scenarios with sample data files. Each participant will practice designing effective tests and critiquing and QAing the work of others.
As the course progresses, you will move quickly from understanding basic analytic techniques such as stratifications, summarizations, and duplicate identification into more advanced techniques such as fuzzy matching, Benford’s Law, and statistical and regression analysis. You will explore cutting-edge topics such as visual analytics, risk score carding, and spatial analysis. Regardless of the tool you currently use or plan to use in your department - whether generic like MS Excel or MS Access, audit-centric like ACL or IDEA, or more IT-oriented like SQL or SAS - the standard pseudo-code used throughout the course will allow you to easily take what you have learned and quickly code it in your tool of choice. Participants are encouraged to bring a laptop to practice techniques on real data files using their tool of choice.
Course Objectives
Upon completion of this course, participants will be able to:
-
Integrate data analytics into the audit process
-
Understand the use of data analytics across key businesses cycles
-
Avoid common data analytics mistakes
-
Understand the pros and cons of popular analytics products
1. The Business Case for Audit Analytics
• industry benchmarks/guidance
• challenges with traditional audit process
• success stories and common benefits
2. Integrating Data Analytics across the Audit Process
• enterprise risk assessment
• audit planning
• fieldwork and testing
• reporting
• follow-up and monitors
3. Pros and Cons of Common Data Analysis Tools
• MS Office: MS Excel, MS Access
• Excel add-ins: TeamMate Analytics, ActiveData
• audit-centric client/server: ACL, Arbutus, IDEA, InfoZoom
• statistically-based: SPSS, SAS, R
• IT-centric: SQL, Alteryx, Lavastorm
• business intelligence: Cognos, Business-Objects, PowerBI
• specialized: SAP
• dashboarding: Tableau, Qlikview, Spotfire, Lumira
4. Analytic Development Cycle
• program strategy and approach
• analytic planning and design
• data access and validation
• coding/development
• testing/QA
• implementation and optimization
• process differences for ad-hoc vs. continuous testing
5. Planning for Data Access
• understanding various data access techniques
• effective negotiation with IT
• data verification procedures
• data security and retention
6. Exploring Data Access Options and File Types
• native database tools
• ODBC
• flat/delimited files
• adobe PDF reports
• unstructured data
7. Common Analyses in Major Business Processes
• Record-to-Report (R2R)
• Purchase-to-Pay (P2P)
• Forecast-to-Stock (F2S)
• Order-to-Cash (O2C)
• Hire-to-Retire (H2R)
• Process-to-Application (P2A)
8. Advanced Analytic Design Techniques
• complex string comparisons
• address comparisons
• fuzzy matching techniques
• trending
• Benford’s analysis
• smarter sampling techniques
• statistical and regression analysis
9. Verifying Standard Data
• employee SSNs
• vendor EINs
• vendor TINs
• zip codes
• area codes
• address abbreviations
• credit card numbers
10. Leveraging External Data Sources
• OFAC list
• US Postal Service address standards
• SIC codes
11. Developing Appropriate Standards
• code documentation
• requirements definition
• data verification
• QA and testing
• security and archiving
12. Making Analytics Repetitive
• scripting and automation
• design considerations
• automating data access
13. Moving towards Continuous Auditing
• strategy considerations
• effect on audit process
• changes to data extraction and analytic logic
14. Common Implementation Hurdles
• getting management buy-in
• dealing with false positives
• strategies for disparate systems
• international issues
• incongruent processes/policies
• outsourced IT
• external and cloud-based data
15. People and Process Issues
• organizing the team
• developing and maintaining skills
• prioritizing analytics
• measurement and KPIs
16. Reporting and Interpreting Results
• presenting results in a meaningful way
• overlapping results
• analytic precision
17. Advanced Topics and the Evolution of Analytics
• continuous monitoring
• dashboard and visual analytics
• score carding
• predictive analytics
• spatial relationships and mapping
Instructors
CISA, CITP, CPA, CGMA
Steve Biskie is a Director at RSM, one of the largest accounting and consulting firms in the world. Prior to joining RSM, he was co-founder and Managing Director of High Water Advisors, a consulting firm focused on helping organizations improve governance, risk management, compliance (GRC) and audit processes. Mr. Biskie was formerly the President of ERP Audit Solutions and Customer Solutions Director at ACL Services, Ltd. He specializes in helping organizations improve governance, risk management, compliance (GRC) and audit processes. A leader in the audit and compliance space for more than 20 years, Mr. Biskie has become most well-known for his work helping Fortune Global 500 organizations understand and manage the risks within complex ERP systems such as SAP and Oracle. He is a thought leader and strategic expert on implementing high-value, sustainable analytics and continuous auditing programs.
Steve started his career as an external auditor for Deloitte & Touche (Deloitte), where he was first exposed to data analytics. He was a part of the team that developed Deloitte’s first statistical inventory cycle- counting applications. He became proficient with Easytrieve, SAS, MS Access, and ACL during the period, and eventually developed Deloitte’s first extensive data analysis routines for SAP system audits. He has since gained experience with Alteryx, Arbutus, BusinessObjects, Qlikview, Tableau, and TeamMate Analytics. His expertise in data analytics eventually led his hiring by ACL Services, where during his more than five year relationship, he re-designed ACL’s training and consulting strategy, and managed many of ACL’s largest and most strategic client consulting initiatives within both Fortune 100 and public sector clients. Always a proponent of smarter auditing through the use of data analysis, Mr. Biskie has been speaking on the topic of continuous auditing and monitoring for more than a decade, including multiple keynote presentations on the topic. He is the course author for the Successful Data Analytics course offered through MIS Training Institute.
Additional Information
TAC Rule 523.142(g) requires the CPE Sponsor to monitor individual attendance and assign the correct number of CPE credits. Participants will be asked to document their time of arrival and departure in compliance with this Rule. Additionally, attendance will be monitored throughout the day and CPE certificates will reflect actual attendance of each participant.
If you are making travel plans to come to Austin, we recommend making "refundable" air and hotel reservations or waiting until 14 days before the class to actually book your reservations. Courses are occasionally canceled or rescheduled due to low enrollment. We determine whether a course has enough participants 16 days prior to the course date. If we cancel or reschedule, we will email the participant and his or her billing contact no later than 14 days before the original class date.
The course coordinator will contact you with parking information. Handicapped parking is free at the meters around the downtown area.
Vending machines with Coca-Cola products and various snack items are available. There is also a refrigerator and microwave in our coffee bar area. Feel free to bring in your own drinks and food if you prefer.
You might want to bring a light sweater or jacket, as room temperatures vary.
To see answers to our Frequently Asked Questions, visit http://www.sao.texas.gov/training/faq.html.