Stan Tyan

Data visualization

My Uber Rides

A personal data project that connected Uber ride history to Google Sheets and Tableau for daily-updated visual analysis.

Published

January 27, 2018

Technologies

Uber Riders API · Google Sheets · Tableau

Why the project existed

This project started as something built for fun, curiosity, and self-learning. It was a personal data project, and also a compact example of lightweight analytics engineering.

The aim was simple: collect ride data automatically, enrich it, and look for patterns that would be hard to see from the raw trip history alone.

How the pipeline worked

The workflow was:

  1. An Uber account was connected to Google Sheets through the Uber Riders API.
  2. Completed rides were added to the sheet automatically.
  3. Additional attributes and dimensions were created with spreadsheet formulas and functions.
  4. Tableau was used to slice the data from different perspectives and contexts.

That workflow sits somewhere between personal logging and a miniature BI stack. The tools are light, but the pattern is familiar: automate collection, enrich the data, then make it explorable.

Preview of the My Uber Rides Tableau dashboard.

This Tableau Public dashboard is blocked until external media is allowed.

Open on Tableau Public

What the dashboard showed

The dashboard sliced the ride data by recent activity, trip type, timing, price, and other dimensions that were easier to inspect visually than in the raw trip log.

The point was to explore the ride history from several angles and surface trends, relationships, and patterns that would otherwise stay buried in the data.