Analytics & AI for Modern Excel
In an earlier post I covered how to load data in Power Query. But what about the other side of the ETL pipeline -- that is, loading and editing the connection to those queries? Let's practice on a …
Continue Reading about How to edit load options in Excel Power Query →
null and missing values in Power QueryI've written in the past how Power Query enforces good data hygiene practices that aren't always in Excel. One of those is the presence of a null or dedicated missing value. This has been a real …
Continue Reading about How to understand null and missing values in Power Query →
One of the central roles of an analyst is myth buster: what is assumed to be true that might not be? And why does it matter? Excel is a legendary business application. But sometimes, legend passes …
Continue Reading about How Power Query is the Excel myth buster →
Let's be honest, there are a lot of terms in tech that sound way more complicated than they really are. Maybe it goes by an acronym for peak confusion. But peel back the concept and it makes perfect …
Continue Reading about How Power Query serves as an extract, transform, load (ETL) tool for Excel →
Earlier this week I posted a new article in the journal Nature titled "Six tips for better spreadsheets." Today I'd like to share a 2018 article in The American Statistician along the same …
Continue Reading about Broman & Woo’s “Data Organization in Spreadsheets” →
Power Query is possibly the most exciting new Excel feature of its generation... but you might never know it considering how hidden it is from the Excel interface! If you're looking to connect a data …
Continue Reading about A tour of the Power Query Editor in Excel →
