Open Data·Open Metrics
Open data · Dashboards · Analytics

Open data, made measurable.

Cities collect a staggering amount of data and then guard it like a dragon sitting on a hoard it will never spend. We pry it loose, scrub it clean, and turn it into charts a person can read before the coffee goes cold.

What we do

We turn public data into things people can actually use.

Open data is not a policy abstraction filed under Someday. It is a chart, a route, a number you can act on this afternoon. We find it, build with it, and show our work, footnotes and embarrassing dead ends included.

WORK / 01

Open datasets

Every city sits on a mountain of spreadsheets nobody was ever meant to see. We find the useful ones, translate them out of fluent Bureaucrat, and hand them back in a shape you can actually use.

WORK / 02

Dashboards

A transit feed is just a rumor until somebody draws it. We turn raw data into maps, charts, and live metrics that answer the one question anyone really has, which is whether the bus is coming or not.

WORK / 03

Analytics

Numbers do not explain themselves. They sit there looking official and hoping you will not ask questions. We ask the questions, including the rude one about who got left out of the dataset entirely.

WORK / 04

Field notes

Codefests, demos, and the occasional heated argument about how to format a date. We write down what we tried, what broke, and which dataset turned out to be quietly lying the whole time.

The thesis
The bus does not care about your feelings. It has a schedule, a location, and an opinion, and all three sit in a public database that almost nobody bothers to open. Reading it is the entire job.
Open Metrics · field manual · page one
Start here

Guides to building a dashboard people actually read.

The deep end of what we do, written up so you can copy it. Begin with the pillar, then follow whichever thread you need.

GUIDE / 01

Dashboard design

The full method, from choosing the one number that matters to laying it out so a glance carries meaning.

GUIDE / 02

Dashboard templates

Where to start when you would rather adapt a working file than build a grid from scratch.

GUIDE / 03

Executive dashboard

The six-tile leadership view, and the discipline of leaving almost everything off it.

GUIDE / 04

Power BI examples

Real report layouts worth borrowing, and the design tips that keep them readable.

From the log

Field notes, demos, and dataset digs.