Course Detail(DGT057v : Analytics for Accountants and Auditors (Live Webinar))

DGT057v : Analytics for Accountants and Auditors (Live Webinar) NEW

7.00 CPE Hours (Others)
Live Webinar

This course is available in both Live Webinar (virtual) and Classroom (physical).

For this session, it will be delivered as LIVE WEBINAR. If you prefer to join the Classroom session, please register here.

Programme Objective

This workshop will provide accountants and auditors with the understanding of the concepts and frameworks in using data analytics in their own business domains. Participants will be able to combine data analytics techniques with existing tools such as Excel or Google Sheets to enhance the efficiency and effectiveness of their day-to-day processes. Participants will gain from experiential learning in applying data analytics tools and techniques to common use cases in accounting and related processes.

 

Programme Outline

1.    Business Case for Data Analytics (DA) for Auditors and Accountants

1.1.    What is data analytics and why is it useful for you
1.2.    Current and future trends in analytics
1.3.    Opportunities and challenges of data analytics
1.4.    Availability of DA Tools/Techniques (e.g. Excel, Google Sheet, Caseware IDEA, ACL)


2.    Data Analytics Approach to Business Processes

2.1.    DA Framework
2.1.1.    Identifying and obtaining data
2.1.2.    Extract-Transform-Load
2.1.3.    Data storage/staging
2.1.4.    Analysis
2.1.5.    Reporting/Visualisation


3.    Identifying and Obtaining Data

3.1.    Data availability
3.2.    Data integrity
3.3.    Data confidentiality


4.    Extract-Transform-Load

4.1.    Export/importing data
4.2.    Preparation for analysis
4.3.    Loading to storage/staging


5.    DA Approaches

5.1.    Descriptive analytics
5.1.1.    Statistical descriptors (e.g. mean, media, mode, deviation)
5.1.2.    Control totals
5.1.3.    Field types
5.2.    Diagnostic analytics
5.2.1.    Types of comparisions
5.2.1.1.    Across time (this period/last period)
5.2.1.2.    Between functional units/departments
5.2.1.3.    Against reasonableness (e.g. 365 days a year, overtime hours)
5.2.1.4.    Matching across different databases
5.2.2.    Time related data
5.2.2.1.    Aging analysis
5.2.2.2.    Stratification by time period
5.2.2.3.    Date of the week / public holidays
5.2.3.    Value related data
5.2.3.1.    Statistical, arithmetic and computational accuracy
5.2.3.2.    Top/Bottom analysis
5.2.3.3.    Pareto analysis (80/20)
5.2.3.4.    Thresholds and percentages
5.2.4.    Text related analysis
5.2.4.1.    Keyword search functions
5.2.4.2.    Keyword frequency
5.2.5.    Sample selection

5.3.    Predictive Analytics
5.3.1.    Benford’s law
5.3.2.    Correlation and multi-variate analysis
5.3.3.    Caveats

5.4.    DA for Accounting and Related Processes
5.4.1.    Purchases and Payments
5.4.2.    Payroll
5.4.3.    Fixed Assets and inventory
5.4.4.    Receipts and Revenue
5.4.5.    Due Diligence, Conflicts of Interest Checks


6.    Fraud and Investigative Analytics

6.1.    Framework and approach
6.2.    Useful analytical techniques
6.2.1.    Trend and pattern detection
6.2.2.    Matching across white and black lists (e.g. ACRA, Anti-Money Laundering)
6.2.3.    Text search


7.    How to build your own analytics capabilities for your team

7.1.    People
7.2.    Process
7.3.    Technology
7.4.    Pilot Projects / Proof-of-Concept

 


The workshop would include interactive elements such as hands-on activities with Excel/Google Sheet and online quizzes and polls (using online tools e.g. Slido or equivalent) to facilitate reflection and encourage participants to learn from one another’s experiences in their respective areas of work.

 


Training Methodology

Lecture style with exercises / case studies 

Closing Date for Registration
1 week before programme or until full enrolment.

Intended For

Accountants, Controllers, Finance Managers, Internal / External Auditors and All Accounting Professionals.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

15 Jun 2021 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Yoong Ee Chuan

Venue

Online Classroom in or outside of
Singapore

Date & Time

15 Dec 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 345.61   $ 276.49
For Non-Members: $ 415.16   $ 332.13
Discount till 31 Dec 2021

Programme Facilitator(s)

Yoong Ee Chuan

Venue

Live Webinar in or outside of
Singapore

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.
 

This course is available in both Live Webinar (virtual) and Classroom (physical).

For this session, it will be delivered as LIVE WEBINAR. If you prefer to join the Classroom session, please register here.

Programme Objective

This workshop will provide accountants and auditors with the understanding of the concepts and frameworks in using data analytics in their own business domains. Participants will be able to combine data analytics techniques with existing tools such as Excel or Google Sheets to enhance the efficiency and effectiveness of their day-to-day processes. Participants will gain from experiential learning in applying data analytics tools and techniques to common use cases in accounting and related processes.

 

Programme Outline

1.    Business Case for Data Analytics (DA) for Auditors and Accountants

1.1.    What is data analytics and why is it useful for you
1.2.    Current and future trends in analytics
1.3.    Opportunities and challenges of data analytics
1.4.    Availability of DA Tools/Techniques (e.g. Excel, Google Sheet, Caseware IDEA, ACL)


2.    Data Analytics Approach to Business Processes

2.1.    DA Framework
2.1.1.    Identifying and obtaining data
2.1.2.    Extract-Transform-Load
2.1.3.    Data storage/staging
2.1.4.    Analysis
2.1.5.    Reporting/Visualisation


3.    Identifying and Obtaining Data

3.1.    Data availability
3.2.    Data integrity
3.3.    Data confidentiality


4.    Extract-Transform-Load

4.1.    Export/importing data
4.2.    Preparation for analysis
4.3.    Loading to storage/staging


5.    DA Approaches

5.1.    Descriptive analytics
5.1.1.    Statistical descriptors (e.g. mean, media, mode, deviation)
5.1.2.    Control totals
5.1.3.    Field types
5.2.    Diagnostic analytics
5.2.1.    Types of comparisions
5.2.1.1.    Across time (this period/last period)
5.2.1.2.    Between functional units/departments
5.2.1.3.    Against reasonableness (e.g. 365 days a year, overtime hours)
5.2.1.4.    Matching across different databases
5.2.2.    Time related data
5.2.2.1.    Aging analysis
5.2.2.2.    Stratification by time period
5.2.2.3.    Date of the week / public holidays
5.2.3.    Value related data
5.2.3.1.    Statistical, arithmetic and computational accuracy
5.2.3.2.    Top/Bottom analysis
5.2.3.3.    Pareto analysis (80/20)
5.2.3.4.    Thresholds and percentages
5.2.4.    Text related analysis
5.2.4.1.    Keyword search functions
5.2.4.2.    Keyword frequency
5.2.5.    Sample selection

5.3.    Predictive Analytics
5.3.1.    Benford’s law
5.3.2.    Correlation and multi-variate analysis
5.3.3.    Caveats

5.4.    DA for Accounting and Related Processes
5.4.1.    Purchases and Payments
5.4.2.    Payroll
5.4.3.    Fixed Assets and inventory
5.4.4.    Receipts and Revenue
5.4.5.    Due Diligence, Conflicts of Interest Checks


6.    Fraud and Investigative Analytics

6.1.    Framework and approach
6.2.    Useful analytical techniques
6.2.1.    Trend and pattern detection
6.2.2.    Matching across white and black lists (e.g. ACRA, Anti-Money Laundering)
6.2.3.    Text search


7.    How to build your own analytics capabilities for your team

7.1.    People
7.2.    Process
7.3.    Technology
7.4.    Pilot Projects / Proof-of-Concept

 


The workshop would include interactive elements such as hands-on activities with Excel/Google Sheet and online quizzes and polls (using online tools e.g. Slido or equivalent) to facilitate reflection and encourage participants to learn from one another’s experiences in their respective areas of work.

 


Training Methodology

Lecture style with exercises / case studies 

Closing Date for Registration
1 week before programme or until full enrolment.

Intended For

Accountants, Controllers, Finance Managers, Internal / External Auditors and All Accounting Professionals.

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

Date & Time

15 Dec 2021 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 345.61   $ 276.49
For Non-Members: $ 415.16   $ 332.13
Discount till 31 Dec 2021

Programme Facilitator(s)

Yoong Ee Chuan

Venue

Live Webinar in or outside of
Singapore