Data Analytics and Fraud Risk Management: A New Reality for CPAs (On-Demand - CPA PRO)
Overview
Participants will learn a practical framework for using data analytics to surface anomalies, strengthen fraud-risk detection, and communicate findings clearly across common finance cycles. Participants will progress from scoping and data acquisition through analysis and visualization, applying approachable techniques that fit CPA workflows and resource constraints.
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, participants should be able to:
- Describe core data concepts (structures, field types, keys) and relate them to accounting cycles and fraud-risk use cases.
- Plan and scope a data-driven project (problem definition, hypotheses, data availability) and obtain “the right data in the right format.”
- Execute foundational data operations (join, append, summarize, filter/sort) and apply single-layer vs. multi-layer analyses to procurement, payroll, expenses, and journal entries.
- Anticipate and mitigate common pitfalls in data work (cut-offs, quality/validation issues) using repeatable practices.
- Present results effectively with visualization and storytelling principles tailored to executives and boards.
Content
Topics include:
- Why now: the CPA role in data and fraud-risk management; efficiency and accessibility drivers.
- Data foundations: structured data types, table relationships, and links to accounting cycles.
- Data extraction: scoping questions, request practices, cut-off considerations, and validation/quality checks.
- Analytics techniques: categorization, layering analyses, and targeted tests for procurement, payroll, expenses, and journal entries.
- Real-life mini-cases: end-to-end approach illustrated for two cycles.
- Visualization & storytelling: what not to do, best-practice chart types, and narrative framing.
Course Content Created: September 2025
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
Simon Castonguay, CPA, CAAbout This Product
On-Demand Courses by CPA PRO are either video recordings from live seminars, or video recordings produced specifically for the on-demand audience. Where available, accompanying materials such as handouts or course notes are included.On-demand courses are eligible for verifiable CPD hours upon successful completion, and a certificate will be made available for download for your records.
Note that some courses comprise both formal instruction and self-directed exercises. In such cases, participants must complete both components to claim full CPD hours, or must reduce their reported CPD hours accordingly.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
- 3.5
- CPD Hours
- 1
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
Data Analytics and Fraud Risk Management: A New Reality for CPAs (On-Demand - CPA PRO)
- 3.5
- CPD Hours
- 1
- Ethics Hours
- 0
- AML Hours
- 5
- Credits
Overview
Participants will learn a practical framework for using data analytics to surface anomalies, strengthen fraud-risk detection, and communicate findings clearly across common finance cycles. Participants will progress from scoping and data acquisition through analysis and visualization, applying approachable techniques that fit CPA workflows and resource constraints.
Access expires 180 days from purchase date |
Applicable for
Learning Objectives
By the end of this course, participants should be able to:
- Describe core data concepts (structures, field types, keys) and relate them to accounting cycles and fraud-risk use cases.
- Plan and scope a data-driven project (problem definition, hypotheses, data availability) and obtain “the right data in the right format.”
- Execute foundational data operations (join, append, summarize, filter/sort) and apply single-layer vs. multi-layer analyses to procurement, payroll, expenses, and journal entries.
- Anticipate and mitigate common pitfalls in data work (cut-offs, quality/validation issues) using repeatable practices.
- Present results effectively with visualization and storytelling principles tailored to executives and boards.
Content
Topics include:
- Why now: the CPA role in data and fraud-risk management; efficiency and accessibility drivers.
- Data foundations: structured data types, table relationships, and links to accounting cycles.
- Data extraction: scoping questions, request practices, cut-off considerations, and validation/quality checks.
- Analytics techniques: categorization, layering analyses, and targeted tests for procurement, payroll, expenses, and journal entries.
- Real-life mini-cases: end-to-end approach illustrated for two cycles.
- Visualization & storytelling: what not to do, best-practice chart types, and narrative framing.
Course Content Created: September 2025
The information is current as of the creation or last updated date. While we strive to keep our inventory updated and periodically remove outdated titles, changes in accounting, tax, legislation and technology may occur. Purchasers should note the date and verify for themselves if the course is still relevant to their needs.Presenter
Simon Castonguay, CPA, CAAbout This Product
On-Demand Courses by CPA PRO are either video recordings from live seminars, or video recordings produced specifically for the on-demand audience. Where available, accompanying materials such as handouts or course notes are included.On-demand courses are eligible for verifiable CPD hours upon successful completion, and a certificate will be made available for download for your records.
Note that some courses comprise both formal instruction and self-directed exercises. In such cases, participants must complete both components to claim full CPD hours, or must reduce their reported CPD hours accordingly.
Please note that not all on-demand courses include downloadable materials such as course notes or slides.
How to get started
After completing your purchase, go to mylms.bccpa.ca. Log in using your CPABC Online Services credentials. Click Go to Your Courses and Materials to access your Learning Center. Select your course title to begin.
Course Dates & Registration
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.