Data Tasks/Write the SQLProduct

Write the SQL to calculate DAU and MAU.

Write the SQL to calculate DAU and MAU. Bruin connects to your Amplitude + BigQuery to write and run the SQL for DAU and MAU, and returns a governed answer in plain English with the SQL and column-level lineage behind it. Ask in Slack, Teams, Discord, WhatsApp, or your browser.

Metrics & KPIs

DAUMAUstickiness

Required Data

Activity events

Data Sources

AmplitudeBigQuery

How Bruin does this

Bruin

Bruin AI Data Analyst

Write the SQL to calculate DAU and MAU.

Bruin connects to your Amplitude, BigQuery, writes the SQL, and runs it for you, with column-level lineage behind every number.

It tracks DAU, MAU, stickiness and delivers the result in seconds, in Slack, Discord, Teams, Google Chat, WhatsApp, Telegram, email, or your browser.

About Bruin

What is Bruin?

Bruin is an open-source, AI-powered data platform. One project covers the whole path from source to answer: data ingestion (with ingestr), SQL and Python transformations, quality checks, column-level lineage, a data catalog and scheduling. On top of that data, an AI data analyst answers questions in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email or the browser, and builds dashboards from a prompt.

Pipelines are plain SQL, Python and YAML files in your own Git repository, and the work runs inside your own warehouse: Snowflake, BigQuery, Databricks, Redshift, Postgres, ClickHouse, DuckDB and others. The Bruin CLI is open source under Apache 2.0 and runs on a laptop, in CI or on-prem. Bruin Cloud is optional and adds scheduling, the AI data analyst, governance, SSO and audit logs.

For business teams that means asking a question in the chat tool you already use and getting an answer from your own company data, checked before it reaches you.

Replaces
Separate tools for ingestion, transformation, orchestration, data quality, cataloguing and BI
Open source
Bruin CLI under Apache 2.0; ingestr source-available under the Functional Source License
Your data
Stays in your warehouse; pipelines stay in your Git repository
Security
ISO/IEC 27001:2022 certified and SOC 2 Type 2 attested
Used by
Data teams at Lessmore, StarBerry, NativeMinds, SCG, M8 Games and Fabrikatör

Why Bruin for everyday data tasks

  • Answers where you already work

    Ask in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email or the browser. There is no new tool to learn and no ticket to file with the data team.

  • Answers from checked data

    The analyst reads your pipelines, table descriptions and the latest quality-check results, so it does not answer from a table whose last run failed.

  • One definition per metric

    Revenue, active customers and churn are defined once, in Git, in semantic models and a glossary the analyst reads, so finance and marketing get the same number for the same question.

  • Built on a real data platform

    Bruin also loads and models the data. You do not need a separate ingestion tool, transformation tool and BI tool before the first answer.

How it works

  1. 01

    Connect your data

    Load your SaaS tools, databases and files into your warehouse with ingestr, or point Bruin at a warehouse you already have.

  2. 02

    Give it context

    Bruin documents tables and columns, records owners and runs quality checks on every load.

  3. 03

    Ask

    Ask in Slack, Teams or the browser. Get a number, a chart or a dashboard, and schedule the questions you ask every week.

Get it done in seconds

Connect your data, ask the question, get the answer. No SQL needed.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.

The signup form is hosted by Brevo. Allow marketing cookies to load it.