Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. In this episode, Thomas Betts chats with ...

See how try and otherwise protect custom column math from type errors in Power Query, saving time and keeping your refresh ...

Replace manual Excel tasks with conditional columns, smart merging, the unpivot tool, and more.

No more Power Query needed.

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Microsoft adds IMPORTTEXT and IMPORTCSV to Excel, letting users pull text files directly into the grid with simple formulas.

Have you ever stared at a tangled web of paired columns in your dataset—”Size 1/Value 1,” “Size 2/Value 2,” and so on, wondering how to make sense of it all? It’s a common frustration for anyone ...

In this six-step guide, learn how to use Google's query formula in order to build link analysis dashboards in Google sheets. Analyzing your own link profile as well as your competitors’ is a ...

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...

Apache Solr is an open source search engine at heart, but it is much more than that. It is a NoSQL database with transactional support. It is a document database that offers SQL support and executes ...