Data Transformation
What is data transformation? In the context of data engineering, it is part of the data engineering life […]
transform
Number Transformations
Number transformations in Power Query are simple to do, but there is something you need to watch out […]
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
Itzik Ben Gan’s Database
As a more complex and realistic example, let’s look at the database that Itzik Ben-Gan used in his […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]
Power Query Transform Phone Number
Do you need to split a column of imported Excel telephone number data into two columns so that […]