Aa
Contrast
Text size

Blog

Escaping Data Chaos

Why your data infrastructure undermines your expertise, and how to fix it. Three heads, twelve problems.

The stories in this series are composites of real projects, anonymized.

Start here

The Three Headed Monster

The framework behind the series: three heads, twelve problems.

Read on LinkedIn

Head One: Where the Chaos Starts

Data In: how errors enter early and compound at every step.

Read on LinkedIn

Head Two: The Part That Eats Your Weeks

Data Work: the effort that starts from zero every cycle.

Read on LinkedIn

Head Three: When Brilliant Science Looks Amateur

Data Out: why your impact stays locked away.

Read on LinkedIn

Transforming Chaos to Clarity

The governance and architecture framework behind the series.

Read on LinkedIn

Data In

Garbage in, chaos throughout.

Without systematic intake and validation, errors slip through early and compound at every step.

Data In

The Format Free for All

One team entered a sea urchin, Paracentrotus lividus, as "spiky thing (purple)". An infrastructure problem, not a people problem.

Read on LinkedIn

Data In

Validation Arrives Too Late

Six months of physically impossible dissolved oxygen readings, because nobody checked at entry.

Read on LinkedIn

Data In

The Copy Paste Nightmare

Five years of monitoring data that could not be analyzed as a time series, because every phase used different units, schemas and column names.

Read on LinkedIn

Data In

The Map Nobody Can Read

Twelve years of spatial science reduced to one static screenshot and two weeks of coordinate system emails.

Read on LinkedIn

Data Work

Heroic effort that doesn't compound.

Every cycle starts from zero: scripts rebuilt, spreadsheets merged by hand, one person holding all the answers.

Data Work

The Analysis That Lives in One Person's Head

Forty three files, the most useful one named AAAAA.R, and eight weeks to work out which script did what.

Read on LinkedIn

Data Work

When Data Can't Leave Your System

One stakeholder asked for the same data three times in a month because they kept losing the email attachment.

Read on LinkedIn

Data Work

The Report That Eats Your Quarter

The same report rebuilt from scratch every quarter, same charts, same indicators.

Read on LinkedIn

Data Work

Your Decade of Science Is a PDF Nobody Can Find

Same river basin, same questions, five years on. The difference in citations was a public data portal.

Read on LinkedIn

Data Out

Your impact stays locked away.

Reports take weeks, stakeholders get attachments instead of portals, and when staff leave, institutional knowledge goes with them.

Data Out

The Documentation You'll Write After the Deadline

An EU grant application rejected on procedural grounds before anyone read the science.

Read on LinkedIn

Data Out

When People Leave, Their Systems Vanish

Ten years of data architecture in one person's head, and four months to reverse engineer it after she left.

Read on LinkedIn

Data Out

Your Archive Strategy Is Save It Somewhere

Six weeks and thousands of euros to partially recover five years of biodiversity data from a 2008 Access database.

Read on LinkedIn

Data Out

The Grant You Almost Won

A research group with stronger science lost to a competitor whose data infrastructure was better.

Read on LinkedIn