Power Query is rightly known for its abilities to clean data in Excel. But did you know about its data profiling powers? Let’s take a look now at a modified version of the penguins dataset.   Learn how to import a table into Excel Power Query here. What is data profiling? Think of it as … Continue reading How to profile data in Excel with Power Query