← Back to Portfolio

Mobile Ads Car Analytics

Route cost intelligence and real-time analytics platform for mobile advertising vehicles.

Inspiration

Years ago during a traffic jam, I saw a mobile advertising car stuck on the road. That moment sparked a question: what happens to advertising cost efficiency when the vehicle never reaches its destination on time?

If delays increase operational cost, businesses need a way to predict, analyze, and optimize route expenses before deployment. This project was built to solve that problem for mobile advertising fleets.

What It Does

How It Was Built

Key Analytical Capabilities

Driver Cost Comparison

The system can compare route cost between multiple vehicles with different pricing models.

Returns:

Trip Intelligence

Fuel Cost Analysis

Supports multiple pricing models: Outputs:

Prompt Examples

Calculate total driver cost for Car 1 if rate is $0.22 per 10 km. Return waypoint table with: distance | from | to | cost Compare with Car 2 if rate is $0.30 per 20 km. Return difference and identify most expensive vehicle.
Calculate fuel cost for latest trip of Car 1 Fuel price = $3 per 18 km Return table + total cost
Generate graph coordinates for Car 2 x = cumulative distance y = cost per leg (not cumulative)

Challenges

Accomplishments

Built a fully working analytics engine capable of predicting route costs, analyzing driver efficiency, and comparing operational expenses across vehicles in real time.

Technology Used

Project Resources

View Source Code
View Source Code
View Source Code
View Source Code
View Source Code

Future Improvements