3-day Virtual Seminar

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

Overview

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