Doing every Maven data drill in Basedash

Maven Analytics has data drills, small real-world challenges with sample data, and on YouTube they'd raced someone using SQL, Python and Excel against someone using Power BI. The day before this, I did number four in Basedash in about a minute and ten seconds, twice as fast as the fastest time, which was two minutes and ten with SQL (0:27). So I tried all six at once.

The data was in spreadsheets in a Google Drive folder, but the workspace also had a whole Databricks warehouse connected, more than 80 tables, which could've been a curveball (1:34). I didn't tell it which tables to use. I pasted each question into its own chat, like how many users had Fight Club as the last film they watched (2:22), and let them run.

They came back one at a time, and it was six for six in about five minutes (5:10). It was the first time I'd tried it, and I was worried I'd have to edit something to make it work, but I didn't edit it (5:35).

When I posted it on X I wrote:

I just did all of the Maven data drills in with 100% accuracy in Basedash in less than five minutes. 6 challenges. No mistakes. One prompt each. I can’t write SQL. No additional context, no guidance on what tables to use, how to structure things, where to look other than the root prompt. It had to join, aggregate, flatten JSON, and even (without asking) it generated visualizations for some of the data for better consumption. Crazy crazy crazy.