Power Query and Power Pivot: Combining the Best of Both Worlds

In this course see how Power Query and Power Pivot work together. First use Power Query to prepare, clean and transform data. Then use Power Pivot to create a data model based on table relationships. Use it to add complex calculations. Then output the data into powerful PivotTable reports for data insight and analysis.

Areas Covered in the Session

Use Power Query to prepare and clean your data; remove columns, filter rows, split and merge columns
Use Power Query to further manipulate and transform data
See how Power Pivot is used to build a Data Model
Create Table Relationships to link tables together in the Data Model
Introduction to complex calculations within the data model (DAX, Measures)
Output the results of using both Power Query and Power Pivot into Excel PivotTable reports for data analysis and insight

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