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