Power Query & Power Pivot Intensive: Sydney One-Day Certification Training
Description
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.
Agenda
Days 1 & 2:
● Power BI & PowerPivot Introduction
○ Creating your first Power Pivot Model ○ Mapping tables ○ Joining multiple tables and understanding relationships ○ Creating and utilizing a Calendar Table
● Advanced Pivot Table Design
○ Pivot Charts ○ Power Map
● In-depth Power BI & Power Pivot Models
○ Building complex PowerPivot models ○ Calculated Columns ○ DAX Formulas and Measures (Calculated Fields) ○ Filters, Slicers, Hiding, and Hierarchies
● Troubleshooting & Best Practices
○ Avoiding common pitfalls ○ Building checks for data imbalances
● Advanced DAX Formulas
○ Creating time-based measures ○ Understanding CALCULATE ○ Using CUBE Formulas and KPIs
● Power Query
○ Exploring the User Interface ○ Unpivoting data ○ Merging multiple queries into one table
● In-Depth Power Query Techniques
○ Using variables for query parameters ○ Introduction to the Advanced Editor and M Language ○ Creating reusable custom functions ○ Calendar Creator
● Power BI Desktop & PowerBI.com
○ Comparison with Power Pivot and Power Query ○ Overview of the graphical interface ○ Custom Visualizations ○ Publishing and Sharing Dashboards on PowerBI.com
Related Courses:
● Power Query (Get & Transform) for Excel and Power BI Desktop ● Power BI Dashboard and Data Analysis
FAQs
- 1. Who should attend the Power Query and Power Pivot for Excel course?
The course is designed for Excel users, analysts, data professionals, and anyone involved in data extraction, organization, analysis, visualization, data modeling, or recurring report and dashboard creation.
- 2. What is the duration of the course?
The course is a 2-day training program providing 16 credits.
- 3. How is the training delivered?
The course is available through Classroom, Virtual, and Onsite delivery.
- 4. What language is the course conducted in?
The training is conducted in English.
- 5. What level of Excel knowledge is required?
This is an intermediate-level course. Participants should be comfortable using Excel and familiar with functions such as VLOOKUP and SUMIFS.
- 6. What are Power Query and Power Pivot used for?
Power Query is used to extract and transform data from different sources, while Power Pivot supports data modeling, calculations, relationships, and advanced analysis within Excel.
- 7. Will I learn how to import data from multiple sources?
Yes. Participants learn how to import and relate data from various electronic sources efficiently and organize it for analysis.
- 8. Does the course cover data modeling?
Yes. The training covers Power Pivot models, mapping tables, relationships between multiple tables, database design, lookup lists, calculated columns, and other data-modeling techniques.
- 9. Will I learn how to create Power Pivot models?
Yes. Participants create their first Power Pivot model and progress to more complex models involving relationships, calculations, filters, slicers, and hierarchies.
- 10. What is DAX, and will it be covered in the course?
Yes. The course provides an introduction to DAX (Data Analysis Expressions) and covers DAX formulas, measures, calculated fields, time-based measures, and the
CALCULATEfunction. - 11. Does the course cover Pivot Tables and Pivot Charts?
Yes. Participants explore advanced Pivot Table design and Pivot Charts, along with features such as filters and slicers.
- 12. Will I learn how to use Power Query to transform data?
Yes. The course covers the Power Query interface, unpivoting data, merging queries, using query parameters, and creating reusable custom functions.
- 13. Does the course include the Power Query Advanced Editor and M Language?
Yes. Participants receive an introduction to the Advanced Editor and M Language and learn about using variables and creating reusable custom functions.
- 14. Will I learn how to create interactive reports and dashboards?
Yes. The course covers interactive reporting features, custom visualizations, Power BI Desktop, and publishing and sharing dashboards through PowerBI.com.
- 15. Does the training cover Power BI Desktop?
Yes. The course provides an overview of Power BI Desktop, its graphical interface, custom visualizations, and its relationship with Power Pivot and Power Query.
- 16. Will I learn how to troubleshoot data and avoid common mistakes?
Yes. The course includes troubleshooting and best practices, including avoiding common pitfalls and building checks to identify data imbalances.
- 17. Does the course cover advanced Excel and Power BI features?
Yes. Topics include advanced DAX formulas, time-based measures, CUBE formulas, KPIs, hierarchies, Power Map, custom visualizations, and advanced Power Query techniques.
- 18. What course materials are provided?
Participants receive a course manual containing presentation slides and reference materials.
- 19. Is there an examination at the end of the course?
No. There is no exam for this course.
- 20. Will I receive a certificate after completing the training?
Yes. Participants who successfully complete the course will receive a Course Completion Certificate.
Tickets for good, not greed Humanitix dedicates 100% of profits from booking fees to charity
Get tickets
Get tickets
More events from this host
