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
Instructor
Craig Brody