The objective of this session is to demonstrate the power of Power Query to solve some complex data transformation challenges. There are times when source data is presented in a format that cannot be used for analysis. Data transformations are applied depending on how well or poorly the source data is organized. During the session, I will demonstrate some practical examples of how to perform such transformations in Power Query, using both GUI and the M Language.

The session duration is around 50 minutes