3-day Virtual Seminar

Data Transformation and Modeling with Power Query & Power Pivot

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