Microsoft Power Query is a business intelligence tool available in Excel that allow users to connect data from various sources and clean, transform and reshape data in order to meet our data analysis needs.