top of page
Search

Understanding Power Query Editor - using Pivot / UnPivot / Transpose and many more techniques.....

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!



294 views0 comments

Recent Posts

See All

CURRENTMONTH( ) FUNCTION in EXCEL?

The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial and even an Excel file to follow along with. #excel #lambda http

bottom of page