---
title: "Better Business Intelligence in Elixir with Livebook"
description: "The post argues that Elixir developers already perform business intelligence when they use iex or a Rails console to query application data, calculate figures, and produce CSV rows for managers. It presents Livebook as a more capable alternative for young projects that need analysis without adopting a large, continuously running BI application such as Metabase. Because notebooks execute Elixir code and can communicate with running applications through BEAM/OTP clustering, they can reuse business logic, Ecto schemas, associations, and external integrations such as Stripe while avoiding direct database access. Livebook also supplies charts, graphs, tables, Markdown-based sharing, and reproducible reruns, with WireGuard enabling secure connections to apps on Fly.io. The resulting notebooks can answer onboarding, sales, and integration questions while preserving work that may later support an admin dashboard."
---

# Better Business Intelligence in Elixir with Livebook

[Fly.io](https://yomu.fyi/company/fly-io) · Jul 30, 2021

**Type:** Problem & solution

## Summary

The post argues that Elixir developers already perform business intelligence when they use iex or a Rails console to query application data, calculate figures, and produce CSV rows for managers. It presents Livebook as a more capable alternative for young projects that need analysis without adopting a large, continuously running BI application such as Metabase. Because notebooks execute Elixir code and can communicate with running applications through BEAM/OTP clustering, they can reuse business logic, Ecto schemas, associations, and external integrations such as Stripe while avoiding direct database access. Livebook also supplies charts, graphs, tables, Markdown-based sharing, and reproducible reruns, with WireGuard enabling secure connections to apps on Fly.io. The resulting notebooks can answer onboarding, sales, and integration questions while preserving work that may later support an admin dashboard.

## Context

Developers at startups often answer management’s business questions by opening an Elixir iex session or Rails console, running scripts, and exporting results. Commercial BI suites provide dashboards and analysis but can be expensive, heavy, difficult to learn, and dependent on direct database access and a continuously running application.

## Approach / What changed

Use Livebook notebooks connected to a running Elixir application. The notebooks execute the application’s code, reuse its business logic, Ecto schemas, and associations, call external integrations, and produce charts, graphs, and tables. Clustering through BEAM/OTP and secure WireGuard tunnels support connections to applications running on Fly.io.

## Takeaways

- Livebook notebooks are Markdown files that can be checked into a project, shared with a team, and rerun to produce updated numbers.
- Because Livebook communicates with running Elixir applications, analysis can combine application data with results from external services such as Stripe.
- A startup can keep its application and database running, then connect Livebook on an as-needed basis instead of maintaining a separate BI application.

**Tags:** [Data Analytics](https://yomu.fyi/topic/data-analytics), [Elixir](https://yomu.fyi/topic/elixir), [Livebook](https://yomu.fyi/topic/livebook), [WireGuard](https://yomu.fyi/topic/wireguard)

- Source: [Fly.io](https://fly.io/blog/better-business-intelligence-in-elixir-with-livebook)
- Source URL: https://fly.io/blog/better-business-intelligence-in-elixir-with-livebook
- Ingested by Yomu: 2026-09-03T01:23:24.950Z

[Read original post](https://fly.io/blog/better-business-intelligence-in-elixir-with-livebook)