GPS Tracking & Movement Analysis

A project that turns raw GPS pings from financed trucks and trailers into clear movement stories: where units are, how they move, when they stop reporting, and which assets need attention first.

Project Overview

GPS data arrives as thousands of individual pings spread across vendor portals. Used this way, it is slow and painful to answer simple questions like "where is this unit now?" or "how long has it been inactive?".

This project centralizes GPS exports, cleans the feeds, maps devices to stock numbers and deals, and exposes movement patterns through Power BI dashboards that collections, repo and management can actually use.

Main Features

  • Daily ingestion of GPS CSV/API exports with device ID, timestamp, coordinates and status.
  • Automated mapping between device IDs, inventory records, VINs and active deals.
  • Non-reporting bands (24h / 48h / 72h+) surfaced as a watchlist instead of raw files.
  • Unit-level movement timelines showing trips, stops and long inactivity periods.
  • Filters by region, unit type, risk level and repo status to prioritize work.
  • Consistent structure so the same dashboard supports collections, repo and management reviews.

Key Components

Movement & Status Dashboard

Portfolio view of last location, last movement, city/state and non-reporting tiers (24h, 48h, 72h+).

Device & Inventory Mapping

Standardizes device IDs and links them to stock numbers, VINs and active deals so internal and GPS views match.

Collections Support

Designed around the real questions from collections and repo: where is the unit, since when, and what changed versus last week.

Operational Impact

Before this project, GPS data was checked manually in separate vendor portals, making it slow and inconsistent to prepare a single case. With a unified model and dashboards, the team can see location, last movement and non-reporting status for every asset in seconds, work from a ranked list of problematic units, and keep a movement history that can be revisited during disputes or negotiations.

Sample Pictures