Azure Analysis Services
Your tabular models answer the question.
Dot queries your Analysis Services models and reuses their DAX measures.
David Mensah9:41 AM
@Dot How did operating expenses by cost center compare with budget last month?
1 reply
DotAPP9:42 AM
7 steps · 42s · Access Online
Opex was $3.8M, 4% under budget. Only IT ran over.
Source: Azure Analysis Services’ [Opex], [Budget].
Here is the data.
| Cost center | Actual | Against budget |
|---|---|---|
| IT | $1.2M | +9% |
| Marketing | $0.9M | −3% |
| Facilities | $0.6M | −12% |
Today
David Mensah9:41 AM
Dot How did operating expenses by cost center compare with budget last month?
Dot9:42 AM
7 steps · 42s · Access online
Opex was $3.8M, 4% under budget. Only IT ran over.
Source: Azure Analysis Services’ [Opex], [Budget].
- IT: $1.2M actual, +9% against budget
- Marketing: $0.9M actual, −3% against budget
- Facilities: $0.6M actual, −12% against budget
Sarah Chen9:41 AM
@Dot Which product lines beat their sales plan last month?
1 reply
DotAPP9:42 AM
5 steps · 34s · Access Online
5 of 8 did, putting sales 6% over plan.
Source: Azure Analysis Services’ [Sales], [Sales Plan].
Here is the data.
| Product line | Of plan |
|---|---|
| Lighting | 127% |
| Furniture | 108% |
| Textiles | 81% |
Today
Sarah Chen9:41 AM
Dot Which product lines beat their sales plan last month?
Dot9:42 AM
5 steps · 34s · Access online
5 of 8 did, putting sales 6% over plan.
Source: Azure Analysis Services’ [Sales], [Sales Plan].
- Lighting: 127% of plan
- Furniture: 108% of plan
- Textiles: 81% of plan
Ryan Ortiz9:41 AM
@Dot What share of this year’s revenue came from products launched this year?
1 reply
DotAPP9:42 AM
8 steps · 41s · Access Online
8%, and the Lite range alone brought in $2.7M.
Source: Azure Analysis Services’ [Revenue].
Chart
Today
Ryan Ortiz9:41 AM
Dot What share of this year’s revenue came from products launched this year?
Dot9:42 AM
8 steps · 41s · Access online
8%, and the Lite range alone brought in $2.7M.
Source: Azure Analysis Services’ [Revenue].
Looker
Power BI
dbt
Cube
Steep
Malloy
Connect your data.
Start for Free