Microsoft SQL
Ask SQL Server or Azure SQL about orders, suppliers and cash.
Questions become T-SQL, and you can open the query behind any answer.
Sarah Chen9:41 AM
@Dot Which suppliers delivered more than 10% of our purchase orders late this year?
1 reply
DotAPP9:42 AM
5 steps · 37s · Access Online
Four suppliers, with 92 late orders between them.
Source: Microsoft SQL’s dbo.PurchaseOrders.
Here is the data.
| Supplier | Late | Orders |
|---|---|---|
| Halden Parts | 23% | 140 |
| Norvik Steel | 16% | 212 |
| Arco Plastics | 13% | 98 |
Today
Sarah Chen9:41 AM
Dot Which suppliers delivered more than 10% of our purchase orders late this year?
Dot9:42 AM
5 steps · 37s · Access online
Four suppliers, with 92 late orders between them.
Source: Microsoft SQL’s dbo.PurchaseOrders.
- Halden Parts: 23% late, 140 orders
- Norvik Steel: 16% late, 212 orders
- Arco Plastics: 13% late, 98 orders
Ryan Ortiz9:41 AM
@Dot Show our days sales outstanding by month for the past year, split by business unit.
1 reply
DotAPP9:42 AM
5 steps · 28s · Access Online
DSO is up 11 days to 52, mostly in the Services unit.
Source: Microsoft SQL’s dbo.Invoices.
Chart
Today
Ryan Ortiz9:41 AM
Dot Show our days sales outstanding by month for the past year, split by business unit.
Dot9:42 AM
5 steps · 28s · Access online
DSO is up 11 days to 52, mostly in the Services unit.
Source: Microsoft SQL’s dbo.Invoices.
Priya Shah9:41 AM
@Dot What was our average call handling time by support team last week, and which team improved most?
1 reply
DotAPP9:42 AM
8 steps · 49s · Access Online
6 minutes 40 seconds on average. Billing support improved most, down 75 seconds.
Source: Microsoft SQL’s dbo.Calls.
Here is the data.
| Team | Handling time | Change |
|---|---|---|
| Billing support | 5:50 | −1:15 |
| Technical | 8:10 | −0:20 |
| Sales support | 6:05 | +0:10 |
Today
Priya Shah9:41 AM
Dot What was our average call handling time by support team last week, and which team improved most?
Dot9:42 AM
8 steps · 49s · Access online
6 minutes 40 seconds on average. Billing support improved most, down 75 seconds.
Source: Microsoft SQL’s dbo.Calls.
- Billing support: 5:50 handling time, −1:15 change
- Technical: 8:10 handling time, −0:20 change
- Sales support: 6:05 handling time, +0:10 change
More in Databases & spreadsheets
Snowflake
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
MySQL
MotherDuck
Connect your data.
Start for Free