About This Course

Duration: Two full day, from 9:00 AM to 5:00 PM.

Delivery Mode: In-person classroom training. Virtual and in-house training options are also available upon request.

Language: English.

Credits: Participants will earn 16 PDUs / training hours.

Certification: Each participant will receive a Course Completion Certificate.

Refreshments: Complimentary lunch and refreshments will be provided during the training.

Course Overview:

This hands-on course focuses on real-world techniques using the powerful capabilities of Power Query, Power Pivot, and Power BI—the most significant Excel advancements in the last decade. Attendees will learn how to extract data from multiple sources, organize it, perform calculations, and create dynamic reports.

Participants will use Power Query to shape data and load it into Power Pivot, where they will build complex models, write DAX formulas, and set up interactive reports. On the second day, the course goes deeper into advanced features and reporting techniques, offering a more comprehensive understanding of these tools.

Target Audience:

This course is ideal for:

Excel users and analysts focused on data extraction, organization, and analysis.
Individuals involved in creating visualizations and data models.
Anyone looking to automate recurring reports and dashboards to save time.

Learning Objectives:

By the end of this course, participants will be able to:

Understand how Power BI enhances Excel’s native tools (Pivot Tables, slicers, etc.).
Import and relate data from various electronic sources quickly and efficiently.
Implement best-practice database design using LOOKUP lists and efficient data models.
Gain an introduction to DAX (Data Analysis Expressions) for Power BI.

Prerequisites:

This is an intermediate-level course. To get the most out of the course, participants should:

Be comfortable with Excel and familiar with functions like VLOOKUP and SUMIFS.
The focus is on Power BI in Excel 2013/2016, but the course is also applicable to Power BI Desktop.

Course Materials:

Attendees will receive a course manual containing presentation slides and reference materials.

Examination:

There is no exam for this course.

Technical Requirements (for eBooks):

Internet access for downloading the eBook.
Compatible devices (laptop, tablet, smartphone, eReader—no Kindle).
Adobe DRM-supported software (e.g., Digital Editions, Bluefire Reader).

Certification:

Participants will receive a Course Completion Certificate from Strivewisdom after completing the training.

To discuss your team’s training needs, email us at info@strivewisdom.com

© 2026 StriveWisdom. All Rights Reserved.

Contact the host of Power Query & Power Pivot Intensive: Sydney One-Day Certification Training