Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This seminar introduces CPAs to the data management and analysis capabilities of Google Cloud Storage and BigQuery within the Google Cloud platform. Participants will learn how to store, manage, and analyze large datasets, with hands-on practice in data storage, basic SQL syntax, query building, and reporting. By the end of the course, participants will learn how to use these tools to improve their data-driven workflows.
Key Topics:
- Introduction to the Google Cloud Platform
- Storing large datasets
- BigQuery Basics
- Writing and Running SQL Queries
- Analyzing structured financial data
Key Takeaways
The course will cover:
- Efficient Data Management and Analysis: Learn how to store documents in Google Cloud Storage and use BigQuery’s direct access to perform quick and detailed analyses without duplicating data.
- Writing Basic SQL Queries in BigQuery: Learn basic SQL to query large datasets.
- Staying Updated on Cloud Trends: Understand how cloud-based tools like Google Cloud Storage and BigQuery support future accounting practices.
Who Will Benefit
The seminar is designed for accountants and finance professionals with no prior experience in cloud platforms, though familiarity with SQL and database management will be helpful.
How to Access the Course
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
Electronic material can be accessed one week prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Tomas Milo is a CPA and PhD candidate in Management (Accounting specialization) at McGill University, where he combines his accounting expertise with Data Science and empirical research. Previously, Tomas worked at KPMG in their Audit, Deal Advisory, and Data Science departments, where he developed his skills in analyzing financial data and automating accounting processes. Tomas is the principal consultant at Sigma Optimized, where he leverages AI and analytics tools to refine business processes for CPA firms, medical practices, and venture-funded start ups. Tomas is also a member of the United Nations Framework Classification (UNFC) Taskforce, and he presented his research at the United Nations Resource Management Week 2024 in Geneva.