Case studies
Government & Air Cargo Logistics

Puerto Rico Air Trade Database for Rotate

Before a freight dashboard can tell anyone anything useful, the data underneath it has to be trustworthy. Here's a project where that was the whole job. Taking data from a large external source and turning it into numbers a business can rely on is the same problem most transport operators have with their own systems.

Rotate

Results & impact

8%

increase in healthcare exports from Puerto Rico

  • Successfully launched the Puerto Rico Life Sciences Air Cargo Community portal with an integrated trade database

  • 8% increase in healthcare exports from Puerto Rico following implementation

Client

Rotate

Location

Utrecht, The Netherlands (100% remote from Victoria, Australia)

Industry

Government & Air Cargo Logistics

Duration

15 days over 6 weeks

Team size

1 data engineer / data analyst

The challenge

Data Duality was tasked with designing and constructing a robust US air trade database underpinning Rotate's initiative for the Puerto Rico Air Cargo Community. The objective was to create a foundation of reliable, high-integrity trade data that would empower the Life Sciences Air Cargo Community dashboard for improved market and export insights.

We hired Mike to develop one of our first data pipelines, and he exceeded our expectations. He effectively combined his deep understanding of the air cargo industry with strong technical expertise to clean and optimise our data. Beyond delivering high-quality code, Mike proposed innovative solutions to complex challenges, enabling us to make well-informed decisions for the long run. His ability to balance technical efficiency with strategic foresight made a significant impact on our project.
Fabien B., VP of Product and Customer Success, Rotate

What this means for your operation

You're probably closer to that project's starting point than you'd think. The data you need already exists, in your telematics, your EWD, your fuel cards, your TMS and your job sheets. Half of it is locked behind systems that don't talk to each other, and nobody has joined it up or cleaned it, so nobody fully trusts it.

That sourcing, cleaning and reconciling is exactly what we do. Get the numbers clean and trustworthy, and you can price work with confidence, spot the runs that are losing money, and stop reconciling spreadsheets at 10 pm.

Start simple. Run smarter. Book a 30-minute chat and we'll tell you where your data is hiding.

Get in touch