Power Pivot & Power Query
Power Pivot
• import data from multiple data sources into a single Excel workbook
• create relationships between heterogeneous data
• create calculated columns and measures using formulas
Power Query
• Import source from multiple data source
• Different methods to append (stack) data tables whether they are within the same file or spread across multiple source files
• A variety of transformation techniques and patterns to solve various data challenges
WHEN TO USE
Power Pivot
• Using large sets of data and need to compile multiple source data
• Need to manipulate data using formulas
• Automate data manipulation for future data
Power Query
• To extract only useful data from large and detailed data sets
• Cleanup data
• Automate the process of reshaping for future data