Power Query is a business intelligence tool available in Excel that allows you to import data from many different sourced and then clean, transform and reshape the data as needed. It allows to set up a query once and then reuse it with a simple refresh. It is also very powerful. Power Query can import and clean millions of rows into the data model for analysis after. The user interface is intuitive and well laid out so it’s really easy to learn.