note

Ranking Sales with Power Query Conditional Columns: How I Stopped Using 7-Level Nested IFs and Reduced Classification Errors from 15 to 0 per Month

The Friday night I realized, "I can't even read my own IF formulas anymore." Let me start with the conclusion: if you are using nested IF functions to categorize sales data into ranks like S, A, B, or ...
How-To Geek on MSN

I stopped overusing IF in Excel—and my formulas instantly became cleaner and faster

Modern Excel functions like IFS, SWITCH, XLOOKUP, SUMIFS, and LET replace most nested IF use cases.
GitHub

OpenMLDB is an open-source machine learning database that provides a feature platform computing consistent features for training and inference.

For the artificial intelligence (AI) engineering, 95% of the time and effort is consumed by data related workloads. In order to tackle this challenge, tech giants spend thousands of hours on building ...
GitHub

Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more

Since Github doesn't provide a great way for you to learn about new releases and features, don't just star the repo, join the mailing list. dsq will likely work on other platforms that Go is ported to ...