Open source, AI-powered data workers
AI Digital Workers for data & analytics
AI Digital Workers for data & analytics
AI Digital Workers for data & analytics
Buster gives you a team of AI Workers that surface insights & constantly improve your data stack. It’s simple, modern & open-source.
Buster gives you a team of AI Workers that surface insights & constantly improve your data stack. It’s simple, modern & open-source.
Buster gives you a team of AI Workers that surface insights & constantly improve your data stack. It’s simple, modern & open-source.
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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...
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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...
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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
Daily Sales by Brand
Last 7 days
•
What were our daily sales for each brand?
Dole
$12,100
Frieda’s
$8,510
Goya
$8,112
Chiquita
$7,472
$14k
$10.5k
$7k
$3.5k
$0
Dataset:
Sales, Orders & Returns
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...
Home
Collections
Workspace
Metrics
Dashboards
Datasets
Terms & definitions
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