Analyze 46m records in 4s with Excel & DuckDB

Hi all!

So there are two things I don't like about Power Query in Excel:

• It uses M code

• It has no Copilot integration to write the M code for me

But, I don't really care anymore because xlwings Lite + DuckDB is the new Super Power Query. In my latest video, I am analyzing 46 million records in 4 seconds with SQL. I also demo how Wingman, your friendly Copilot replacement, can edit and explain the code.

Enjoy!
~ Felix