Microsoft Fabric
Your Fabric warehouses and lakehouses, open to every question your team has.
Every answer shows the SQL Dot ran against your Fabric endpoint.
Daniel Weber9:41 AM
@Dot How do this quarter’s Dynamics sales compare with the same point last year, by region?
1 reply
DotAPP9:42 AM
6 steps · 32s · Access Online
$18.4M, up 9%. North America is up 17%; EMEA is down 6%.
Source: Microsoft Fabric’s dynamics.sales.
Chart
Today
Daniel Weber9:41 AM
Dot How do this quarter’s Dynamics sales compare with the same point last year, by region?
Dot9:42 AM
6 steps · 32s · Access online
$18.4M, up 9%. North America is up 17%; EMEA is down 6%.
Source: Microsoft Fabric’s dynamics.sales.
Lisa Park9:41 AM
@Dot What was our employee turnover by department over the last 12 months?
1 reply
DotAPP9:42 AM
4 steps · 24s · Access Online
11.2% overall; half of those who left had joined within a year.
Source: Microsoft Fabric’s hr.employees.
Chart
Today
Lisa Park9:41 AM
Dot What was our employee turnover by department over the last 12 months?
Dot9:42 AM
4 steps · 24s · Access online
11.2% overall; half of those who left had joined within a year.
Source: Microsoft Fabric’s hr.employees.
David Mensah9:41 AM
@Dot How long do field service work orders take to close in each region?
1 reply
DotAPP9:42 AM
4 steps · 28s · Access Online
3.2 days on average. The North takes 5.1 days, mostly waiting on parts.
Source: Microsoft Fabric’s fieldservice.workorders.
Here is the data.
| Region | Days to close | Waiting on parts |
|---|---|---|
| North | 5.1 | 62% |
| South | 2.8 | 31% |
| West | 2.6 | 28% |
Today
David Mensah9:41 AM
Dot How long do field service work orders take to close in each region?
Dot9:42 AM
4 steps · 28s · Access online
3.2 days on average. The North takes 5.1 days, mostly waiting on parts.
Source: Microsoft Fabric’s fieldservice.workorders.
- North: 5.1 days to close, 62% waiting on parts
- South: 2.8 days to close, 31% waiting on parts
- West: 2.6 days to close, 28% waiting on parts
More in Databases & spreadsheets
Snowflake
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
Connect your data.
Start for Free