Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This certificate program is an emerging technology and outcomes driven course, offered by CPA Ontario and powered by Lighthouse Labs, Canada's Leading Digital Bootcamp Institution.
This six-week certificate program will enable you to analyze and visualize data using a popular programming language used by analysts and data scientists.
Learn how to apply high-level analytical thinking to solve data analysis problems using Python. You will work with tools like Jupyter Notebooks and Pandas and analyze real-world datasets to identify patterns and relationships. By the end of this course, you will be able to work effectively with data to drive business strategies and create value for your organization.
Program Details
This program takes place on the Lighthouse Labs learning platform and is made up of synchronous and asynchronous components.
- 2 sessions per week
- 1 hour of live instructor led learning per session (dates & times outlined below in chart, live sessions will be recorded)
- On average you should allocated 2-3 hours of asynchronous time per session to complete program work
- Office hours available
Assessments:
This course includes short quizzes consisting of multiple-choice questions and programming challenges throughout the course to assess knowledge and skill development. A final Python challenge (capstone project) will take place towards the end of the program.
Speak to an Advisor
To speak to an advisor, please fill out this form.
Schedule
| Weeks | Topic | Assessment |
|---|---|---|
|
Week 1 |
Data Science Enviroment Setup Live Instructor Led Session: October 14 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
|
|
Databases and SQL Basics Live Instructor Led Session: October 17 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz |
|
| Week 2 |
Python Fundamentals Live Instructor Led Session: October 21 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz |
|
Python Programming Live Instructor Led Session: October 24 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Python Programming Challenge: Poker Hand | |
| Week 3 |
Python and Pandas Live Instructor Led Session: October 28 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz Programing Test |
|
Advanced Pandas Live Instructor Led Session: October 31 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz | |
| Week 4 |
Python and SQL Live Instructor Led Session: November 4 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz |
|
Advanced Python Live Instructor Led Session: November 7 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Quiz | |
| Week 5 |
Advanced Python II Live Instructor Led Session: November 11 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: approx. 2-3 hours |
Programming Test II |
|
Python Challenge Part I Session: November 14 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: 4 hours NOTE: There is no instructor-led (synchronous) training for this session, and four hours of independent (asynchronous) work. |
Final Project | |
| Week 6 |
Python Challenge Part II Live Instructor Led Session: November 18 from 1:00 p.m. - 2:00 p.m. Asynchronous Work: 4 hours |
Final Project |
|
Demo Day Session: November 21 from 1:00 p.m. - 2:00 p.m. Showcase your new skills and demonstrate just how far you have come in your learning journey. This is a celebration of you! NOTE: Your participation in demo day is strongly recommended but not mandatory. It is our hope that you will take this time to connect with your peers and share your project. |
Presentation |
Optional Office Hours:
- Monday: 2:00 p.m. - 3:00 p.m. (After the lecture)
- Tuesday: 6:00 p.m. - 7:00 p.m. (Bookable - 1:1 time slots)
- Wednesday: 6:00 p.m. - 7:00 p.m. (Bookable - 1:1 time slots)
- Thursday: 2:00 p.m. - 3:00 p.m. (After the lecture)
Note: Office hours are not mandatory.
All learners are strongly encouraged to attend the office hours after your October 16 session to ensure you have successfully set up the required software needed to complete the program.
Key Takeaways
Upon completion of this course, you will be able to:
- Apply high-level analytical thinking to data analysis problems;
- Gain skills to use and navigate tools, libraries, and environments for data analysis using Python;
- Develop workflows for data analysis and wrangling tasks using basic Pandas functions and SQL;
- Develop and apply basic data wrangling techniques and methodologies with various data types and sources to solve accounting and finance problems.
Earn A Digital Badge
Our new collection of digital badges can be earned through the completion of any of our certificate programs offered in our professional development catalogue. Collect these digital badges to add to your website, social profiles, email signature and more. These badges are an easy way to visually communicate your skills and accomplishments to your peers and network. Digital badges will be awarded based on course completion requirements.
Who Will Benefit
Accountants and financial professionals who want to learn how to use data and data programming languages to make better business decision and solve problems. Knowing Python and having coding skills can help CPAs future-proof their career and adapt to the profession's changing demands. It can help them work more efficiently, provide better insights to their clients, and collaborate effectively with other professionals.
Prerequisite(s)
No prior programming experience is required. Some basic understanding of arithmetic and statistics concepts and an aptitude for logic and quantitative concepts are highly desirable.
Need Approval to Attend
Attendance Requirements
To earn your CPD hours you must attend 75% of the live lectures. To earn a Digital Badge, you must meet the attendance requirements outlined above and submit and receive a passing grade (50% or higher) on your capstone project.
Disclaimer
By registering for this course you consent and confirm your understanding of the following: CPA Ontario will share your first name, last name and email address with Lighthouse Labs for the purposes of providing you access to the course. It is suggested if possible, to use your business email address.
How to Access the Course
We're pleased to invite you to register for our Certificate courses. Whether or not you're a CPA, you're more than welcome to join us on this learning journey. To get started, you'll need to create an account. Don't worry if you don't have a CPA Ontario ID yet; you can easily set up your account right here. Let's begin your learning adventure together.
The course combines both synchronous and asynchronous components learning. Your learning will take place on the Lighthouse Labs learning platform. This is a two-step registration processs. Once you've registered and paid on the CPA Ontario portal you are considered registered for the course. You will receive an email from Lighthouse Labs at least 48 hours prior to the course start date with full program detail and information on how to access the course.
Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.
Speaker(s)
Jenny Hung, Bs.C (Mathematics), LL.B, CPA.CA, is a data analyst in applied finance and data science instructor. In addition to data science, Jenny is also an algorithmic trader specializing in the Python language in the Forex market, and she also writes about Algo trading as well as the issues related to the financial markets. Jenny developed a financial trading algorithm that combines both quantitative finance insights as well as AI techniques and is capable of automatically selecting trades, choosing strategies, and managing portfolio trades.