Data Transformation and Modeling with Power Query & Power Pivot

Craig Brody 
Instructor: Craig Brody 
Date: Tuesday June 16, 2026
Time:

12:00 PM PDT | 03:00 PM EDT

Duration: 60 Minutes
Webinar Id: 26577

Price Details

Live Webinar
$150. One Attendee
$290. Unlimited Attendees
Recorded Webinar
$190. One Attendee
$390. Unlimited Attendees
Combo Offers   (Live + Recorded)
$289 $340   One Attendee
$599 $680   Unlimited Attendees

Unlimited Attendees: Any number of participants

Recorded Version: Unlimited viewing for 6 months (Access information will be emailed 24 hours after the completion of live webinar)

Overview:

See how Power Query is used to prepare, clean, manipulate and transform data prior to output into Excel tables and PivotTables. Learn how to import data from several sources into Power Pivot, then build a data model to bring the data together. Output data from Power Pivot into Excel PivotTables for data insight and analysis.

Areas Covered in the Session:

  • Use Power Query to prepare, clean and transform data
  • See how Power Query can remove columns, filter rows and split and merge columns
  • Use Power Query to shape data with pivot and unpivot
  • Load Power Queries into Excel PivotTables
  • Import data from various sources into PowerPivot 
  • Build a Data Model; Create Relationships to link tables together
  • Introduction to complex calculations within the data model (DAX, Measures)
  • Output the data from the Data Model into Excel Pivot Tables

Who Will Benefit:

  • Managers
  • Business Professionals
  • Administrative Personnel
  • Legal Professionals

Speaker Profile
Craig Brody runs Craig Brody, LLC, a software training and consulting business. Craig has trained thousands of employees, managers, executives and students in application software including Microsoft 365 and Adobe Acrobat Pro. Conducts and facilitates in person and online training workshops for professionals in the fields of Accounting, Business, and Law. Conducts workshops, classes and consulting services for the University of Pennsylvania’s Wharton Business School and Penn Carey Law School. Provides clients with spreadsheet analysis and design, software programming, consulting services and course curriculum including videos, reference guides and related materials

Sign Up for Our Newsletter