flex your data

How to get the current region in Excel with a formula?

2025-05-25 Blog, Excel, LAMBDA Someone on an email distribution list I’m on said it would be really useful to have a function that mimics the behavior of VBA’s Range.CurrentRegion. I thought this would be an interesting challenge to implement with LAMBDA, so here’s one way you might do it: Here’s an example of the function being used.

How to visualize matrix transformations with Python and matplotlib?

2025-05-17 Python, Python in Excel Guys. You wouldn’t believe how long it took me to figure out the syntax for correctly displaying a square matrix on a matplotlib plot.

SQL is changing into something new – are you ready?

2025-05-03 SQL On 30 April 2025, DataBricks announced their SQL pipe operator. Without giving you a full rundown of what it is and what it does, here’s a quick example which should give you a good idea. This query: Is now equivalent to this: There’s more to it of course, but that’s the gist of it. It follows precedent set by other languages. Here’s how it might be written in R using tidyverse syntax.

What’s the difference between ROLLUP and GROUPING SETS in SQL?

2022-06-16 Blog, SQL The full script for this post can be found here. This post uses the AdventureWorksDW database in SQL Server 2019 Express. Depending on your preference, you can either watch this video or read below.