01.3 Words we use
The words used across Xeplr Analytics, from connection and dataset to cube and job, in plain terms.
| Word | Meaning |
|---|---|
| Company | Your organisation in Analytics. Everything you see belongs to one company. |
| Workspace | An area inside a company, e.g. Sales. Holds its own datasets, reports and dashboards. |
| Connection | Analytics’s link to a database: address and login. |
| Table | Rows and columns stored in a database, like a spreadsheet tab. |
| Dataset | A saved recipe for rows: which tables, joined how, which columns, which filters. Reports read datasets. |
| Join | How two tables belong together, e.g. an order’s customer id matches a customer’s id. |
| Formula column | A column calculated from others, or a fixed value. |
| Aggregate | Adding rows up: SUM, COUNT, AVG, MIN, MAX. |
| Group by | The columns totals are split by, e.g. total sales by region. |
| Union / stack | Putting one set of rows under another. |
| Parameter | A named value like :region, filled in by a filter or a default. |
| Report | A table, pivot or chart built on datasets, with its own filters and formats. |
| Dimension | A column you group or split by: region, product, month. |
| Fact / measure | A column you add up: amount, quantity. |
| Pivot | A table with values spread across columns, e.g. months across the top. |
| Dashboard (board) | A page of widgets that share filters. |
| Widget | One table, chart or number on a dashboard. Each widget is a small report. |
| Model (on a dashboard) | The datasets a dashboard is allowed to use. |
| Import / upload | Loading a file into a table. |
| Move | Copying rows from one database to another, once or on a schedule. |
| Warehouse | Analytics’s own fast copies of your tables. |
| Cube | A pre-summarised copy of a large table, so dashboards answer instantly. |
| Build | Filling a cube with the latest summarised data. |
| Job | Something that runs on a schedule, e.g. rebuild the sales cube every night. |
| Workflow | Several steps run one after another. |
Next: 02.1 Connect a database
Last updated 12 October 2026