Product

Reporting & Insights

Turn operational data into decisions with configurable dashboards, TQL-powered queries, and a complete audit trail.

Start Free Request a Demo

TQLDashboardsExcel exportAudit trailElasticsearch

TQL

Query language

Live

Dashboard tiles

Excel

Export available

∞

Audit trail depth

Every event in Transportial (every order, trip, vehicle movement, invoice, and user action) is recorded and queryable. The TQL-powered insights engine puts that data at your fingertips through configurable dashboards, without needing a data analyst or a separate BI tool.

Key highlights

TQL (Transportial Query Language): Query any entity using TQL, a SQL-like language with joins, filters, aggregations, and sorting. No SQL expertise required.
Configurable Insight widgets: Build dashboard tiles that show exactly the KPIs that matter: orders delivered today, revenue this month, fleet utilisation, average transit time, and more.
Resizable dashboard tiles: Arrange and resize widgets on your dashboard. Different users can have different dashboard configurations.
KPI home dashboard: The default home dashboard shows the most important operational KPIs at a glance: order counts by status, revenue vs. cost, fleet activity, and critical alerts.
Excel export: Any TQL query result can be exported to Excel for further analysis, sharing, or import into external tools.
Full audit trail: Every change to every entity (who changed it, what the previous value was, and when) is stored in an immutable audit log.

How it works

Ask a question in TQL
Write a query in TQL, Transportial's SQL-like query language, against any entity in the system: orders, trips, invoices, vehicles or users. Filters, joins, aggregations and sorting are all available.
Turn it into a widget
Save the query as an Insight widget: a number, table or chart that updates as your operation runs. Widgets can be created from scratch or adapted from existing ones.
Compose your dashboard
Arrange and resize widgets on your dashboard. Each role can have its own layout, so a planner watches unassigned orders while finance watches revenue against cost.
Export when needed
Any query result exports to Excel for further analysis or sharing. The data you see on screen is the data you get in the file.
Trace anything back
When a number looks wrong, the audit trail shows every change to every entity: who changed it, what the previous value was and when. Disputes end with a lookup, not a reconstruction.

Your operational data, queryable by the people who run the operation

Most transport companies know their data is in the TMS but can only reach it through canned reports or an analyst with database access. TQL closes that gap: it is a readable, SQL-like language over the live operational model, so the person asking the question can usually answer it themselves. How many orders per customer went out late last month, what is the average cost per lane, which vehicles sat idle on Fridays: each is a short query, not a ticket to IT.

Because TQL queries compile to real database queries server-side, the results reflect the operation as it is right now, not last night's export. The same language drives pricing rules and message-automation conditions elsewhere in the platform, so effort invested in learning it pays off in more than reporting.

Dashboards that match roles, not a one-size-fits-all overview

A dispatcher, a fleet manager and a finance controller need different numbers at 8 a.m. Transportial's dashboards are per-user compositions of Insight widgets: resizable tiles backed by TQL queries. The default home dashboard covers the operational basics, order counts by status, revenue against cost, fleet activity and critical alerts, and from there each role trims and extends it.

Widgets stay live as the operation runs, which changes how they are used: instead of a weekly report meeting, deviations are visible the day they happen. A tile showing unplanned consignments creeping up on a Thursday afternoon is a prompt to act, not a statistic to explain next Monday.

An audit trail that settles arguments

Every change to every entity in Transportial is written to an append-only audit log: the field, the previous value, the new value, the user and the timestamp. In practice this is less about compliance checkboxes and more about the daily disputes of logistics: who moved the delivery window, when was the price changed on this quote, did the driver's assignment change before or after the customer called.

Because the trail is immutable and complete, it also underpins customer-facing trust. When a customer questions an invoice line or a delivery time, you can answer from the record rather than memory, and the record does not depend on who happened to be in the office that day.

Technical details

TQL queries are compiled to PostgreSQL queries server-side. For production scale, Elasticsearch is used for full-text search and log aggregation. The audit trail writes to an append-only table.

Frequently asked questions

Do I need to know SQL to use TQL?

No. TQL reads like plain filters over the entities you already work with, and most users start by copying an existing widget's query and adjusting it. If you do know SQL, joins, aggregations and sorting work the way you expect.

Can different users have different dashboards?

Yes. Dashboards are configured per user: each person arranges and resizes their own widgets, so planners, fleet managers and finance each see the KPIs relevant to their role.

Can I export data to Excel or a BI tool?

Any TQL query result exports to Excel directly. For continuous feeds into an external BI or data-warehouse setup, the same data is available through the REST API.

How far back does the audit trail go?

The audit trail is append-only and kept for the life of the data: every change to every entity is recorded with the user, timestamp and previous value. There is no rolling window that quietly discards history.

Are reports real-time or based on nightly exports?

Real-time. Widgets query the live operational database, so a delivered consignment or paid invoice is reflected in the numbers as soon as it happens.

View all features

Transport Order Management Interactive Plan Board AI-Powered Trip Optimisation Fleet & Resource Management 3D Load Planning OpenMove Driver App Real-Time Vehicle Tracking Multi-Modal Routing Pricing Engine Invoicing & Financial Management Message Automations Document Management & Generation Integrated Email Inbox In-App Chat Customer & Business Portal Integration Framework Reporting & Insights Multi-Tenancy & White-Label Security & Access Control

Ready to put this to work?

Start free with full platform access, or talk to our team about your specific operation.

Start Free Book a Demo

Key highlights

TQL (Transportial Query Language): Query any entity using TQL, a SQL-like language with joins, filters, aggregations, and sorting. No SQL expertise required.

Configurable Insight widgets: Build dashboard tiles that show exactly the KPIs that matter: orders delivered today, revenue this month, fleet utilisation, average transit time, and more.

Resizable dashboard tiles: Arrange and resize widgets on your dashboard. Different users can have different dashboard configurations.

KPI home dashboard: The default home dashboard shows the most important operational KPIs at a glance: order counts by status, revenue vs. cost, fleet activity, and critical alerts.

Excel export: Any TQL query result can be exported to Excel for further analysis, sharing, or import into external tools.

Full audit trail: Every change to every entity (who changed it, what the previous value was, and when) is stored in an immutable audit log.

How it works

Ask a question in TQL

Write a query in TQL, Transportial's SQL-like query language, against any entity in the system: orders, trips, invoices, vehicles or users. Filters, joins, aggregations and sorting are all available.

Turn it into a widget

Save the query as an Insight widget: a number, table or chart that updates as your operation runs. Widgets can be created from scratch or adapted from existing ones.

Compose your dashboard

Arrange and resize widgets on your dashboard. Each role can have its own layout, so a planner watches unassigned orders while finance watches revenue against cost.

Export when needed

Any query result exports to Excel for further analysis or sharing. The data you see on screen is the data you get in the file.

Trace anything back

When a number looks wrong, the audit trail shows every change to every entity: who changed it, what the previous value was and when. Disputes end with a lookup, not a reconstruction.

Your operational data, queryable by the people who run the operation

Dashboards that match roles, not a one-size-fits-all overview

An audit trail that settles arguments

Frequently asked questions

Do I need to know SQL to use TQL?

Can different users have different dashboards?

Yes. Dashboards are configured per user: each person arranges and resizes their own widgets, so planners, fleet managers and finance each see the KPIs relevant to their role.

Can I export data to Excel or a BI tool?

Any TQL query result exports to Excel directly. For continuous feeds into an external BI or data-warehouse setup, the same data is available through the REST API.

How far back does the audit trail go?

Are reports real-time or based on nightly exports?

Real-time. Widgets query the live operational database, so a delivered consignment or paid invoice is reflected in the numbers as soon as it happens.

Reporting & Insights

Key highlights

How it works

Ask a question in TQL

Turn it into a widget

Compose your dashboard

Export when needed

Trace anything back

Your operational data, queryable by the people who run the operation

Dashboards that match roles, not a one-size-fits-all overview

An audit trail that settles arguments

Frequently asked questions

Do I need to know SQL to use TQL?

Can different users have different dashboards?

Can I export data to Excel or a BI tool?

How far back does the audit trail go?

Are reports real-time or based on nightly exports?

Related features

Pricing Engine

Invoicing & Financial Management

Integration Framework

Ready to put this to work?

Reporting & Insights

Key highlights

How it works

Ask a question in TQL

Turn it into a widget

Compose your dashboard

Export when needed

Trace anything back

Your operational data, queryable by the people who run the operation

Dashboards that match roles, not a one-size-fits-all overview

An audit trail that settles arguments

Frequently asked questions

Do I need to know SQL to use TQL?

Can different users have different dashboards?

Can I export data to Excel or a BI tool?

How far back does the audit trail go?

Are reports real-time or based on nightly exports?

Related features

Pricing Engine

Invoicing & Financial Management

Integration Framework

Ready to put this to work?