Course Detail(DGT001 : Data Analytics for Public Sector Officers)

DGT001 : Data Analytics for Public Sector Officers

7.00 CPE Hours (Others)
Classroom


Formerly known as “ IA129: Data Analytics for Public Sector Officers ”

Programme Objective
This programme intends to provide public sector officers with an overview of how data analytics can be used to improve public sector governance and/or strengthen internal controls in the context of the public sector.
 

Programme Outline

Introduction
1.         Business case for data analytics 

1.1.      What is data analytics and why is it useful 
1.2.      Current and future trends in analytics
1.3.      Opportunities and challenges of data analytics
 
2.         Data analytics tools
2.1.      Caseware IDEA
2.2.      ACL
2.3.      Excel
2.4.      Others
 
Planning
3.         Using Analytics to understand the business process
3.1.      Determining audit objectives
3.2.      Understanding key controls
3.3.      Evaluation and testing of controls using analytics
 
4.         Identifying and Obtaining Data
4.1.      Data types and formats
4.2.      Common issues relating to access and importing of data
 
5.         Ensuring Data Quality of Imported Records
5.1.      Control totals check
5.2.      Hash checks
5.3.      Validity checks
5.4.      Reasonableness checks
5.5.      Range checks
 
Fieldwork
(Examples would be given in IDEA and Excel with dummy/sample data)
 
6.         Performing audit procedures using analytics
6.1.      Descriptive analytics
6.1.1.  IDEA - fieldstats
6.1.2.  Excel – number of rows (records), columns (fields), cell format type
6.1.3.  IDEA - summarise
 
6.2.      Detective analytics
6.2.1.  Framework for analyzing data and records
6.2.1.1.           Comparison across time (this period/last period)
6.2.1.2.           Comparison between functional units/departments
6.2.1.3.           Comparison against common sense (e.g. 365 days a year, overtime hours)
6.2.1.4.           Comparison by matching across different databases
6.2.2.  Time related data
6.2.2.1.           Aging analysis
6.2.2.2.           Stratification by time period
6.2.3.  Value related data
6.2.3.1.           Top/Bottom analysis
6.2.3.2.           Pareto analysis (80/20)
6.2.3.3.           Thresholds and percentages
6.2.4.  Text related analysis
6.2.4.1.           Keyword search functions
6.2.5.  Sample selection
 
6.3.      Analytical Procedures
6.3.1.  Purchases and Payments
6.3.2.  Payroll
6.3.3.  Fixed Assets and inventory
6.3.4.  Receipts and Revenue
 
6.4.      Predictive analytics
6.4.1.  Benford’s law
6.4.2.  Correlation and multi-variate analysis
6.4.3.  Caveats
 
7.         Investigative and due diligence analytics
7.1.      Framework and approach
7.2.      Useful analytical techniques
7.2.1.  Trend and pattern detection
7.2.2.  Matching across white and black lists (e.g. ACRA, AML)
7.2.3.  Text search
 
Reporting
8.         Audit Documentation
8.1.      ISACA IT Audit and Assurance Guidelines (G3 Use of Computer Assisted Tools)
8.2.      IIA Standards
8.3.      ISCA Standards
 
How to Get Started
9.         How to build your own analytics capabilities for your team
9.1.      People
9.2.      Process
9.3.      Technology
9.4.      Experimentation and iteration of better / granular tests


Training Methodology
Seminar style with illustrative examples
 
Closing Date for Registration
1 week before programme or until full enrolment
 

Intended For

This intermediate level programme is intended for Internal Auditors, Governance & Risk professionals, Accounting/Finance professionals working in public sector entities. Public Sector officers who are involved in managing public funds, improving public sector governance and/or strengthening internal controls will find this programme useful.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

04 Oct 2017 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Yoong Ee Chuan

Date & Time

13 Jun 2017 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Yoong Ee Chuan

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Yoong Ee Chuan, FCA (Singapore)

Ee Chuan is an experienced Head of Internal Audit in the public sector who is well versed in business process audits and IT security audits and reviews. He currently drives financial, compliance, value-for-money and internal controls audits as well as IT audits, reviews and investigations at Ngee Ann Polytechnic.

With 19 years’ experience in public sector auditing and assurance, he has detailed understanding of public sector procurement rules and regulations. He leverages on computer assisted audit tools and techniques such as IDEA (and ACL previously) for audit effectiveness and efficiency.

He is a Fellow Chartered Accountant (Singapore), Certified Information Systems Auditor, and Certified Information Security Manager.
 


Formerly known as “ IA129: Data Analytics for Public Sector Officers ”

Programme Objective
This programme intends to provide public sector officers with an overview of how data analytics can be used to improve public sector governance and/or strengthen internal controls in the context of the public sector.
 

Programme Outline

Introduction
1.         Business case for data analytics 

1.1.      What is data analytics and why is it useful 
1.2.      Current and future trends in analytics
1.3.      Opportunities and challenges of data analytics
 
2.         Data analytics tools
2.1.      Caseware IDEA
2.2.      ACL
2.3.      Excel
2.4.      Others
 
Planning
3.         Using Analytics to understand the business process
3.1.      Determining audit objectives
3.2.      Understanding key controls
3.3.      Evaluation and testing of controls using analytics
 
4.         Identifying and Obtaining Data
4.1.      Data types and formats
4.2.      Common issues relating to access and importing of data
 
5.         Ensuring Data Quality of Imported Records
5.1.      Control totals check
5.2.      Hash checks
5.3.      Validity checks
5.4.      Reasonableness checks
5.5.      Range checks
 
Fieldwork
(Examples would be given in IDEA and Excel with dummy/sample data)
 
6.         Performing audit procedures using analytics
6.1.      Descriptive analytics
6.1.1.  IDEA - fieldstats
6.1.2.  Excel – number of rows (records), columns (fields), cell format type
6.1.3.  IDEA - summarise
 
6.2.      Detective analytics
6.2.1.  Framework for analyzing data and records
6.2.1.1.           Comparison across time (this period/last period)
6.2.1.2.           Comparison between functional units/departments
6.2.1.3.           Comparison against common sense (e.g. 365 days a year, overtime hours)
6.2.1.4.           Comparison by matching across different databases
6.2.2.  Time related data
6.2.2.1.           Aging analysis
6.2.2.2.           Stratification by time period
6.2.3.  Value related data
6.2.3.1.           Top/Bottom analysis
6.2.3.2.           Pareto analysis (80/20)
6.2.3.3.           Thresholds and percentages
6.2.4.  Text related analysis
6.2.4.1.           Keyword search functions
6.2.5.  Sample selection
 
6.3.      Analytical Procedures
6.3.1.  Purchases and Payments
6.3.2.  Payroll
6.3.3.  Fixed Assets and inventory
6.3.4.  Receipts and Revenue
 
6.4.      Predictive analytics
6.4.1.  Benford’s law
6.4.2.  Correlation and multi-variate analysis
6.4.3.  Caveats
 
7.         Investigative and due diligence analytics
7.1.      Framework and approach
7.2.      Useful analytical techniques
7.2.1.  Trend and pattern detection
7.2.2.  Matching across white and black lists (e.g. ACRA, AML)
7.2.3.  Text search
 
Reporting
8.         Audit Documentation
8.1.      ISACA IT Audit and Assurance Guidelines (G3 Use of Computer Assisted Tools)
8.2.      IIA Standards
8.3.      ISCA Standards
 
How to Get Started
9.         How to build your own analytics capabilities for your team
9.1.      People
9.2.      Process
9.3.      Technology
9.4.      Experimentation and iteration of better / granular tests


Training Methodology
Seminar style with illustrative examples
 
Closing Date for Registration
1 week before programme or until full enrolment
 

Intended For

This intermediate level programme is intended for Internal Auditors, Governance & Risk professionals, Accounting/Finance professionals working in public sector entities. Public Sector officers who are involved in managing public funds, improving public sector governance and/or strengthening internal controls will find this programme useful.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Yoong Ee Chuan, FCA (Singapore)

Ee Chuan is an experienced Head of Internal Audit in the public sector who is well versed in business process audits and IT security audits and reviews. He currently drives financial, compliance, value-for-money and internal controls audits as well as IT audits, reviews and investigations at Ngee Ann Polytechnic.

With 19 years’ experience in public sector auditing and assurance, he has detailed understanding of public sector procurement rules and regulations. He leverages on computer assisted audit tools and techniques such as IDEA (and ACL previously) for audit effectiveness and efficiency.

He is a Fellow Chartered Accountant (Singapore), Certified Information Systems Auditor, and Certified Information Security Manager.
 

Upcoming Schedule

Registration is closed

Date & Time

04 Oct 2017 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 329.56
For Non-Members: $ 398.04

Programme Facilitator(s)

Yoong Ee Chuan

Venue

60 Cecil Street
ISCA House
Singapore 049709