Bitbucket

Dot reads the code behind your numbers, straight from Bitbucket.

Dot opens a file only when a question needs it.

Threaddata-team

David Mensah9:41 AM

@Dot What retry rules does our payment service follow? How many failed payments recovered last month?

1 reply

DotAPP9:42 AM

9 steps · 52s · Access Online

Three retries over 7 days. Last month, 1,140 failed payments recovered, worth $57K.

Sources: Bitbucket’s payments/retry.go and payments.

Here is the data.

RetryAfterRecovered
First1 day620
Second3 days340
Third7 days180

Threaddata-team

Sarah Chen9:41 AM

@Dot How does our app decide an order ships free? How many orders did last month?

1 reply

DotAPP9:42 AM

5 steps · 30s · Access Online

Orders over $75 after discounts. 36% of last month’s orders shipped free, costing $62K.

Sources: Bitbucket’s checkout/shipping.ts and orders.

Chart

Threaddata-team

Ryan Ortiz9:41 AM

@Dot Which dbt models depend on stg_orders?

1 reply

DotAPP9:42 AM

8 steps · 48s · Access Online

Six: two facts and four marts built on them.

Source: Bitbucket’s models/.

Here is the data.

ModelBuilt on
fct_ordersstg_orders
fct_revenuefct_orders
mart_sales_dailyfct_revenue

More in Version control

Connect your data.

Start for Free