Turn your dbt project into an AI data analyst

Turn your dbt project into an AI data analyst

Turn your dbt project into an AI data analyst

Buster is an open-source platform for deploying AI data analysts - empowering everyone at your company to explore data on their own.

Buster is an open-source platform for deploying AI data analysts - empowering everyone at your company to explore data on their own.

Buster is an open-source platform for deploying AI data analysts - empowering everyone at your company to explore data on their own.

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Company KPIs

A quick overview of our key metrics and performance indicators.

Monthly Sales by Sales Rep

Last 12 months

make a line chart of my monthly sales broken down by sales rep

Daily Sales by Brand

Last 30 days

show me our daily sales, broken down by brand

$14k

$10.5k

$7k

$3.5k

$0

Total Sales by Product Category

Last 30 days

break down our total sales for the last 30 days by product category

Cumulative Daily Revenue

Jan 1 - Jan 31

show me our cumulative revenue over the month of January

SKU Report: Total Sales & Percent Growth

Last 30 days

create a report of our total sales and % growth for each SKU over the last 30 days

Name

Nate Kelley

Blake Rouse

Gregory

Dallin Bentley

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

SKU

SKU-0959

SKU-0973

SKU-0183

SKU-1182

SKU-1115

SKU-0174

SKU-0183

SKU-0210

SKU-1197

SKU-0717

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Product

Chiquita Cavendish

Dole Cavendish

Goya Plantain

Frieda’s Burro

Chiquita Plantain

Chiquita Lady Finger

Dole Red Banana

Del Monte Cavendish

Tropicana Orange Juice

Free-Range Eggs

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Total Sales

$4,259

$4,227

$4,165

$4,054

$3,822

$3,801

$3,712

$3,709

$3,702

$3,675

1.3

1.3

1.3

1.3

Another name

Another name

Another name

% Growth

1.47%

8.11%

0.11%

8.05%

6.53%

-3.60%

-8.17%

-7.94%

2.64%

9.00%

Various Items

Various Items

Various Items

Various Items

Another name

Another name

Another name

Add content

Dashboards

Company KPIs

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Metrics

Daily Sales by Brand

Copilot

Styling

SQL

show me our daily sales, broken

down by brand

Edit this metric or follow up...

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Company KPIs

A quick overview of our key metrics and performance indicators.

Monthly Sales by Sales Rep

Last 12 months

make a line chart of my monthly sales broken down by sales rep

Daily Sales by Brand

Last 30 days

show me our daily sales, broken down by brand

$14k

$10.5k

$7k

$3.5k

$0

Total Sales by Product Category

Last 30 days

break down our total sales for the last 30 days by product category

Cumulative Daily Revenue

Jan 1 - Jan 31

show me our cumulative revenue over the month of January

SKU Report: Total Sales & Percent Growth

Last 30 days

create a report of our total sales and % growth for each SKU over the last 30 days

Name

Nate Kelley

Blake Rouse

Gregory

Dallin Bentley

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

SKU

SKU-0959

SKU-0973

SKU-0183

SKU-1182

SKU-1115

SKU-0174

SKU-0183

SKU-0210

SKU-1197

SKU-0717

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Product

Chiquita Cavendish

Dole Cavendish

Goya Plantain

Frieda’s Burro

Chiquita Plantain

Chiquita Lady Finger

Dole Red Banana

Del Monte Cavendish

Tropicana Orange Juice

Free-Range Eggs

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Total Sales

$4,259

$4,227

$4,165

$4,054

$3,822

$3,801

$3,712

$3,709

$3,702

$3,675

1.3

1.3

1.3

1.3

Another name

Another name

Another name

% Growth

1.47%

8.11%

0.11%

8.05%

6.53%

-3.60%

-8.17%

-7.94%

2.64%

9.00%

Various Items

Various Items

Various Items

Various Items

Another name

Another name

Another name

Add content

Dashboards

Company KPIs

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Metrics

Daily Sales by Brand

Copilot

Styling

SQL

show me our daily sales, broken

down by brand

Edit this metric or follow up...

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Company KPIs

A quick overview of our key metrics and performance indicators.

Monthly Sales by Sales Rep

Last 12 months

make a line chart of my monthly sales broken down by sales rep

Daily Sales by Brand

Last 30 days

show me our daily sales, broken down by brand

$14k

$10.5k

$7k

$3.5k

$0

Total Sales by Product Category

Last 30 days

break down our total sales for the last 30 days by product category

Cumulative Daily Revenue

Jan 1 - Jan 31

show me our cumulative revenue over the month of January

SKU Report: Total Sales & Percent Growth

Last 30 days

create a report of our total sales and % growth for each SKU over the last 30 days

Name

Nate Kelley

Blake Rouse

Gregory

Dallin Bentley

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

SKU

SKU-0959

SKU-0973

SKU-0183

SKU-1182

SKU-1115

SKU-0174

SKU-0183

SKU-0210

SKU-1197

SKU-0717

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Product

Chiquita Cavendish

Dole Cavendish

Goya Plantain

Frieda’s Burro

Chiquita Plantain

Chiquita Lady Finger

Dole Red Banana

Del Monte Cavendish

Tropicana Orange Juice

Free-Range Eggs

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Total Sales

$4,259

$4,227

$4,165

$4,054

$3,822

$3,801

$3,712

$3,709

$3,702

$3,675

1.3

1.3

1.3

1.3

Another name

Another name

Another name

% Growth

1.47%

8.11%

0.11%

8.05%

6.53%

-3.60%

-8.17%

-7.94%

2.64%

9.00%

Various Items

Various Items

Various Items

Various Items

Another name

Another name

Another name

Add content

Dashboards

Company KPIs

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Metrics

Daily Sales by Brand

Chart

Table

Last 7 days

What were our daily sales for each brand?

Daily Sales by Brand

Copilot

Styling

SQL

Certainly! Let's write some SQL to get you the daily sales for each brand you carry:

sql

Copy code

WITH monthly_sales AS (

SELECT

DISTINCT ON (DATE_TRUNC('month', ss.order_date), ss.brand_id)

DATE_TRUNC('month', ss.order_date) AS sales_month,

ss.brand_name,

SUM(ss.total_sales_amount) OVER (PARTITION BY DATE_TRUNC('month', ss.order_date), ss.brand_id) AS total_sales

FROM

public.sales_summary ss

WHERE

ss.order_date >= (CURRENT_DATE - INTERVAL '6 months')

)

SELECT

sales_month,

brand_name,

total_sales

FROM

monthly_sales

ORDER BY

sales_month ASC,

brand_name;

Let's now run this SQL to check the results it generates.

SQL ran successfully 0.47 seconds

Plotted data on a bar chart 0.61 seconds

That looks great. Feel free to follow up or ask how I got this.

show me our daily sales, broken

down by brand

Edit this metric or follow up...

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Company KPIs

A quick overview of our key metrics and performance indicators.

Monthly Sales by Sales Rep

Last 12 months

make a line chart of my monthly sales broken down by sales rep

Daily Sales by Brand

Last 30 days

show me our daily sales, broken down by brand

$14k

$10.5k

$7k

$3.5k

$0

Total Sales by Product Category

Last 30 days

break down our total sales for the last 30 days by product category

Cumulative Daily Revenue

Jan 1 - Jan 31

show me our cumulative revenue over the month of January

SKU Report: Total Sales & Percent Growth

Last 30 days

create a report of our total sales and % growth for each SKU over the last 30 days

Name

Nate Kelley

Blake Rouse

Gregory

Dallin Bentley

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Another name

SKU

SKU-0959

SKU-0973

SKU-0183

SKU-1182

SKU-1115

SKU-0174

SKU-0183

SKU-0210

SKU-1197

SKU-0717

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Product

Chiquita Cavendish

Dole Cavendish

Goya Plantain

Frieda’s Burro

Chiquita Plantain

Chiquita Lady Finger

Dole Red Banana

Del Monte Cavendish

Tropicana Orange Juice

Free-Range Eggs

Another name

Another name

Another name

Another name

Another name

Another name

Another name

Total Sales

$4,259

$4,227

$4,165

$4,054

$3,822

$3,801

$3,712

$3,709

$3,702

$3,675

1.3

1.3

1.3

1.3

Another name

Another name

Another name

% Growth

1.47%

8.11%

0.11%

8.05%

6.53%

-3.60%

-8.17%

-7.94%

2.64%

9.00%

Various Items

Various Items

Various Items

Various Items

Another name

Another name

Another name

Add content

Dashboards

Company KPIs

Recents

Who are our top customers bas...

how long does it take to ship a p...

show me our best selling produc..

do some analysis on category p...

line chart showing sales rep quot...

Metrics

Daily Sales by Brand

Chart

Table

Last 7 days

What were our daily sales for each brand?

Daily Sales by Brand

Copilot

Styling

SQL

Certainly! Let's write some SQL to get you the daily sales for each brand you carry:

sql

Copy code

WITH monthly_sales AS (

SELECT

DISTINCT ON (DATE_TRUNC('month', ss.order_date), ss.brand_id)

DATE_TRUNC('month', ss.order_date) AS sales_month,

ss.brand_name,

SUM(ss.total_sales_amount) OVER (PARTITION BY DATE_TRUNC('month', ss.order_date), ss.brand_id) AS total_sales

FROM

public.sales_summary ss

WHERE

ss.order_date >= (CURRENT_DATE - INTERVAL '6 months')

)

SELECT

sales_month,

brand_name,

total_sales

FROM

monthly_sales

ORDER BY

sales_month ASC,

brand_name;

Let's now run this SQL to check the results it generates.

SQL ran successfully 0.47 seconds

Plotted data on a bar chart 0.61 seconds

That looks great. Feel free to follow up or ask how I got this.

show me our daily sales, broken

down by brand

Edit this metric or follow up...

Don't be a bottleneck. Empower everyone to explore data with an AI data analyst.

What is Buster?

Buster is an AI data analyst, built to augment your data team

Turn your dbt project into an AI data analyst. Empower everyone at your company to analyze & visualize data on their own.

Watch demo

Watch demo

Watch demo

For data engineers

Buster helps data engineers deploy AI data analysts. It integrates seamlessly with dbt, brings AI tooling directly into your CLI, & much more.

For business operators

Buster gives business operators a personal AI data analyst to explore data on their own. Chat with your data, generate visualizations, & much more.

Customers

Top companies use Buster to augment their data team

Join top companies who leverage Buster to enhance their dbt workflows & get more from their data.

"A lot of data engineers think self serve is a myth. This is actually self serve, for real for real."

Alex Ahlstrom

Director of Data Analytics @ Angel Studios

"Buster frees me up from the little tasks I always had to do, and let's me focus on longer term goals."

Landen Bailey

Data Engineer @ Redo

Enterprise-grade security

Buster is built with enterprise-grade security practices. This includes state-of-the-art encryption, safe and reliable infrastructure partners, and independently verified security controls.

SOC 2 compliance

Buster has undergone a Service Organization Controls audit (SOC 2 Type II).

HIPAA compliance

Privacy & security measures to ensure that PHI is appropriately safeguarded.

Admin controls

Provision users, enforce granular permissions, & implement access controls with ease.

IP protection policy

Neither Buster nor our model partners train models on customer data.

BYO API keys

Bring your own API keys to use the LLM provider of your choice.

Open-source

Buster is completely open-source & available on GitHub.

Data is messy. It's duplicative. It's undocumented.

Data teams exist to solve this. But, instead of building clean & optimized data foundations, they end up fielding an infinite amount of data requests from business stakeholders.

These requests pile up until the data team becomes a bottleneck - slowing down the whole organization & taking the data team away from more meaningful work.

For the past two years, we’ve been helping data teams augment themselves with AI data analysts. This lets:

  1. data teams focus on turning raw data into consistent & robust data models.

  2. business operators reliably explore data on their own & make better decisions, faster.

If you want to take Buster for a spin, you can get started here.