Power Query Editor (PQE) is a best tool available in Excel / Power BI / SSAS (SQL Server Analysis Services).
PQE performs the ETL (Extract Transform Load) process to Cleanse the Data and shape up the data the way we require, before we load that data into Data Model for evaluating the same with the help of DAX.
In this Video we have discussed very simple yet important techniques help us to deal with any kind of data (denormalized) and bring that into a normalized form.
Keep learning! SUBSCRIBE and Become a member to get latest updates to your email instantly!