Teaching analytics with modern Excel
Data analysts should be proactive about missing values in their data, as these can significantly impact analysis outcomes. First of all, many algorithms such as linear and logistic regression as well …
Continue Reading about Python in Excel: How to work with missing values →
nulls in Excel Power QueryIn Excel's Power Query, blank values are treated as nulls to signify the absence of data or to indicate an unknown, missing, or inapplicable value. This approach is consistent with database and …
Continue Reading about How to replace blank values with nulls 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 →