Business Intelligence as Code

on YouTube ↗26m

" summary

Describes treating business intelligence as code by writing Markdown files that embed SQL and UI components and building a static site with NPM commands. Demonstrates Eviden ce generating per-category pages from templates, using DuckDB WASM in the browser to recombine Parquet fragments, and wiring interactive filters into SQL inputs to achieve fast client-side interactivity via npm run source/dev/build; notes limits when datasets reach hundreds of GB.

AI-written summary · about

" chapters (10)

1. 0:00Introduction to BI as code
2. 1:04Traditional BI problems
3. 4:36Evidence overview
4. 7:22Setup demo and charts
5. 9:33SQL query chaining components
6. 10:35Dynamic pages with templates
7. 14:53Interactive filters
8. 17:16Data exploration with dimension grid
9. 20:05Customization and deployment
10. 21:28Q&A

" related talks

• 45mFrom hand-down maps to AI/BI: a journey toward DatabricksGiulio Melloni, Andrea Calegari · PyCon Italia 2025
• 42mHow to Get the Most Out of Your BI ToolsKeshia Rose · Crunch Conference 2019
• 29mNavigating the Modern Data Stack with Open Source Headless BIArtyom Keydunov · OSA Con 2022
• 21mInteractive Documentation at Scale Using MDX & Next.jsJeff Escalante · Next.js Conf 2021
• 39mEmbedded Analytics through Data APIDionizas Antipenkovas · Big Data Conference Europe 2019
• 52mSelf-Service Business Analytics in 2013Rod Colledge · PASS Business Analytics Conference 2013
• 32mHow to Build a Data Warehouse?Martin Loetzsch · code.talks 2014
• 37mPitfalls and pro-tips for effective and transparent BI tools data science & applicationsJason Medina · Data Con LA 2020