More efficient tyre wear analysis through advanced data access and Qlik dashboards
Athlon
Transpas Power BI dashboard
We bring together orders, journeys and costs from Transpas in a single Power BI model by customer and vehicle. For Athlon, we made tyre usage across the fleet visible.
Athlon gains detailed insight into tyre use and wear patterns across its fleet
For Athlon, we developed a solution using Qlik, Python and Snowflake that provides detailed insight into tyre use and wear patterns across its fleet. The dashboards help the asset management team make strategic decisions based on data insights.
Which trips and customers actually make us money?
Transpas holds orders, trips and schedules; driver, fuel and vehicle costs are often stored elsewhere. To see what’s left per trip or customer, you have to export lists. A Power BI model shows revenue and costs side by side for each trip, customer and vehicle.
A Transpas dashboard shows revenue and costs for each trip
Revenue per trip and customer
Orders and invoiced amounts from Transpas, broken down by trip and customer, so you can see which customers and routes sustain each trip.
Costs per vehicle
Fuel, maintenance and driver hours from your own sources, linked to vehicles and trips, even when those sources sit outside Transpas.
Mileage and utilisation
Mileage from scheduling systems or on-board computers, and the utilisation of vehicles and drivers, by customer, location or period.
Fleet data you already have
Vehicle data alongside trips and costs, as we did for Athlon when we provided insight into tyre use and fleet wear and tear.
We agree on the cost of a trip with planning and finance before we load anything
-
Work out how to access the data
Which version of Transpas you use, where the data is stored and how we can access it with your supplier.
-
Definitions and initial model
Define what counts as a trip, an order and the cost per kilometre, then check one report against the invoices.
-
Go live and expand
Data refreshes and access permissions go live with a designated owner. On-board computer data, fuel or accounting follow.
Transpas standard reports or your own model: which is right for you?
A good fit if
You want to see the revenue and costs for each trip, customer or vehicle, and some of those costs sit outside Transpas, such as fuel, maintenance or payroll.
Not a good fit if
Transpas standard reports answer your questions and you don't need to bring in other sources. In that case, maintaining your own model would take more effort than it's worth.
What determines the scope
How data can be extracted from your Transpas installation, how many locations and sources are involved, how much historical data you want to see and who will manage the model.
Can Transpas provide data for reporting?
Art Systems does not publish public documentation on extracting Transpas data. The approach varies by installation; we'll work it out with you and your supplier before we make any promises.
Export files, a regular data feed or a data warehouse with all your transport data sources?
Exports and standard reports
Choose this if you have one location and a monthly overview is enough. It requires little setup, but involves manual work each reporting period and provides little historical data.
A regular data feed from Transpas
Choose this if you want to manage trips and margins daily. Our advice: agree a regular, automated data feed with your supplier and keep the historical data yourself.
A data warehouse
Choose this if Transpas is one of several sources, alongside on-board computers, fuel cards and accounting records. See building a data warehouse.
We’ve turned fleet and operational data into insights for decision-making before
Data Science Lab has worked with data and AI since 2016 and is a Microsoft Partner for Fabric. For Athlon, we provided insights into tyre consumption and wear across its fleet. For Ammega, we built Power BI dashboards and a Power BI app.
Your Transpas setup and the figures you’re missing for each trip: that’s where our first conversation starts
Stef Stoelwinder
Business DevelopmentStef is your first point of contact. In our first conversation, we’ll discuss your Transpas setup, your other data sources and the figures you’re missing for each trip.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
By trip, customer or vehicle: what do you want to see from Transpas?
Tell us which version of Transpas you use, what other data sources you have and which figures you're missing. We'll reply by email or suggest an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
It depends on your installation. Transpas is Art Systems’ transport management system, and Art Systems does not publish public documentation on an API or database access for reporting. So we work with you and your supplier to find out what access is available, then add a data-loading step beneath the Power BI model.
To see how we build a dashboard around the decision you need to make, read about Power BI dashboards.
Art Systems describes Transpas Enterprise as the latest generation of its TMS and Transpas CS as the first generation. There is also Transpas Online, a web portal where customers can view orders, invoices and statuses.
For reporting, the version determines where the data is stored and how you can access it. We establish this in our first conversation.
According to Art Systems, Transpas Enterprise lets you record transport orders, plan trips and all their activities, and view vehicle and driver availability in the resource schedule. You can export invoices to your accounting system.
We use this data to show revenue per order, customer and trip, as well as vehicle and driver utilisation.
Usually, some come from outside Transpas: fuel costs from fuel cards, maintenance costs from a workshop system, driver hours from payroll and mileage from the vehicle’s onboard computer. According to Art Systems, Transpas integrates with various onboard computer systems.
In the model, we link these costs to trips by vehicle, driver and date, and define how shared costs are allocated.
Usually, revenue and margin per trip, customer and route; vehicle and driver utilisation; loaded versus empty kilometres, if recorded; and orders that have not yet been invoiced.
For margin, cash flow and budget versus actuals, see the financial dashboard in Power BI.
According to Art Systems, Transpas integrates with financial software such as Exact, Twinfield, Visma, AFAS and Snelstart for automatic invoicing. In the model, we match Transpas invoices to accounting entries by order number and period, so transport and finance see the same totals.
See also Exact Online and Twinfield in Power BI.
In Power BI, row-level security restricts what each person can see. For example, a branch manager might see only their own branch. You show figures for individual drivers only to their managers. How we set up workspaces, permissions and refreshes is covered under Power BI consultant.
For more on data in transport, read about mobility and logistics.
When Transpas’s standard reports answer your questions and nobody needs to see costs from outside the TMS alongside them. Or when trips and orders are not recorded consistently: in that case, start with data quality.
If there is no workable way to extract data from your installation, we will tell you before any development begins.