Commit to insight: building BI-as-code the AI way

About the workshop

AI is reshaping how teams explore and reason about data. Business users increasingly expect natural-language answers. Data engineers want analytics they can version, test, and deploy like software. AI researchers need structured semantic models that agents can reliably operate on. To serve all three, analytics must evolve into something more semantic, more interactive, and more code-driven.

This workshop introduces AI + BI -- an approach where dashboards, metrics, and models are created and explored through natural language, grounded in a robust semantic layer. At the core is BI-as-Code, the practice of expressing metrics, transformations, and dashboards declaratively using SQL and YAML. Inspired by the success of Infrastructure-as-Code, this approach makes your analytics stack reproducible, transparent, and ready for collaboration between humans and AI systems.

In this hands-on workshop, you’ll build an end-to-end AI + BI workflow using your own GitHub commit history. You’ll ingest commit data into DuckDB or ClickHouse, model it using SQL and YAML, and construct a governed metrics layer in Rill that becomes the shared contract for both humans and conversational AI.

You’ll then use natural-language prompts to explore engineering productivity questions -- receiving responses that include SQL, citations, visualizations, and clear explanations. You’ll also learn how to secure your dashboards and metrics by user attributes, ensuring that both human users and AI agents see only what they’re authorized to see.

By the end, you’ll experience what it feels like to move from raw data to real decisions with a modern, AI-native, code-driven analytics workflow.

Prerequisites

Level: Intermediate developers and AI practitioners
Prerequisites: Basic Python knowledge, familiarity with LLMs/prompting concepts
Hardware requirements: Laptop with 8G RAM, Linux/MacOS/Windows with WSL

What you will build

• A ClickHouse dataset created from your Git commit logs
• SQL + YAML analytics models following BI-as-Code practices
• A governed, semantic metrics layer designed for conversational AI
• Natural-language analytical workflows with SQL, citations, and charts
• A GitHub-backed BI project with GitOps deployment and governance
• A complete engineering productivity dashboard for your team

What you will learn

• How the principles of Infrastructure-as-Code can be applied to BI-as-Code
• How a semantic metrics layer enables trustworthy conversations with AI
• How to implement governance and secure data access in metrics and dashboards
• How to deploy BI projects using GitHub + GitOps workflows
• How to build an AI-ready end-to-end analytics project

This workshop is ideal for data Engineers and AI/ML developers.

Workshop flow (1.5-2 hrs)

Welcome & context (15 min)

• The shift from traditional BI to Generative BI
• Why BI-as-Code provides the technical foundation
• What we will build end-to-end
• Ensure every participant has the environment setup properly

Data Extraction & Engine Setup (15 min)

• Extract GitHub commit logs from your own repos
• Load into ClickHouse
• Quick exploration of the dataset by connecting ClickHouse to Claude using MCP

Modeling with BI-as-Code (10 min)

• Clean and model commit data in SQL
• Define transformations in YAML

Build the Semantic Metrics Layer (15 min)

• Use GenAI to define metrics (velocity, churn, PR cycles)
• Preview metric definitions
• Add time semantics, descriptions, and metadata
• Deploy your dashboards

Adding Security (10 min)

• Configure access policies
• Implement row-level and column-level security
• Test with mock users
• Validate that dashboards and AI responses apply the same rules

Conversational AI insights (10 min)

• Ask natural-language questions about engineering activity
• Review responses with SQL, charts, citations, and explanations
• Iterate on insights, refine prompts, and explore deeper

Further tune the dashboards (10 min)

• Generate charts from metrics
• Add filters, dimensions, and time controls
• Assemble a dev-productivity dashboard end-to-end

Closing & Q&A (20 min)

• Review semantics, speed, stewardship
• Overview of real-world projects handling large scale datasets
• How to take BI-as-Code into production

Here is a demo project what audience can build on top of their own git commit datasets - https://ui.rilldata.com/demo/rill-github-analytics

About the instructor

Nishant Bangarwa is the Co-Founder and Head of Engineering at Rill Data, where he leads the development of Rill’s open-source, high-performance, AI-native BI application—an alternative to legacy business intelligence tools, powered by modern analytical databases and a BI-as-Code workflow that delivers sub-second insights at scale.
Prior to Rill, Nishant worked on large-scale analytics systems at Cloudera and Metamarkets, and has contributed to several major open-source projects, including Apache Druid, Apache Calcite, and Apache Hive. His work has focused on advancing the state of the art in data infrastructure, real-time analytics, and metric-driven decision systems.

How to attend this workshop

This workshop is open for The Fifth Elephant annual members and for The Fifth Elephant 2025 Winter Edition ticket buyers

This workshop is open to 50 participants. Seats will be available on first-come-first-serve basis. 🎟️

Contact information ☎️

For inquiries about the workshop, contact +91-7676332020 or write to info@hasgeek.com