Power BI
Get the same numbers as Power BI, then move your reports to Dot.
01
Dot answers with your measures
Your semantic models and reports.
Sarah Chen9:41 AM
@Dot Which product line’s gross margin slipped most last quarter?
1 reply
DotAPP9:42 AM
9 steps · 46s · Access Online
Hardware, down 3.1 points on higher component costs.
Source: Power BI’s [Gross Margin %].
Here is the data.
| Product line | Gross margin | Change |
|---|---|---|
| Hardware | 28.4% | −3.1 pts |
| Software | 78.9% | −0.4 pts |
| Services | 36.2% | +0.6 pts |
Today
Sarah Chen9:41 AM
Dot Which product line’s gross margin slipped most last quarter?
Dot9:42 AM
9 steps · 46s · Access online
Hardware, down 3.1 points on higher component costs.
Source: Power BI’s [Gross Margin %].
- Hardware: 28.4% gross margin, −3.1 pts change
- Software: 78.9% gross margin, −0.4 pts change
- Services: 36.2% gross margin, +0.6 pts change
Ryan Ortiz9:41 AM
@Dot What does the On-Time Delivery visual in the Ops report show for EMEA this year?
1 reply
DotAPP9:42 AM
4 steps · 23s · Access Online
92.4%, the lowest of any region.
Source: Power BI’s Ops report.
Chart
Today
Ryan Ortiz9:41 AM
Dot What does the On-Time Delivery visual in the Ops report show for EMEA this year?
Dot9:42 AM
4 steps · 23s · Access online
92.4%, the lowest of any region.
Source: Power BI’s Ops report.
Priya Shah9:41 AM
@Dot How is Net Revenue calculated in our Finance model?
1 reply
DotAPP9:42 AM
7 steps · 41s · Access Online
Sales minus returns and discounts, without intercompany sales.
Source: Power BI’s Finance model.
Here is the data.
| Net Revenue | From |
|---|---|
| Sales | FactSales |
| Minus returns and discounts | FactSales |
| Without intercompany | DimCustomer |
Today
Priya Shah9:41 AM
Dot How is Net Revenue calculated in our Finance model?
Dot9:42 AM
7 steps · 41s · Access online
Sales minus returns and discounts, without intercompany sales.
Source: Power BI’s Finance model.
- Sales: FactSales
- Minus returns and discounts: FactSales
- Without intercompany: DimCustomer
02
Rebuild reports in Dot
Checked visual by visual against Power BI.
Ryan Ortiz9:41 AM
@Dot Turn our Sales Overview report into a Dot dashboard.
1 reply
DotAPP9:42 AM
5 steps · 29s · Access Online
All but one visual matches; that one is off by rounding.
Source: Power BI’s Sales Overview.
- Revenue
- $4.82M
- Orders
- 12,940
- Average order
- $372
Today
Ryan Ortiz9:41 AM
Dot Turn our Sales Overview report into a Dot dashboard.
Dot9:42 AM
5 steps · 29s · Access online
All but one visual matches; that one is off by rounding.
Source: Power BI’s Sales Overview.
- Revenue
- $4.82M
- Orders
- 12,940
- Average order
- $372
Priya Shah9:41 AM
@Dot Rebuild our Inventory report, then alert me when any product drops below 50 units.
1 reply
DotAPP9:42 AM
8 steps · 45s · Access Online
Rebuilt with 12 visuals. Alert set.
Source: Power BI’s Inventory.
Today
Priya Shah9:41 AM
Dot Rebuild our Inventory report, then alert me when any product drops below 50 units.
Dot9:42 AM
8 steps · 45s · Access online
Rebuilt with 12 visuals. Alert set.
Source: Power BI’s Inventory.
Daniel Weber9:41 AM
@Dot Rebuild Board KPIs with a business unit filter.
1 reply
DotAPP9:42 AM
8 steps · 47s · Access Online
Rebuilt, and every visual matches.
Source: Power BI’s Board KPIs.
- ARR
- $48.2M
- Net retention
- 112%
- Gross margin
- 41.2%
Today
Daniel Weber9:41 AM
Dot Rebuild Board KPIs with a business unit filter.
Dot9:42 AM
8 steps · 47s · Access online
Rebuilt, and every visual matches.
Source: Power BI’s Board KPIs.
- ARR
- $48.2M
- Net retention
- 112%
- Gross margin
- 41.2%
More in Semantic layers
Looker
dbt
Cube
Steep
Malloy
Azure Analysis Services
Connect your data.
Start for Free