What is Power Query?

Power query is a ETL Tool used to shape, clean and transform data using intuitive interfaces without having to use coding. It helps the user to:
 
Import Data from wide range of sources from files, databases, big data, social media data, etc.
Join and append data from multiple data sources.
Shape data as per requirement by removing and adding data.