Visualize Intra- and Inter-Borough Travel

Quick Overview

Create a static or interactive visualization that distinguishes trips within a borough from trips across boroughs and explain the usage story it reveals.

Visualize Intra- and Inter-Borough Travel

Company: Capital One

Role: Software Engineer

Category: Analytics & Experimentation

Difficulty: medium

Interview Round: Online Assessment

# Visualize Intra- and Inter-Borough Travel Create a static or interactive visualization that helps a reader compare trips within one borough with trips crossing borough boundaries. Explain the story supported by the chart and the uncertainty or coverage limits that could change that story. ### Constraints & Assumptions - Borough labels must come from a documented spatial join or trusted zone mapping. - Missing coordinates and trips outside mapped areas must be counted. - Normalize when raw volume would merely reproduce borough population or dataset coverage. ### Clarifying Questions to Ask - Is the audience comparing absolute volume, share of trips, distance, fare, or time pattern? - Are exact origin and destination locations safe to display? - Should direction between boroughs be preserved? ```hint Match the chart to the comparison A flow matrix and a geographic map answer different questions; choose the one that makes the intended contrast easiest to verify. ``` ### What a Strong Answer Covers - Reproducible origin and destination borough assignment. - A chart with clear denominators, labels, ordering, and accessible color choices. - A specific evidence-backed narrative rather than decoration. - Missingness, privacy, and sensitivity checks. ### Follow-up Questions - How would you show changes by hour without overwhelming the reader? - How would conclusions change after normalizing by all pickups in each origin borough?

Overview: Create a static or interactive visualization that distinguishes trips within a borough from trips across boroughs and explain the usage story it reveals.

|Home/Analytics & Experimentation/Capital One
Capital One logo
Capital One
Sep 27, 2020
mediumSoftware EngineerOnline AssessmentAnalytics & Experimentation
1
0

Visualize Intra- and Inter-Borough Travel

Create a static or interactive visualization that helps a reader compare trips within one borough with trips crossing borough boundaries. Explain the story supported by the chart and the uncertainty or coverage limits that could change that story.

Constraints & Assumptions

  • Borough labels must come from a documented spatial join or trusted zone mapping.
  • Missing coordinates and trips outside mapped areas must be counted.
  • Normalize when raw volume would merely reproduce borough population or dataset coverage.

Clarifying Questions to Ask Guidance

  • Is the audience comparing absolute volume, share of trips, distance, fare, or time pattern?
  • Are exact origin and destination locations safe to display?
  • Should direction between boroughs be preserved?

What a Strong Answer Covers Guidance

  • Reproducible origin and destination borough assignment.
  • A chart with clear denominators, labels, ordering, and accessible color choices.
  • A specific evidence-backed narrative rather than decoration.
  • Missingness, privacy, and sensitivity checks.

Follow-up Questions Guidance

  • How would you show changes by hour without overwhelming the reader?
  • How would conclusions change after normalizing by all pickups in each origin borough?
Loading comments...