Teaching analytics with modern Excel
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 …
Continue Reading about How to profile data in Excel with Power Query →
I liken Power Query to the Narnia of Power Query -- a magical place, but not so easy to locate: Here's how to load your Excel data into Power Query...and an example what to do with it when you …
Continue Reading about How to load Excel data into Power Query →
Not only is Power Query a phenomenal tool for transforming data in Excel, it also enforces good data hygiene 🧼. What do I mean by that? Think about the steps that you take every day to present …
Continue Reading about How Power Query enforces good data hygiene in Excel →
This is something that happens to me all the time: I've got data in an Excel table and want to add an index column (because I believe every dataset should have an index column). Index columns …
Continue Reading about How to add data to the left of an Excel table →
If you've heard that Excel can only handle 1,047,576 rows... well, that's not so true anymore. With Power Query, it's now possible to work with millions of rows, building a fully reproducible …
Continue Reading about Sigma Rule #1,048,576: Never underestimate Excel →
Back in the LinkedIn poll craze of 2021 I will admit I, like many users, got a little carried away. To my credit, all (or at least most 😼) of my polls were done in good faith to generate a …
Continue Reading about We should be teaching Tables and Power Query in Excel way earlier →
