Data Analytics and Business Intelligence

MS Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. In this session we are going to:

•  Use the un-Pivot function to sanitize the data,

•  Combine (Merge)  multiple tables into one Pivot table,

•  Use a TWO-WAY Lookup (replacement for VLOOKUP) to retrieve information.

Certificate only available below on completion of ALL Videos and Knowledge Checkpoints in this Module.