Back to Search
AI, Technology & Innovation

Elevate Accounting with Analytics of R (Live Webinar)

DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
REQUIRED
See note on technical requirements needed
NEW SEMINAR

Overview

Many have heard of Python due to its popularity, but it is also known for its steep learning curve at the beginning for people who never learn to program. What if there is an alternative that is arguably more powerful than Python for data analyses, also open-source (i.e. free), and yet, much more friendly to non-programming-background people? Let’s scope this appealing language called “R”!

This session will run as a live hands-on seminar. To ensure participants can follow along, setup needs to be completed in advance. This allows participants to begin fully prepared to focus our time on the core material.

Technical Requirements

Please ensure all technical requirements are completed before the start of the seminar.

  1. Personal laptop. Windows is preferred, as the session will be demonstrated on Windows, though macOS is also acceptable.
    Note: Company-managed devices often restrict software installation, which may prevent setup.
  2. Install R (see Get Started with R)
  3. Install Positron (see Get Started with Positron)
  4. Install Quarto (see Get Started with Quarto)

Course Description

This seminar provides hands-on experience in completing a comprehensive accounting project through a modern analytics approach. Audience will learn using R to streamline a typical accounting task that produces ready-to-distribute outputs (like PDFs, webpages, Excel workbooks), inspiring to dramatically enhance their accounting workflows.

We will also delve into key mindsets of analytics professionals and feel the synergy between analytics and accounting. The seminar will conclude with an overview of the current analytics and technology landscape, highlighting how accountants can pivot/capitalize on these trends.

Applicable for

This course caters to several professional profiles, highlighting key ones here:

  • Analysts: Ideal for those with access to detailed data who seek to dramatically increase processing/cleaning capability, automate professional reports and crafting professional grade data visualizations using free open-source tools.
  • Managers: Ideal for those looking for inspiration and strategies to boost team productivity in reporting, particularly within budget constraints, or those interested in enhancing their understanding of modern analytics and new possibilities.

No previous programming knowledge required.

Content

  • How to work with R: a powerful, free, data-analytics-first programming language.
  • Data Management with R: Gain skills in importing, exporting, and processing data using R.
  • Automate Reporting with R: Build a practical departmental report distribution workflows with R.
  • Advanced Data Visualization Techniques: Discover how to create impactful visualizations with R.
  • Professional and Versatile Publishing: Learn to build and publish professional reports of various file formats (webpage/html, PDF,
  • PowerPoint, Word) effectively.
  • Adopting an Analytics Mindset: Explore essential concepts and key components of successful analytics projects.
  • Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.

Course Dates & Registration

Jul 31, 2026
8:30AM - 4:30PM
Online Virtual
Jianyuan (Andy) Hu
Jianyuan(Andy) Hu has over 10 years of combined experience in accounting, financial planning, and analytics engineering. Andy is enthusiastic in helping organizations maximize their data and decision-making potential. Andy has proven successful in central accounting/finance, IT financial planning, academic faculty, ERP system migration, and institutional planning. Andy has led various initiatives: building enterprise datastore, implementing enterprise-grade analytics/data visualization, automating business processes and many others. These value-adding projects better assist and inform management at different levels while alleviating reporting burdens. As a CPA since 2020, Andy's educational background encompasses Master of Accountancy and Master of Management Analytics. Andy is also certified as Microsoft Trainer and as Microsoft Fabric Analytics Engineer Associate.
Available
Register Now
Course Code: C63811A_OL

Improving Your Virtual Learning Experience

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

 

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department. 

Course Details
Cost
$425
Members
$475
Non-Members
Eligible Hours
7
CPD Hours
0
Ethics Hours
0
AML Hours
Passport
10
Credits
Prerequisites
Prerequisites
To get the most out of this session, you should have a few years of experience using Microsoft Excel. You should be comfortable with concepts like Pivot Tables, lookups, and basic functions such as SUM and SUMIFS.

To fully engage in this course, please ensure you have access to a personal computer (Windows or macOS) and are prepared to install the necessary tools prior to the seminar. This will allow you to follow along with the hands-on exercises and make the most of the learning experience.
Special Notes
This is a hands-on seminar. Please ensure that you have a personal laptop, R, Positron, and Quarto ready before the seminar begins.
Credit Card Fee

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.

AI, Technology & Innovation

Elevate Accounting with Analytics of R (Live Webinar)

DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
REQUIRED
See note on technical requirements needed
NEW SEMINAR
Course Details
Cost
$425
Members
$475
Non-Members
Eligible Hours
7
CPD Hours
0
Ethics Hours
0
AML Hours
Passport
10
Credits
Prerequisites
Prerequisites
To get the most out of this session, you should have a few years of experience using Microsoft Excel. You should be comfortable with concepts like Pivot Tables, lookups, and basic functions such as SUM and SUMIFS.

To fully engage in this course, please ensure you have access to a personal computer (Windows or macOS) and are prepared to install the necessary tools prior to the seminar. This will allow you to follow along with the hands-on exercises and make the most of the learning experience.

Overview

Many have heard of Python due to its popularity, but it is also known for its steep learning curve at the beginning for people who never learn to program. What if there is an alternative that is arguably more powerful than Python for data analyses, also open-source (i.e. free), and yet, much more friendly to non-programming-background people? Let’s scope this appealing language called “R”!

This session will run as a live hands-on seminar. To ensure participants can follow along, setup needs to be completed in advance. This allows participants to begin fully prepared to focus our time on the core material.

Technical Requirements

Please ensure all technical requirements are completed before the start of the seminar.

  1. Personal laptop. Windows is preferred, as the session will be demonstrated on Windows, though macOS is also acceptable.
    Note: Company-managed devices often restrict software installation, which may prevent setup.
  2. Install R (see Get Started with R)
  3. Install Positron (see Get Started with Positron)
  4. Install Quarto (see Get Started with Quarto)

Course Description

This seminar provides hands-on experience in completing a comprehensive accounting project through a modern analytics approach. Audience will learn using R to streamline a typical accounting task that produces ready-to-distribute outputs (like PDFs, webpages, Excel workbooks), inspiring to dramatically enhance their accounting workflows.

We will also delve into key mindsets of analytics professionals and feel the synergy between analytics and accounting. The seminar will conclude with an overview of the current analytics and technology landscape, highlighting how accountants can pivot/capitalize on these trends.

Applicable for

This course caters to several professional profiles, highlighting key ones here:

  • Analysts: Ideal for those with access to detailed data who seek to dramatically increase processing/cleaning capability, automate professional reports and crafting professional grade data visualizations using free open-source tools.
  • Managers: Ideal for those looking for inspiration and strategies to boost team productivity in reporting, particularly within budget constraints, or those interested in enhancing their understanding of modern analytics and new possibilities.

No previous programming knowledge required.

Content

  • How to work with R: a powerful, free, data-analytics-first programming language.
  • Data Management with R: Gain skills in importing, exporting, and processing data using R.
  • Automate Reporting with R: Build a practical departmental report distribution workflows with R.
  • Advanced Data Visualization Techniques: Discover how to create impactful visualizations with R.
  • Professional and Versatile Publishing: Learn to build and publish professional reports of various file formats (webpage/html, PDF,
  • PowerPoint, Word) effectively.
  • Adopting an Analytics Mindset: Explore essential concepts and key components of successful analytics projects.
  • Navigating the Analytics Landscape: Understand the current trends in analytics and data technology, along with foundational concepts of cloud computing.

Course Dates & Registration

Jul 31, 2026
8:30AM - 4:30PM
Online Virtual
Jianyuan (Andy) Hu
Jianyuan(Andy) Hu has over 10 years of combined experience in accounting, financial planning, and analytics engineering. Andy is enthusiastic in helping organizations maximize their data and decision-making potential. Andy has proven successful in central accounting/finance, IT financial planning, academic faculty, ERP system migration, and institutional planning. Andy has led various initiatives: building enterprise datastore, implementing enterprise-grade analytics/data visualization, automating business processes and many others. These value-adding projects better assist and inform management at different levels while alleviating reporting burdens. As a CPA since 2020, Andy's educational background encompasses Master of Accountancy and Master of Management Analytics. Andy is also certified as Microsoft Trainer and as Microsoft Fabric Analytics Engineer Associate.
Available
Register Now
Course Code: C63811A_OL

Improving Your Virtual Learning Experience

Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns. 

In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.

Live Webinar FAQs can be found here.  

 

Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department. 

Special Notes
This is a hands-on seminar. Please ensure that you have a personal laptop, R, Positron, and Quarto ready before the seminar begins.
Credit Card Fee

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.