Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Data is only valuable if you can turn it into insights that drive action. Power BI has become one of the most widely used tools for business intelligence, giving professionals the ability to work with data efficiently and present it in a way that makes sense to decision makers. In this course, you’ll learn the full process of data analysis in Power BI: transforming and cleaning raw data with Power Query, building strong data models and measures with DAX, and creating clear visuals that highlight what matters most. By the end, you’ll understand not just how to use the tool, but how to apply best practices that lead to reliable, professional-quality analysis.
Note: You will need Power BI Desktop on a Windows PC computer to be able to complete this course.
Prerequisite Skills
Recommended skills to have before taking this course.
- Basic data analysis
Key Takeaways
By the end of this session, participants will be able to:
- Develop familiarity with the core working areas of Power BI Desktop and how they connect to support the full data analysis process.
- Apply Power Query to extract, transform, and load data efficiently for analysis.
- Design structured data models and apply normalization principles for accuracy and performance.
- Write DAX formulas to create dynamic measures and calculated columns that power your analysis.
Who Will Benefit
This course is designed for finance professionals who already work heavily in Excel and want to expand their analytics skills, as well as data professionals seeking to add Power BI to their toolkit. Whether your career path is in financial analysis, business intelligence, or data analytics, this course will help you build practical skills that translate directly into your work.
How to Access the Course
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal. You can also access your course through the Blackboard Learn app (iOS or Android).
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and other CPA Ontario PD policies can be found here.
Speaker(s)
Joseph Yeates is passionate about driving better decision-making by creating, curating, and communicating insights from data. A data enthusiast with a background in retail banking, he is an advocate for making advanced analytics more accessible to a wider audience by integrating them into business intelligence solutions. Joseph helps organize the Vancouver Power BI & Modern Excel User Group. An active speaker, he has presented sessions on combining data science with business intelligence at conferences in the Pacific Northwest and across North America.