Oracle Database
Finance and operations answers from Oracle, with nothing to install.
Plain questions in, Oracle SQL out. Every query stays visible.
David Mensah9:41 AM
@Dot What are our 10 largest expense categories this year, and which grew fastest against last year?
1 reply
DotAPP9:42 AM
10 steps · 50s · Access Online
Travel grew fastest, up 38%, mostly from the sales team.
Source: Oracle Database’s GL_JE_LINES.
Here is the data.
| Category | This year | Change |
|---|---|---|
| Software | $11.2M | +9% |
| Facilities | $7.8M | +2% |
| Travel | $2.9M | +38% |
Today
David Mensah9:41 AM
Dot What are our 10 largest expense categories this year, and which grew fastest against last year?
Dot9:42 AM
10 steps · 50s · Access online
Travel grew fastest, up 38%, mostly from the sales team.
Source: Oracle Database’s GL_JE_LINES.
- Software: $11.2M this year, +9% change
- Facilities: $7.8M this year, +2% change
- Travel: $2.9M this year, +38% change
Sarah Chen9:41 AM
@Dot What’s our scrap rate by plant this quarter? Flag any plant above 3%.
1 reply
DotAPP9:42 AM
10 steps · 56s · Access Online
Monterrey and Gdansk. Across all plants it’s 2.4%.
Source: Oracle Database’s MFG_SCRAP.
Chart
Today
Sarah Chen9:41 AM
Dot What’s our scrap rate by plant this quarter? Flag any plant above 3%.
Dot9:42 AM
10 steps · 56s · Access online
Monterrey and Gdansk. Across all plants it’s 2.4%.
Source: Oracle Database’s MFG_SCRAP.
Ryan Ortiz9:41 AM
@Dot Which branches opened the most accounts last quarter, and how many were still active at 90 days?
1 reply
DotAPP9:42 AM
8 steps · 48s · Access Online
Downtown opened the most. Across all branches, 80% are still active.
Source: Oracle Database’s ACCOUNTS.
Here is the data.
| Branch | New accounts | Still active |
|---|---|---|
| Downtown | 1,140 | 82% |
| Riverside | 860 | 77% |
| Northgate | 720 | 85% |
Today
Ryan Ortiz9:41 AM
Dot Which branches opened the most accounts last quarter, and how many were still active at 90 days?
Dot9:42 AM
8 steps · 48s · Access online
Downtown opened the most. Across all branches, 80% are still active.
Source: Oracle Database’s ACCOUNTS.
- Downtown: 1,140 new accounts, 82% still active
- Riverside: 860 new accounts, 77% still active
- Northgate: 720 new accounts, 85% still active
More in Databases & spreadsheets
Snowflake
BigQuery
Redshift
Postgres
AWS Athena
Databricks SQL
Microsoft SQL
MySQL
Connect your data.
Start for Free