Everything from source database to scorecard
Each step builds on the one before it, so every number in every dashboard comes from the same definitions.
Connect
Connect the databases you already run
Add SQL Server, Azure SQL, PostgreSQL, MySQL/MariaDB or Oracle as a Data Source. No database? Upload a CSV file in three steps: choose the file, check its headers, load it into your schema.
DAILY OPERATIONS
- Data Scientist
- Information Delivery
- Master Data
- Business Performance
SYSTEM SETUP
- Setup
- Data Sources
- Data Views
- Data Jobs
- Integrations
- Roles
- Users
SetupData Sources
Data Sources
Named connections that Data Views read from.
| Name | Type | Server | Status |
|---|---|---|---|
| Warehouse DB | PostgreSQL | pg.example.com | Connected |
| Finance DB | Azure SQL | finance.example.com | Connected |
New Data Source
1. Choose a type
2. Connection details
NameSales DB
Serversql.example.com
Databasesales
Curate
Data Views: curated datasets, kept fresh
A Data View is a named query over a Data Source, published to a schema. Reload it on demand or with a multi-step refresh job, and see when each one last reloaded. Open any view in a grid to sort, filter and export to Excel.
DAILY OPERATIONS
- Data Scientist
- Data Views
- OLAP
- Semantic Models
- Upload Data
- Information Delivery
- Master Data
- Business Performance
SYSTEM SETUP
- Setup
- Roles
- Users
Data Views
Sales Demo Views
Manage curated Data Views for exploration, refresh and delivery.
Sales_Orders
Reload completed in 1 minute(s).
OpenRefresh
Customers
Reload completed in 1 minute(s).
OpenRefresh
Products
Reload completed in 1 minute(s).
OpenRefresh
Regions_Targets
Reload completed in 1 minute(s).
OpenRefresh
Inventory_Levels
Reload completed in 1 minute(s).
OpenRefresh
Budget_2026
Reload started at 9:40 AM.
OpenRefresh
Model
Semantic Models: define your metrics once
Lay out Data Views on a canvas, mark each as a fact or dimension table and draw the relationships. Create measures with sum, average, count or your own formula, validate the model and publish it.
DAILY OPERATIONS
- Data Scientist
- Data Views
- OLAP
- Semantic Models
- Upload Data
- Information Delivery
- Master Data
- Business Performance
SYSTEM SETUP
- Setup
- Roles
- Users
Semantic ModelsSales Model
Sales Model
Join Data Views once and share the same measures in every report.
Sales_OrdersFACT
- Order_ID
- Order_Date
- Customer_ID
- Product_ID
- Region_ID
- Revenue
- Cost
Customers
- Customer_ID
- Segment
- Country
1 → ∞ Sales_Orders
Products
- Product_ID
- Category
- Brand_Group
1 → ∞ Sales_Orders
Regions
- Region_ID
- Region
- Country
1 → ∞ Sales_Orders
Calendar
- Date
- Month
- Quarter
- Year
1 → ∞ Sales_Orders
Measures
AddRevenue
Sum(Revenue)
Orders
Count(Order_ID)
Avg order value
Revenue / Orders
Gross margin %
(Revenue − Cost) / Revenue
4 relationships · 4 measures · no errors
Explore
OLAP: slice and pivot without SQL
Pick a Data View, drag fields into filters, rows, columns and values, add calculated fields and totals, switch between grid and chart, then save the report or export it.
DAILY OPERATIONS
- Data Scientist
- Data Views
- OLAP
- Semantic Models
- Upload Data
- Information Delivery
- Master Data
- Business Performance
SYSTEM SETUP
- Setup
- Roles
- Users
OLAP Analysis
Sales Demo Data Analysis
Explore Data Views by any dimension and publish what you find.
| Sum of Orders | Channel | |||
|---|---|---|---|---|
| Region | Retail | Wholesale | Online | Grand Total |
| Riyadh | 2,610 | 1,880 | 750 | 5,240 |
| Cairo | 2,300 | 1,410 | 700 | 4,410 |
| Jeddah | 1,720 | 1,290 | 540 | 3,550 |
| Dubai | 1,350 | 1,060 | 610 | 3,020 |
| Alexandria | 1,240 | 700 | 260 | 2,200 |
| Grand Total | 9,220 | 6,340 | 2,860 | 18,420 |
Drag fields between Rows, Columns and Values to reshape the pivot. Totals update as you go.
Field List
Calculated FieldAll Fields
- Order_Date
- Region
- Channel
- Product_Category
- Orders
- Revenue
- Cost
Filters
Drop filter here
Columns
ChannelRows
RegionValues
Sum of OrdersVisualise
Dashboards your team builds itself
Choose from 16 widget types: bar, column, line, area, pie, scatter, stacked bar, column and area, combo, KPI card, gauge, waterfall, heatmap, data table and text box. Viewers filter, go fullscreen and export the dashboard or any chart to PNG or PDF.
Dashboard Builder
Sales Performance · design and configure your dashboard
WIDGET LIBRARY
Search widgets…
Charts
Stacked charts
KPIs & metrics
Revenue by Region
Gross margin
31.4%
▲ 1.2 pts vs last year
Orders by Channel
RetailWholesaleOnline
Forecast
AI on every chart
Predict and Insights buttons sit on each chart, Ask dots answers questions about your data, and the dots MCP server connects the AI assistant you already use.
See dots AIDAILY OPERATIONS
- Data Scientist
- Information Delivery
- Dashboards
- Reports
- Master Data
- Business Performance
SYSTEM SETUP
- Setup
- Roles
- Users
DashboardsSales Performance
Sales Performance
Track revenue, orders and margin across regions and channels.
Monthly Revenue
Revenue (SAR k)Forecast with confidence range
dots Predictor - Monthly Revenue
1. Forecast summary
Revenue has grown steadily over the last 12 months, from SAR 820k in November 2025 to SAR 1,240k in October 2026. The trend points to a seasonal peak of SAR 1,310k in December, followed by a dip to SAR 1,250k in January.
2. Predictions (next 3 periods)
| Period | Predicted | Confidence range | Change vs previous |
|---|---|---|---|
| 2026-11 | SAR 1,270k | 1,190k – 1,350k (±6%) | +2.4% vs 2026-10 |
| 2026-12 | SAR 1,310k | 1,200k – 1,420k (±8%) | +3.1% vs 2026-11 |
| 2027-01 | SAR 1,250k | 1,110k – 1,390k (±11%) | −4.6% vs 2026-12 |
3. Scenarios
- Base SAR 3.83M over the three months, in line with the trend.
- Upside SAR 4.16M if December demand holds into January.
- Downside SAR 3.50M if the January dip starts in December.
Measure
A balanced scorecard on your own data
Set perspectives, objectives and KPIs with weights. Each KPI has a period, aggregation, formula, target and red/green thresholds, calculated from a Data View, and rolls up to one overall score with its history.
DAILY OPERATIONS
- Data Scientist
- Information Delivery
- Master Data
- Business Performance
- Perspectives
- Objectives
- KPIs
SYSTEM SETUP
- Setup
- Roles
- Users
Business PerformanceBalanced Scorecard
Balanced Scorecard
Track strategic objectives and KPI progress across the organisation.
Overall Performance
- 18 on track
- 6 at risk
- 24 KPIs
Historical Performance
Jan – Oct 2026
Balanced Scorecard
4 perspectives · 11 objectives · 24 KPIs
- 88%WEIGHT30%
Financial
3 objectives
- 79%WEIGHT25%
Customer
3 objectives
- 76%WEIGHT25%
Internal process
3 objectives
- 84%WEIGHT20%
Learning & growth
2 objectives
Master data without a developer ticket
Define reference tables and the relations between them, then add and edit rows from the browser.
Arabic or English, desk or phone
Switch dots to Arabic and every page mirrors right to left, charts and tables included. Dashboards and the scorecard fit a phone screen, so you can check them between meetings.
العمليات اليومية
- عالم البيانات
- توصيل المعلومات
- لوحات المعلومات
- التقارير
- البيانات الرئيسية
- أداء الأعمال
إعداد النظام
- الإعداد
- الأدوار
- المستخدمون
لوحات المعلوماتأداء المبيعات
أداء المبيعات
تابع الإيرادات والطلبات والهامش حسب المنطقة والقناة.
إجمالي الإيرادات
11.99 مليون ر.س
▲ 9% مقارنة بالعام الماضي
عدد الطلبات
18,420
▲ 6% مقارنة بالعام الماضي
متوسط قيمة الطلب
651 ر.س
▲ 3% مقارنة بالعام الماضي
هامش الربح الإجمالي
31.4%
▲ 1.2 نقطة مقارنة بالعام الماضي
متوسط أيام التحصيل
41 يومًا
▼ 3 مقارنة بالعام الماضي
الإيرادات الشهرية
الإيرادات (ألف ر.س)
الإيرادات حسب المنطقة
الإيرادات (مليون ر.س)
9:41
Business Performance
Balanced Scorecard
- 18 on track
- 6 at risk
- 24 KPIs
Total revenue
11.99M SAR
▲ 9% vs last year
Orders
18,420
▲ 6% vs last year
Monthly Revenue
PredictPerspectives
- Financial88%
- Customer79%
- Internal process76%
Your servers or Microsoft Azure
Run dots on Microsoft Azure or on servers you control, with access scoped per user by schema and page-level roles.
Deployment and accessSee dots in action
A 20-second tour of dots, with music. Press play to start; nothing plays on its own.
The tour shows dots Predictor forecasting with honest ranges, bringing your own AI through the dots MCP server, and the app in Arabic or English on desktop and phone, using sample data. It has music and no speech.
See dots on your kind of data
Tell us what you report on today. We'll show you how it would work in dots.