Description
Power Query and Power Pivot
(Prerequisite is MS Excel Advanced - Part 2 or equivalent)
Power Query and Power Pivot revolutionize how professionals handle large and complex datasets. In this course, you’ll learn to import, clean, and connect data from multiple sources to create automated, dynamic reports. Using Power Pivot, participants will build data models, define relationships, and create meaningful KPIs for monitoring performance across projects or divisions. These tools are invaluable for anyone managing detailed engineering or construction data, offering a faster, smarter way to consolidate and analyze information at scale.
• Power Query
-Import data
-Clean irregularly formatted data
-Connect to Data Sources
-Automating Data Updates
-Summarizing automatically update data info Pivot Tables and Pivot Charts
• Power Pivot
-Build data models
-Manage your data relationships
-Connecting to internal and external data sources
-Creating Measures
-Creating KPI’s
Delivery Method: Virtual Session – Zoom Meetings
Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion.
This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions.
Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.
Prerequisites
MS Excel Advanced - Part 2 or equivalent
For support or inquiries, please email [email protected] or call 604-293-2339.
| Ticket | Price | ||||||||
| Fees |
|
|
9:00am - 1:00pm
|
Course
|
Refund Policy
COURSE REGISTRATION CANCELLATIONS, TRANSFERS & REFUNDS:
Cancellations received at least 14 business days prior to the course will result in a full refund.
Cancellations received less than 14 business days but more than 7 full business days prior to the course are subject to an administration fee of $100 per day for full and half-day seminars, or $25 for breakfast sessions.
Registrants who do not show up for a course, and/or who do not notify BCRB at least 7 full business days prior to the course date will be assessed the full cost of the course. There will be no refunds or credits in this case
COURSE CANCELLATION BY BCRB:
BCRB may have to postpone or cancel courses due to insufficient enrolment, in which case BCRB's liability will be limited to a refund of the registration fee.