Power Query (Excel/Power BI)

Power Query is the built-in data preparation engine for Microsoft Excel and Power BI. It is arguably the most widely used data preparation tool in the world, allowing users to connect to hundreds of data sources, clean and transform data, and load it into Excel or Power BI models. It uses the 'M' language under the hood, but provides a user-friendly interface that hides the complexity from the user. For millions of business users, Power Query is the primary tool for automating their daily data cleaning tasks, making it an essential skill for modern office productivity.